pgsql-performance - March 2014

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 6 7 8 9 10 11 13 14 17 18 19 20 21 22 23 24 25 26 27 29 30 31

March 2, 2014

Thread Author Time
Re: Help with optimizing a query over hierarchical data Claudio Freire 01:02

March 3, 2014

Thread Author Time
Re: Query taking long time acanada 10:17
Re: Query taking long time Vladimir Sitnikov 17:17
Re: Help with optimizing a query over hierarchical data Damon Snyder 17:55
Help me understand why my subselect is an order of magnitude faster than my nested joins Eli Naeher 18:24
Subselect an order of magnitude faster than nested joins Eli Naeher 18:55
Re: Help with optimizing a query over hierarchical data Claudio Freire 21:52
Re: Query taking long time Venkata Balaji Nagothi 23:28

March 4, 2014

Thread Author Time
Re: Help with optimizing a query over hierarchical data Damon Snyder 01:12
Re: Help with optimizing a query over hierarchical data Claudio Freire 04:20
Re: Query taking long time acanada 10:10
Re: Query taking long time acanada 11:23
Re: Help with optimizing a query over hierarchical data Damon Snyder 17:06
Re: Query taking long time Venkata Balaji Nagothi 23:35

March 6, 2014

Thread Author Time
Re: Optimal settings for RAID controller - optimized for writes Merlin Moncure 00:34
Re: Query taking long time acanada 10:47
Re: Query taking long time desmodemone 13:11
Re: Query taking long time acanada 14:45

March 7, 2014

Thread Author Time
Slow query Bikram Kesari Naik 06:05
Re: Slow query David Johnston 06:23
Re: Slow query Bikram Kesari Naik 06:43
Re: Slow query David Johnston 07:18
Re: Query taking long time Evgeniy Shishkin 09:39
Re: Query taking long time acanada 09:46
Re: Query taking long time Evgeniy Shishkin 10:03
Re: Query taking long time acanada 10:18

March 8, 2014

Thread Author Time
How can I get the query planner to use a bitmap index scap instead of an index scan ? Mohan Krishnan 02:46

March 9, 2014

Thread Author Time
Re: How can I get the query planner to use a bitmap index scap instead of an index scan ? Jeff Janes 21:46

March 10, 2014

Thread Author Time
Re: How can I get the query planner to use a bitmap index scap instead of an index scan ? Mohan Krishnan 08:14
Re: Query taking long time Evgeniy Shishkin 14:45
Re: Query taking long time acanada 16:30
Re: Query taking long time Venkata Balaji Nagothi 19:49
Re: Query taking long time desmodemone 20:22

March 11, 2014

Thread Author Time
Re: Query taking long time acanada 15:56
Ye olde slow query Murphy, Kevin 20:02
Re: Ye olde slow query Tom Lane 22:23
Re: Query taking long time Evgeny Shishkin 23:12

March 13, 2014

Thread Author Time
Very slow query in PostgreSQL 9.3.3 📎 fburgess 19:26
Re: [BUGS] Very slow query in PostgreSQL 9.3.3 Pavel Stehule 19:36
Re: [BUGS] Very slow query in PostgreSQL 9.3.3 Sergey Konoplev 22:12

March 14, 2014

Thread Author Time
Re: [PERFORM] Very slow query in PostgreSQL 9.3.3 Ian Lawrence Barwick 02:19
Adding new field to big table acanada 11:30
Re: Adding new field to big table Jeff Janes 16:49
Re: Adding new field to big table acanada 17:06
Re: Adding new field to big table Jeff Janes 19:29

March 17, 2014

Thread Author Time
Re: Adding new field to big table acanada 09:39

March 18, 2014

Thread Author Time
Re: Adding new field to big table Jeff Janes 06:04
Re: Help me understand why my subselect is an order of magnitude faster than my nested joins Vincent 21:20
question about partial index Yu Zhao 21:26
Re: question about partial index Szymon Guz 21:51

March 19, 2014

Thread Author Time
Re: Query taking long time acanada 11:09
slave wal is ahead of master Evgeniy Shishkin 17:10
Re: slave wal is ahead of master Sethu Prasad 18:11
Re: slave wal is ahead of master Evgeny Shishkin 20:01
Re: Query taking long time Venkata Balaji Nagothi 23:30

