pgsql-performance since 2014-02-16 00:00

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

Feb. 16, 2014

Thread Author Time
Optimal settings for RAID controller - optimized for writes Niels Kristian Schjødt 17:49

Feb. 17, 2014

Thread Author Time
Optimal settings for RAID controller - optimized for writes Niels Kristian Schjødt 15:03
Re: Optimal settings for RAID controller - optimized for writes DFE 15:29
Re: Optimal settings for RAID controller - optimized for writes Tomas Vondra 15:40
Re: Optimal settings for RAID controller - optimized for writes Tomas Vondra 15:54
Why is the optimiser choosing the slower query, or, understanding explain analyze output Alistair Bayley 21:54
DB size and TABLE sizes don't seem to add up David Wall 22:14
Re: Why is the optimiser choosing the slower query, or, understanding explain analyze output Jeff Janes 22:48

Feb. 18, 2014

Thread Author Time
Re: Optimal settings for RAID controller - optimized for writes KONDO Mitsumasa 01:23
Re: Why is the optimiser choosing the slower query, or, understanding explain analyze output Tom Lane 01:40
Re: Why is the optimiser choosing the slower query, or, understanding explain analyze output Alistair Bayley 02:18
Re: Why is the optimiser choosing the slower query, or, understanding explain analyze output Tom Lane 02:30
Re: Optimal settings for RAID controller - optimized for writes Scott Marlowe 04:04
Re: DB size and TABLE sizes don't seem to add up Heikki Linnakangas 08:34
Re: Optimal settings for RAID controller - optimized for writes Michael Stone 14:25
Re: DB size and TABLE sizes don't seem to add up David Wall 17:48
Re: Optimal settings for RAID controller - optimized for writes Tomas Vondra 20:41

Feb. 19, 2014

Thread Author Time
Re: Optimal settings for RAID controller - optimized for writes KONDO Mitsumasa 02:45
Re: Optimal settings for RAID controller - optimized for writes Merlin Moncure 15:13
Re: Optimal settings for RAID controller - optimized for writes Scott Marlowe 18:09

Feb. 20, 2014

Thread Author Time
Re: Optimal settings for RAID controller - optimized for writes Tomas Vondra 00:13
Re: Optimal settings for RAID controller - optimized for writes Merlin Moncure 00:18
Re: Optimal settings for RAID controller - optimized for writes Tomas Vondra 00:26
Re: Optimal settings for RAID controller - optimized for writes Tomas Vondra 01:10
Re: Optimal settings for RAID controller - optimized for writes Scott Marlowe 01:47
Re: Optimal settings for RAID controller - optimized for writes KONDO Mitsumasa 08:29
Re: Optimal settings for RAID controller - optimized for writes Tomas Vondra 23:58

Feb. 21, 2014

Thread Author Time
Postgresql tunning-- help needed Ashutosh Durugkar 12:22
Lack of index usage when doing array casts Alexey Klyukin 18:01
Re: Lack of index usage when doing array casts Tom Lane 19:04
Re: Lack of index usage when doing array casts Tom Lane 22:12
Re: Lack of index usage when doing array casts Alexey Klyukin 22:37
Re: Lack of index usage when doing array casts Peter Geoghegan 22:45

Feb. 23, 2014

Thread Author Time
9.1.2 Postgres corruption, any way to recover? Tory M Blue 20:42
Re: 9.1.2 Postgres corruption, any way to recover? Tomas Vondra 21:57

Feb. 24, 2014

Thread Author Time
Re: Bloated tables and why is vacuum full the only option Claudio Freire 21:43

Feb. 25, 2014

Thread Author Time
Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Tom Lane 16:06

Feb. 26, 2014

Thread Author Time
Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Josh Berkus 00:21
Re: Problem with ExclusiveLock on inserts Бородин Владимир 06:32
9.2.4 specified item offset is too large, now what? Tory M Blue 15:17
Query taking long time acanada 15:41
Re: Postgresql tunning-- help needed Tomas Vondra 23:59

Feb. 27, 2014

Thread Author Time
Re: Query taking long time acanada 10:31
not using my GIN index in JOIN expression Jean-Max Reymond 14:06
Re: not using my GIN index in JOIN expression Heikki Linnakangas 14:19
Re: not using my GIN index in JOIN expression Jean-Max Reymond 14:46
Inefficient filter order in query plan Tom Coogan 16:57
Re: Inefficient filter order in query plan Tom Lane 17:04
Re: Inefficient filter order in query plan Stephen Frost 18:24
Re: Inefficient filter order in query plan Tom Lane 19:02
Re: Inefficient filter order in query plan Tom Coogan 20:34
Re: Inefficient filter order in query plan Tom Lane 20:47

Feb. 28, 2014

Thread Author Time
Re: Inefficient filter order in query plan Tom Coogan 18:29
Help with optimizing a query over hierarchical data Damon Snyder 20:01

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

Browse Archives

Prev | Next