pgsql-performance since 2014-03-07 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

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
Re: PGSQL 9.3 - Materialized View - multithreading PARIS Nicolas 19:49
Re: PGSQL 9.3 - Materialized View - multithreading Thom Brown 19:57
Re: PGSQL 9.3 - Materialized View - multithreading PARIS Nicolas 20:07
Re: PGSQL 9.3 - Materialized View - multithreading Thom Brown 20:14
Re: PGSQL 9.3 - Materialized View - multithreading PARIS Nicolas 20:26
Re: PGSQL, checkpoints, and file system syncs 📎 Reza Taheri 20:27
Re: PGSQL 9.3 - Materialized View - multithreading ktm@rice.edu 20:34

April 5, 2014

Thread Author Time
Re: Fwd: Slow Count-Distinct Query Varadharajan Mukundan 01:13

April 6, 2014

Thread Author Time
SSI slows down over time Ryan Johnson 02:25
Re: SSI slows down over time Heikki Linnakangas 08:30
Re: SSI slows down over time Tom Lane 14:55
Slow Count-Distinct Query Jeff Janes 17:26
Re: PGSQL 9.3 - Materialized View - multithreading Thom Brown 19:07
Re: PGSQL 9.3 - Materialized View - multithreading PARIS Nicolas 22:21

April 7, 2014

Thread Author Time
Re: Slow Count-Distinct Query Varadharajan Mukundan 02:34
The same query - much different runtimes Johann Spies 10:25
Re: PGSQL 9.3 - Materialized View - multithreading Graeme B. Bell 10:29
Re: SSI slows down over time Ryan Johnson 10:52
Re: The same query - much different runtimes Pavan Deolasee 10:58
Re: Batch update query performance Albe Laurenz 12:06
Re: PGSQL 9.3 - Materialized View - multithreading Nicolas Paris 12:49
Re: Batch update query performance Heikki Linnakangas 12:53
Re: PGSQL 9.3 - Materialized View - multithreading Graeme B. Bell 12:59
Re: performance degradation after launching postgres cluster using pgpool-II Tatsuo Ishii 13:46
Re: PGSQL 9.3 - Materialized View - multithreading Nicolas Paris 13:56
Re: PGSQL 9.3 - Materialized View - multithreading Graeme B. Bell 14:05
Re: SSI slows down over time Ryan Johnson 14:11
Re: SSI slows down over time Ryan Johnson 14:36
Re: SSI slows down over time Ryan Johnson 14:38
Performance regressions in PG 9.3 vs PG 9.0 uher dslij 18:34
Re: Batch update query performance Jeff Janes 21:26

April 8, 2014

Thread Author Time
Nested loop issue Manoj Gadi 09:35
performance drop when function argument is evaluated in WHERE clause Gerardo Herzig 11:53
query against large table not using sensible index to find very small amount of data Andrew W. Gibbs 12:48
Re: batch update query performance Hans Drexler 13:21
Re: query against large table not using sensible index to find very small amount of data Shaun Thomas 13:39
Re: [PERFORM] performance drop when function argument is evaluated in WHERE clause Tom Lane 13:50
Re: query against large table not using sensible index to find very small amount of data Tom Lane 13:55
Re: PGSQL, checkpoints, and file system syncs Shaun Thomas 14:00

Browse Archives

Prev | Next