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.
| Thread | Author | Time |
|---|---|---|
| Re: Hot Standby performance issue | Tomas Vondra | 00:20 |
| Re: Hot Standby performance issue | Kevin Grittner | 16:03 |
| Re: Hot Standby performance issue | sparikh | 17:58 |
| Re: Hot Standby performance issue | Tomas Vondra | 23:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Hot Standby performance issue | sparikh | 15:05 |
| Re: Hot Standby performance issue | Tomas Vondra | 19:58 |
| Re: Hot Standby performance issue | sparikh | 21:18 |
| Re: Hot Standby performance issue | Tomas Vondra | 21:54 |
| Re: Hot Standby performance issue | sparikh | 22:59 |
| Re: Hot Standby performance issue | Tomas Vondra | 23:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Hot Standby performance issue | sparikh | 00:00 |
| Re: Hot Standby performance issue | Magnus Hagander | 04:49 |
| Re: Hot Standby performance issue | Tomas Vondra | 17:54 |
| Re: Hot Standby performance issue | Tomas Vondra | 18:00 |
| Logic of lowering seq_page_cost for SSD? | Josh Berkus | 18:56 |
| Re: Hot Standby performance issue | sparikh | 21:41 |
| Re: Hot Standby performance issue | sparikh | 21:50 |
| Re: Hot Standby performance issue | Tomas Vondra | 23:09 |
| Re: Hot Standby performance issue | Tomas Vondra | 23:15 |
| Thread | Author | Time |
|---|---|---|
| Re: Hot Standby performance issue | sparikh | 01:23 |
| Thread | Author | Time |
|---|---|---|
| Re: Hot Standby performance issue | ramistuni | 21:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Hot Standby performance issue | Tomas Vondra | 14:16 |
| Thread | Author | Time |
|---|---|---|
| Re: Hot Standby performance issue | sparikh | 20:23 |
| Re: Hot Standby performance issue | sparikh | 20:57 |
| Problems with hash join over nested loop | Jim Nasby | 21:58 |
| Re: Problems with hash join over nested loop | Tom Lane | 23:13 |
| Re: Problems with hash join over nested loop | Jim Nasby | 23:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Problems with hash join over nested loop | Merlin Moncure | 14:10 |
| Re: Problems with hash join over nested loop | Jim Nasby | 16:21 |
| Re: Problems with hash join over nested loop | Tom Lane | 16:45 |
| Re: Problems with hash join over nested loop | Jim Nasby | 16:52 |
| Re: Problems with hash join over nested loop | Tom Lane | 18:20 |
| Re: Problems with hash join over nested loop | Jim Nasby | 20:08 |
| Re: Problems with hash join over nested loop | Tom Lane | 20:36 |
| Adding foreign key constraint holds exclusive lock for too long (on production database) | Ben Hoyt | 21:27 |
| Thread | Author | Time |
|---|---|---|
| Re: Adding foreign key constraint holds exclusive lock for too long (on production database) | David Johnston | 00:18 |
| Re: Re: Adding foreign key constraint holds exclusive lock for too long (on production database) | Tom Lane | 00:30 |
| Re: postgres connections | si24 | 14:16 |
| Re: Adding foreign key constraint holds exclusive lock for too long (on production database) | Josh Berkus | 18:20 |
| Re: Problems with hash join over nested loop | Jim Nasby | 22:27 |
| Re: Problems with hash join over nested loop | Jim Nasby | 22:32 |
| Re: Problems with hash join over nested loop | Tom Lane | 23:06 |
| Thread | Author | Time |
|---|---|---|
| how are you? | Ioana Danes | 15:50 |
| Thread | Author | Time |
|---|---|---|
| postgresql recommendation memory | Евгений Селявка | 18:54 |
| Re: Hot Standby performance issue | Tomas Vondra | 19:33 |
| Re: Hot Standby performance issue | Tomas Vondra | 19:40 |
| Thread | Author | Time |
|---|---|---|
| Slow index scan on B-Tree index over timestamp field | Caio Casimiro | 22:05 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow index scan on B-Tree index over timestamp field | Kevin Grittner | 18:56 |
| Re: Slow index scan on B-Tree index over timestamp field | Elliot | 19:03 |
| Re: Slow index scan on B-Tree index over timestamp field | Jeff Janes | 19:15 |
| Re: Slow index scan on B-Tree index over timestamp field | Caio Casimiro | 20:44 |
| Re: Slow index scan on B-Tree index over timestamp field | Caio Casimiro | 20:50 |
| Re: Slow index scan on B-Tree index over timestamp field | Igor Neyman | 20:52 |
| Re: Slow index scan on B-Tree index over timestamp field | Caio Casimiro | 21:10 |
| Re: Slow index scan on B-Tree index over timestamp field | Elliot | 21:22 |
| Re: Slow index scan on B-Tree index over timestamp field | Igor Neyman | 21:26 |
| Re: Slow index scan on B-Tree index over timestamp field | Caio Casimiro | 21:32 |
| Re: Slow index scan on B-Tree index over timestamp field | Caio Casimiro | 22:10 |
| Re: Slow index scan on B-Tree index over timestamp field | desmodemone | 22:59 |
| Re: Slow index scan on B-Tree index over timestamp field | Caio Casimiro | 23:24 |
| Thread | Author | Time |
|---|---|---|
| ORDER BY performance deteriorates very quickly as dataset grows | Standa K. | 08:36 |
| Re: postgresql recommendation memory | Евгений Селявка | 08:37 |
| Re: ORDER BY performance deteriorates very quickly as dataset grows | aasat | 09:22 |
| Re: ORDER BY performance deteriorates very quickly as dataset grows | aasat | 09:24 |
| Trees: integer[] outperformed by ltree | Jan Walter | 12:25 |
| Re: Slow index scan on B-Tree index over timestamp field | Igor Neyman | 13:17 |
| Re: Slow index scan on B-Tree index over timestamp field | Jeff Janes | 16:10 |
| Re: Trees: integer[] outperformed by ltree | Merlin Moncure | 17:30 |
| Re: Trees: integer[] outperformed by ltree | Merlin Moncure | 19:51 |
| Re: postgresql recommendation memory | Josh Berkus | 19:59 |
| Re: Trees: integer[] outperformed by ltree | Jan Walter | 21:52 |
| Re: Trees: integer[] outperformed by ltree | Merlin Moncure | 22:19 |
| Re: postgresql recommendation memory | Michael Paquier | 23:00 |
| Re: postgresql recommendation memory | Scott Marlowe | 23:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Trees: integer[] outperformed by ltree | Jan Walter | 00:27 |
| Re: postgresql recommendation memory | Евгений Селявка | 08:53 |
| Re: Trees: integer[] outperformed by ltree | Merlin Moncure | 14:36 |
| Re: postgresql recommendation memory | Scott Marlowe | 16:35 |
| Re: Slow index scan on B-Tree index over timestamp field | Merlin Moncure | 16:44 |
| Re: postgresql recommendation memory | Scott Marlowe | 16:46 |
| Re: postgresql recommendation memory | Scott Marlowe | 17:04 |
| Re: Slow index scan on B-Tree index over timestamp field | Jeff Janes | 19:00 |
| Re: Slow index scan on B-Tree index over timestamp field | Caio Casimiro | 19:24 |
| Re: postgresql recommendation memory | Merlin Moncure | 23:18 |
| Thread | Author | Time |
|---|---|---|
| Re: postgresql recommendation memory | David Rees | 08:51 |
| Re: postgresql recommendation memory | Евгений Селявка | 09:33 |
| Re: postgresql recommendation memory | Евгений Селявка | 10:13 |
| Thread | Author | Time |
|---|---|---|
| Size of IN list affects query plan | Jan Walter | 14:04 |
| Re: Size of IN list affects query plan | Tom Lane | 14:31 |
| Re: Size of IN list affects query plan | bricklen | 14:31 |
| Re: Performance bug in prepared statement binding in 9.2? | Tom Lane | 19:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance bug in prepared statement binding in 9.2? | Kevin Grittner | 16:30 |
| Thread | Author | Time |
|---|---|---|
| BitMap Heap Scan & BitMap Index Scan | monalee_dba | 07:32 |
| Order By Clause, Slows Query Performance? | monalee_dba | 07:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Horrific time for getting 1 record from an index? | Jeff Janes | 00:30 |
| Unexpected slow query time when joining small table with large table | Ryan LeCompte | 04:22 |
| Re: postgresql recommendation memory | Евгений Селявка | 08:41 |
| Thread | Author | Time |
|---|---|---|
| Re: Horrific time for getting 1 record from an index? | Jeff Janes | 00:17 |
| Re: Horrific time for getting 1 record from an index? | Jim Nasby | 00:22 |
| Re: BitMap Heap Scan & BitMap Index Scan | Michael Paquier | 01:25 |
| Re: Order By Clause, Slows Query Performance? | Michael Paquier | 01:31 |
| Re: Performance bug in prepared statement binding in 9.2? | Tom Lane | 01:46 |
| Re: Order By Clause, Slows Query Performance? | Albe Laurenz | 09:07 |
| Re: BitMap Heap Scan & BitMap Index Scan | Torsten Förtsch | 09:37 |
| CREATE TABLE AS WITH FREEZE ? | Marc Mamin | 10:29 |
| Re: Horrific time for getting 1 record from an index? | Merlin Moncure | 15:03 |
| Re: Performance bug in prepared statement binding in 9.2? | Josh Berkus | 19:34 |
| Re: Performance bug in prepared statement binding in 9.2? | Tom Lane | 20:14 |
| Thread | Author | Time |
|---|---|---|
| Bad plan choices & statistic targets with a GIN index | Dieter Komendera | 14:36 |
| Re: Bad plan choices & statistic targets with a GIN index | Tom Lane | 15:00 |
| Thread | Author | Time |
|---|---|---|
| General slowness when retrieving a relatively small number of rows | Patrick Krecker | 22:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Reseting statistics counters | Strahinja Kustudić | 19:49 |
| Thread | Author | Time |
|---|---|---|
| Query in cache | Rogerio Pereira | 16:38 |
| Re: Query in cache | Andreas Kretschmer | 16:43 |
| Re: Query in cache | [email protected] | 16:57 |
| Error Broken pipe in log postgres | Rogerio Pereira | 18:27 |
| Re: Error Broken pipe in log postgres | Craig James | 19:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Query in cache | salah jubeh | 00:36 |
| Re: Query in cache | Sergey Konoplev | 01:37 |
| Re: Query in cache | [email protected] | 14:00 |
| Re: Query in cache | Rogerio Pereira | 15:50 |
| Thread | Author | Time |
|---|---|---|
| Error install -pgmemcache | Rogerio Pereira | 12:36 |
| Thread | Author | Time |
|---|---|---|
| UNION versus SUB SELECT | Robert DiFalco | 20:20 |
| Re: UNION versus SUB SELECT | desmodemone | 20:31 |
| Re: UNION versus SUB SELECT | Robert DiFalco | 20:36 |
| Re: UNION versus SUB SELECT | desmodemone | 20:38 |
| Re: UNION versus SUB SELECT | Robert DiFalco | 21:12 |
| Re: UNION versus SUB SELECT | Robert DiFalco | 22:04 |
| Re: UNION versus SUB SELECT | bricklen | 22:58 |
| Re: UNION versus SUB SELECT | bricklen | 22:59 |
| Re: UNION versus SUB SELECT | Robert DiFalco | 23:13 |
| Thread | Author | Time |
|---|---|---|
| Re: Query in cache | Rogerio Pereira | 12:06 |
| Re: UNION versus SUB SELECT | Merlin Moncure | 15:54 |
| Re: UNION versus SUB SELECT | Robert DiFalco | 17:36 |
| Thread | Author | Time |
|---|---|---|
| Postgresql in a Virtual Machine | Lee Nguyen | 20:01 |
| Re: Postgresql in a Virtual Machine | Gavin Flower | 20:08 |
| Re: Postgresql in a Virtual Machine | Heikki Linnakangas | 20:19 |
| Re: Postgresql in a Virtual Machine | Andrew Dunstan | 20:28 |
| Re: Postgresql in a Virtual Machine | Gudmundsson Martin (mg) | 21:00 |
| Re: Postgresql in a Virtual Machine | Mark Kirkwood | 21:22 |
| Re: Postgresql in a Virtual Machine | Merlin Moncure | 22:50 |
| Re: Postgresql in a Virtual Machine | David Lang | 22:57 |
| Re: Postgresql in a Virtual Machine | Merlin Moncure | 23:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgresql in a Virtual Machine | Xenofon Papadopoulos | 06:12 |
| Re: Postgresql in a Virtual Machine | David Lang | 06:16 |
| Re: Postgresql in a Virtual Machine | Xenofon Papadopoulos | 06:30 |
| Re: Postgresql in a Virtual Machine | Rafael Martinez | 09:47 |
| Re: Postgresql in a Virtual Machine | Boszormenyi Zoltan | 13:51 |
| Re: Postgresql in a Virtual Machine | Stephen Frost | 14:19 |
| Re: Postgresql in a Virtual Machine | Craig James | 14:26 |
| Re: Postgresql in a Virtual Machine | Andrew Dunstan | 15:31 |
| Re: Postgresql in a Virtual Machine | Andrew Dunstan | 15:39 |
| Re: Postgresql in a Virtual Machine | David Boreham | 16:29 |
| Re: Postgresql in a Virtual Machine | Craig James | 17:24 |
| Re: Postgresql in a Virtual Machine | Josh Berkus | 17:31 |
| Re: Postgresql in a Virtual Machine | Merlin Moncure | 17:53 |
| Re: Postgresql in a Virtual Machine | Ben Chobot | 18:40 |
| Re: Postgresql in a Virtual Machine | Craig James | 19:18 |
| Re: Postgresql in a Virtual Machine | David Kerr | 19:51 |
| Thread | Author | Time |
|---|---|---|
| Parallel Select query performance and shared buffers | Metin Doslu | 08:28 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgresql in a Virtual Machine | Dong Ye | 02:58 |
| Re: Postgresql in a Virtual Machine | Gudmundsson Martin (mg) | 08:45 |
| Re: Postgresql in a Virtual Machine | Dong Ye | 18:11 |
| Re: Postgresql in a Virtual Machine | Scott Marlowe | 18:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgresql in a Virtual Machine | Michael Paquier | 01:41 |
| One query run twice in parallel results in huge performance decrease | Jan Michel | 22:07 |
| Re: One query run twice in parallel results in huge performance decrease | Jeff Janes | 22:42 |
| Re: One query run twice in parallel results in huge performance decrease | Jan Michel | 23:03 |
| Re: One query run twice in parallel results in huge performance decrease | Tom Lane | 23:48 |
| Thread | Author | Time |
|---|---|---|
| Re: One query run twice in parallel results in huge performance decrease | Jan Michel | 11:05 |
| Thread | Author | Time |
|---|---|---|
| Speed up the query | Hengky Liwandouw | 06:21 |
| Re: Speed up the query | Andreas Kretschmer | 07:12 |
| Re: Speed up the query | Hengky Liwandouw | 08:31 |
| Re: Speed up the query | Andreas Kretschmer | 08:35 |
| Re: Speed up the query | Hengky Liwandouw | 09:07 |
| Re: Speed up the query | desmodemone | 11:27 |
| Re: Speed up the query | Torsten Förtsch | 12:06 |
| Re: Speed up the query | Hengky Liwandouw | 12:25 |
| Re: Speed up the query | Andreas Kretschmer | 12:27 |
| Re: Speed up the query | Andreas Kretschmer | 12:29 |
| Re: Speed up the query | Hengky Liwandouw | 14:11 |