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 |
|---|---|---|
| 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 |
| Thread | Author | Time |
|---|---|---|
| Hash join | mspasic | 09:45 |
| select count(distinct ...) is slower than select distinct in about 5x | jacket41142 | 17:28 |
| Re: select count(distinct ...) is slower than select distinct in about 5x | Kevin Grittner | 18:16 |
| Re: select count(distinct ...) is slower than select distinct in about 5x | Jeff Janes | 18:19 |
| Re: Parallel Select query performance and shared buffers | Merlin Moncure | 20:03 |
| Re: Parallel Select query performance and shared buffers | Claudio Freire | 20:06 |
| Re: Parallel Select query performance and shared buffers | Merlin Moncure | 20:20 |
| Re: Explain analyze time overhead | Bruce Momjian | 20:40 |
| Re: Explain analyze time overhead | salah jubeh | 21:53 |
| Re: Explain analyze time overhead | Bruce Momjian | 21:59 |
| Problem with slow query with WHERE conditions with OR clause on primary keys | Krzysztof Olszewski | 23:30 |
| Thread | Author | Time |
|---|---|---|
| Re: select count(distinct ...) is slower than select distinct in about 5x | jacket41142 | 01:23 |
| Re: select count(distinct ...) is slower than select distinct in about 5x | jacket41142 | 01:57 |
| Re: select count(distinct ...) is slower than select distinct in about 5x | Jeff Janes | 02:24 |
| Re: Debugging shared memory issues on CentOS | Tom Lane | 04:54 |
| Re: Problem with slow query with WHERE conditions with OR clause on primary keys | David Johnston | 07:18 |
| Re: Debugging shared memory issues on CentOS | Mack Talcott | 08:23 |
| When is a query slow? | Michael Sacket | 15:41 |
| ORDER BY using index, tsearch2 📎 | Janek Sendrowski | 22:29 |
| ORDER BY using index, tsearch2 [READ THIS!] | Janek Sendrowski | 22:31 |
| Re: ORDER BY using index, tsearch2 [READ THIS!] | Tom Lane | 23:33 |
| Re: ORDER BY using index, tsearch2 | Craig James | 23:38 |
| Re: ORDER BY using index, tsearch2 | Tom Lane | 23:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow query due to slow I/O | Jeff Janes | 00:01 |
| Re: Slow query due to slow I/O | Bryce Covert | 00:03 |
| Thread | Author | Time |
|---|---|---|
| Current query of the PL/pgsql procedure. | Yuri Levinsky | 16:18 |
| Re: Current query of the PL/pgsql procedure. | Craig James | 18:05 |
| Thread | Author | Time |
|---|---|---|
| Re: Current query of the PL/pgsql procedure. | hubert depesz lubaczewski | 10:26 |
| Re: Current query of the PL/pgsql procedure. | Yuri Levinsky | 11:42 |
| Re: Current query of the PL/pgsql procedure. | Matheus de Oliveira | 12:47 |
| Re: Current query of the PL/pgsql procedure. | Andrew Dunstan | 13:29 |
| Help with cursor query that is intermittently slow | Drew Jetter | 20:54 |
| Adding an additional join causes very different/slow query plan | Joe Van Dyk | 21:52 |
| Re: Adding an additional join causes very different/slow query plan | Joe Van Dyk | 21:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Adding an additional join causes very different/slow query plan | Tom Lane | 00:14 |
| Re: Adding an additional join causes very different/slow query plan | Joe Van Dyk | 00:37 |
| Re: Adding an additional join causes very different/slow query plan | Stephen Frost | 14:01 |
| Thread | Author | Time |
|---|---|---|
| Optimizing a query | Kai Sellgren | 02:48 |
| Re: Current query of the PL/pgsql procedure. | Guillaume Lelarge | 08:30 |
| Re: Problem with slow query with WHERE conditions with OR clause on primary keys | [email protected] | 19:23 |
| Regarding Hardware Tuning | prashant Pandey | 20:12 |
| Re: Problem with slow query with WHERE conditions with OR clause on primary keys | David Johnston | 20:12 |
| Thread | Author | Time |
|---|---|---|
| DATE_TRUNC() and GROUP BY? | Dave Johansen | 00:35 |
| Re: Regarding Hardware Tuning | Scott Marlowe | 00:37 |
| Re: query plan not optimal | Marc Cousin | 06:05 |
| Re: Unexpected pgbench result | Shaun Thomas | 14:10 |
| Re: Regarding Hardware Tuning | Shaun Thomas | 14:29 |
| Re: slow query - will CLUSTER help? | Shaun Thomas | 14:42 |
| Re: Unexpected pgbench result | Dave Johansen | 15:02 |
| Re: Unexpected pgbench result | Kevin Grittner | 15:22 |
| Re: Unexpected pgbench result | Dave Johansen | 15:40 |
| Re: Recommendations for partitioning? | Dave Johansen | 15:52 |
| Re: Recommendations for partitioning? | Alvaro Herrera | 15:59 |
| Re: Recommendations for partitioning? | bricklen | 16:07 |
| Re: slow query - will CLUSTER help? | Shaun Thomas | 16:11 |
| Re: Recommendations for partitioning? | Shaun Thomas | 16:18 |
| Re: Recommendations for partitioning? | Dave Johansen | 16:23 |
| Re: Recommendations for partitioning? | Dave Johansen | 16:24 |
| Re: slow query - will CLUSTER help? | Gavin Flower | 21:19 |
| Thread | Author | Time |
|---|---|---|
| Re: DATE_TRUNC() and GROUP BY? | David Rowley | 05:46 |
| Thread | Author | Time |
|---|---|---|
| Strange number of rows in plan cost | Алексей Кузнецов | 06:32 |
| Re: query not using index | Johann Spies | 08:58 |
| Re: slow query - will CLUSTER help? | Shaun Thomas | 16:41 |
| Bytea(TOAST) vs large object facility(OID) | kosalram Babu Chellappa | 20:16 |
| Thread | Author | Time |
|---|---|---|
| Re: Optimizing a query | Mark Kirkwood | 00:32 |
| Re: Bytea(TOAST) vs large object facility(OID) | Albe Laurenz | 07:55 |
| Thread | Author | Time |
|---|---|---|
| Re: How to completely delete iPhone all data before selling? | shirleymi | 08:46 |