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: 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 |
| Re: Speed up the query | Kevin Grittner | 16:02 |
| Re: Speed up the query | Hengky Lie | 16:14 |
| Re: Speed up the query | Hengky Lie | 17:33 |
| Re: Speed up the query | Hengky Lie | 17:41 |
| Thread | Author | Time |
|---|---|---|
| Re: One query run twice in parallel results in huge performance decrease | Jeff Janes | 23:17 |
| Thread | Author | Time |
|---|---|---|
| Re: One query run twice in parallel results in huge performance decrease | Scott Marlowe | 01:59 |
| Parallel Select query performance and shared buffers | Metin Doslu | 13:41 |
| Parallel Select query performance and shared buffers | Metin Doslu | 13:49 |
| Re: Parallel Select query performance and shared buffers | Alvaro Herrera | 13:53 |
| Re: Parallel Select query performance and shared buffers | Claudio Freire | 15:56 |
| Re: Parallel Select query performance and shared buffers | Metin Doslu | 16:24 |
| Re: Parallel Select query performance and shared buffers | Claudio Freire | 16:32 |
| Re: One query run twice in parallel results in huge performance decrease | Jan Michel | 20:18 |
| Thread | Author | Time |
|---|---|---|
| Re: One huge db vs many small dbs | Josh Berkus | 00:01 |
| select count(distinct ...) is slower than select distinct in about 5x | jacket41142 | 02:10 |
| Re: WAL + SSD = slow inserts? | Skarsol | 05:55 |
| Re: One huge db vs many small dbs | Pavel Stehule | 05:58 |
| Re: WAL + SSD = slow inserts? | Rosser Schwarz | 06:03 |
| Similarity search with the tsearch2 extension | Janek Sendrowski | 14:30 |
| Re: Similarity search with the tsearch2 extension | Kevin Grittner | 14:54 |
| Re: [PERFORM] Similarity search with the tsearch2 extension | Janek Sendrowski | 16:21 |
| postgres performance | chidamparam muthusamy | 17:36 |
| Re: postgres performance | Alan Hodgson | 18:16 |
| Re: postgres performance | Richard Huxton | 18:37 |
| Re: Reseting statistics counters | Tomas Vondra | 23:31 |
| Re: WAL + SSD = slow inserts? | Tomas Vondra | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: postgres performance | Tomas Vondra | 00:13 |
| Debugging shared memory issues on CentOS | Mack Talcott | 03:21 |
| Re: postgres performance | chidamparam muthusamy | 10:30 |
| Re: One huge db vs many small dbs | Oliver Seemann | 12:43 |
| Re: postgres performance | desmodemone | 12:55 |
| Re: Recommendations for partitioning? | desmodemone | 17:09 |
| Re: Recommendations for partitioning? | Jeff Janes | 20:29 |
| Re: Recommendations for partitioning? | Scott Marlowe | 20:37 |