pgsql-performance since 2014-02-23 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. 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

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

April 1, 2014

Thread Author Time
Re: Sudden crazy high CPU usage Niels Kristian Schjødt 21:50
Re: Sudden crazy high CPU usage Andres Freund 22:16

April 2, 2014

Thread Author Time
Re: Slow Count-Distinct Query bricklen 00:34
Re: Slow Count-Distinct Query Christopher Jackson 04:22
Re: Slow Count-Distinct Query Michael Paquier 04:48
Re: Slow Count-Distinct Query Christopher Jackson 04:54
Re: Why shared_buffers max is 8GB? Alexey Klyukin 09:38

April 3, 2014

Thread Author Time
Re: Sudden crazy high CPU usage Michael Paquier 00:00
PGSQL, checkpoints, and file system syncs 📎 Reza Taheri 00:38
PGSQL, checkpoints, and file system syncs 📎 Reza Taheri 17:39
Re: PGSQL, checkpoints, and file system syncs Heikki Linnakangas 18:01
Re: PGSQL, checkpoints, and file system syncs Reza Taheri 18:11

April 4, 2014

Thread Author Time
Re: PGSQL, checkpoints, and file system syncs Ilya Kosmodemiansky 06:11
Fwd: Slow Count-Distinct Query Varadharajan Mukundan 09:31
Batch update query performance Hans Drexler 12:00
PGSQL 9.3 - Materialized View - multithreading Nicolas Paris 16:29
Re: PGSQL 9.3 - Materialized View - multithreading Thom Brown 16:54
Re: Fwd: Slow Count-Distinct Query Jeff Janes 17:59

Browse Archives

Prev | Next