March 20, 2014

Thread Author Time
Re: Query taking long time acanada 10:17
long lasting select, no io nor cpu usage ? Franck Routier 13:51
Re: long lasting select, no io nor cpu usage ? Tom Lane 13:56
Re: long lasting select, no io nor cpu usage ? Franck Routier 14:07
Re: long lasting select, no io nor cpu usage ? Tom Lane 14:15
Re: long lasting select, no io nor cpu usage ? Franck Routier 16:27
Getting query plan alternatives from query planner? Stefan Keller 16:53
Performance of UNION vs IN Jean-Max Reymond 16:57
Re: Getting query plan alternatives from query planner? Tom Lane 17:08
Re: Performance of UNION vs IN Torsten Förtsch 17:13
slow join not using index properly Stefan Amshey 23:56

March 21, 2014

Thread Author Time
Re: Performance of UNION vs IN Jean-Max Reymond 05:33
Re: slow join not using index properly Ilya Kosmodemiansky 06:02
Re: Getting query plan alternatives from query planner? Stefan Keller 07:37
Re: Getting query plan alternatives from query planner? Atri Sharma 07:51
Re: slow join not using index properly Vincent 08:17
Re: Getting query plan alternatives from query planner? Craig James 13:34
Re: Getting query plan alternatives from query planner? Tom Lane 14:06
Connection pooling - Number of connections Guillaume Smet 14:49
Re: Connection pooling - Number of connections David Johnston 15:49
Re: Connection pooling - Number of connections Guillaume Smet 16:05
Re: Connection pooling - Number of connections Tom Lane 16:17
Re: Connection pooling - Number of connections Sethu Prasad 17:51
Re: Connection pooling - Number of connections Guillaume Smet 18:36
Re: Connection pooling - Number of connections Guillaume Smet 18:38
Re: Connection pooling - Number of connections David Johnston 18:41
Re: Connection pooling - Number of connections Claudio Freire 19:04
Re: Getting query plan alternatives from query planner? Shaun Thomas 19:43

March 22, 2014

Thread Author Time
Suboptimal query plan when using expensive BCRYPT functions Erik van Zijst 00:59
Re: Connection pooling - Number of connections Brett Wooldridge 11:26
Re: Suboptimal query plan when using expensive BCRYPT functions bricklen 20:51
Re: Suboptimal query plan when using expensive BCRYPT functions Erik van Zijst 22:27
Re: Suboptimal query plan when using expensive BCRYPT functions bricklen 22:56

March 23, 2014

Thread Author Time
Re: Suboptimal query plan when using expensive BCRYPT functions Erik van Zijst 03:37
Re: Suboptimal query plan when using expensive BCRYPT functions bricklen 03:56
Re: Query taking long time Venkata Balaji Nagothi 06:10
Re: Suboptimal query plan when using expensive BCRYPT functions Tom Lane 06:40
Re: Suboptimal query plan when using expensive BCRYPT functions Erik van Zijst 18:30

March 24, 2014

Thread Author Time
Re: Suboptimal query plan when using expensive BCRYPT functions Heikki Linnakangas 07:08
Connection pooling - Number of connections Brett Wooldridge 13:27
semaphore waits and performance stall Matthew Spilich 14:37
Re: Suboptimal query plan when using expensive BCRYPT functions Erik van Zijst 17:37
Re: slow join not using index properly Stefan Amshey 18:40
Re: Connection pooling - Number of connections Gavin Flower 20:24

March 25, 2014

Thread Author Time
Re: Connection pooling - Number of connections Brett Wooldridge 00:23
Re: Connection pooling - Number of connections Gavin Flower 01:42
Re: Connection pooling - Number of connections Brett Wooldridge 02:45
pg_dump vs pg_basebackup gianfranco caca 04:45
Re: slow join not using index properly Ilya Kosmodemiansky 07:05
Re: pg_dump vs pg_basebackup Ilya Kosmodemiansky 07:11
Re: pg_dump vs pg_basebackup gianfranco caca 07:19
Re: pg_dump vs pg_basebackup Ilya Kosmodemiansky 07:33
Re: pg_dump vs pg_basebackup David Johnston 07:39
Re: pg_dump vs pg_basebackup Claudio Freire 12:05
Stalls on PGSemaphoreLock Matthew Spilich 12:46
Re: pg_dump vs pg_basebackup Joshua D. Drake 14:56
Re: pg_dump vs pg_basebackup desmodemone 15:10
Re: pg_dump vs pg_basebackup Ilya Kosmodemiansky 15:18
Re: pg_dump vs pg_basebackup Magnus Hagander 15:21
Re: pg_dump vs pg_basebackup Joshua D. Drake 15:22
Re: pg_dump vs pg_basebackup Ilya Kosmodemiansky 15:29
Re: pg_dump vs pg_basebackup Ilya Kosmodemiansky 15:37
Re: pg_dump vs pg_basebackup Magnus Hagander 15:40
Re: pg_dump vs pg_basebackup Ilya Kosmodemiansky 15:41
Re: pg_dump vs pg_basebackup Graeme B. Bell 15:48
Re: pg_dump vs pg_basebackup Joshua D. Drake 15:55
Re: pg_dump vs pg_basebackup Alan Hodgson 16:12
Re: pg_dump vs pg_basebackup Claudio Freire 16:46
Re: Stalls on PGSemaphoreLock Ray Stell 17:17
RE : Stalls on PGSemaphoreLock Pavy Philippe 17:45
Re: Stalls on PGSemaphoreLock Matthew Spilich 18:38
Re: Stalls on PGSemaphoreLock Pavy Philippe 20:10
Re: Stalls on PGSemaphoreLock Emre Hasegeli 20:35

March 26, 2014

Thread Author Time
Re: Stalls on PGSemaphoreLock Takashi Horikawa 06:26
Why shared_buffers max is 8GB? Alexey Vasiliev 12:21
Re: Why shared_buffers max is 8GB? Ilya Kosmodemiansky 12:35
Re: Why shared_buffers max is 8GB? desmodemone 12:45
Re: Why shared_buffers max is 8GB? Albe Laurenz 13:23
Re: Why shared_buffers max is 8GB? Markella Skempri 13:24
Re: Why shared_buffers max is 8GB? Martin French 13:30
Re: Why shared_buffers max is 8GB? Martin French 13:32
Re: Why shared_buffers max is 8GB? Markella Skempri 13:47
Re: Why shared_buffers max is 8GB? Martin French 14:04
Re: Why shared_buffers max is 8GB? Scott Marlowe 14:23
Re: Why shared_buffers max is 8GB? desmodemone 14:23
Re: Why shared_buffers max is 8GB? Shaun Thomas 16:14
Re: Why shared_buffers max is 8GB? Ilya Kosmodemiansky 16:36

March 27, 2014

Thread Author Time
Re: Connection pooling - Number of connections Josh Berkus 00:35
Re: Stalls on PGSemaphoreLock Gudmundsson Martin (mg) 07:38
Partitions and prepared statements? Dave Johansen 20:42

March 29, 2014

Thread Author Time
Re: Connection pooling - Number of connections Jeff Janes 21:20

March 30, 2014

Thread Author Time
Re: Connection pooling - Number of connections Brett Wooldridge 03:41
Slow Count-Distinct Query Christopher Jackson 19:45

March 31, 2014

Thread Author Time
performance degradation after launching postgres cluster using pgpool-II Cora Ma 08:31
Sudden crazy high CPU usage Niels Kristian Schjødt 10:25
Re: Slow Count-Distinct Query Shaun Thomas 13:17
Re: Sudden crazy high CPU usage Merlin Moncure 13:47
Re: Slow Count-Distinct Query Tom Lane 14:15
Re: Sudden crazy high CPU usage Niels Kristian Schjødt 14:24
Re: Sudden crazy high CPU usage Merlin Moncure 14:36
Re: Sudden crazy high CPU usage Scott Marlowe 14:50
Re: Slow Count-Distinct Query Christopher Jackson 15:53
Re: Sudden crazy high CPU usage Niels Kristian Schjødt 17:16
Re: Sudden crazy high CPU usage Niels Kristian Schjødt 17:21
Re: Sudden crazy high CPU usage Sergey Konoplev 17:36
Re: Sudden crazy high CPU usage Will Platnick 20:01

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 6 7 8 9 10 11 13 14 17 18 19 20 21 22 23 24 25 26 27 29 30 31