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: pg_dump and thousands of schemas | Tatsuo Ishii | 01:18 |
| Seqscan slowness and stored procedures | Ivan Voras | 21:38 |
| Thread | Author | Time |
|---|---|---|
| Re: Seqscan slowness and stored procedures | Pavel Stehule | 03:28 |
| Re: pg_dump and thousands of schemas | Hugo <Nabble> | 04:12 |
| Re: Seqscan slowness and stored procedures | Ivan Voras | 15:57 |
| Re: Seqscan slowness and stored procedures | Pavel Stehule | 16:07 |
| Thread | Author | Time |
|---|---|---|
| Re: SSD selection | Greg Smith | 12:14 |
| Recover rows deleted | Alejandro Carrillo | 18:24 |
| Re: pg_dump and thousands of schemas | Jeff Janes | 21:24 |
| Re: pg_dump and thousands of schemas | Tom Lane | 22:26 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_dump and thousands of schemas | Hugo <Nabble> | 05:21 |
| Re: pg_dump and thousands of schemas | Tatsuo Ishii | 09:51 |
| Strong slowdown on huge tables | Job | 14:54 |
| Re: pg_dump and thousands of schemas | Tom Lane | 15:52 |
| Re: Strong slowdown on huge tables | Tom Lane | 17:42 |
| Re: Recover rows deleted | Jeff Davis | 20:53 |
| Re: Recover rows deleted | hubert depesz lubaczewski | 21:33 |
| Re: Recover rows deleted | Alejandro Carrillo | 22:16 |
| Re: Recover rows deleted | Alejandro Carrillo | 22:34 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_dump and thousands of schemas | Tatsuo Ishii | 00:58 |
| Re: pg_dump and thousands of schemas 📎 | Tatsuo Ishii | 09:06 |
| does the query planner consider work_mem? | Murat Tasan | 17:57 |
| Re: does the query planner consider work_mem? | Ants Aasma | 18:25 |
| Re: does the query planner consider work_mem? | Murat Tasan | 20:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Trouble with plan statistics for behaviour for query. | Craig James | 00:08 |
| Re: Trouble with plan statistics for behaviour for query. | Vitalii Tymchyshyn | 09:06 |
| Select from sequence in slow query log | Chris Rimmer | 13:13 |
| Re: Select from sequence in slow query log | Tom Lane | 13:47 |
| Re: does the query planner consider work_mem? | Tom Lane | 15:15 |
| Re: Trouble with plan statistics for behaviour for query. | Maciek Sakrejda | 15:38 |
| Re: Select from sequence in slow query log | Chris Rimmer | 15:41 |
| Thread | Author | Time |
|---|---|---|
| Re: High load average in 64-core server , no I/O wait and CPU is idle | Kevin Grittner | 02:54 |
| Array fundamentals | idc danny | 17:05 |
| Re: [PERFORM] Array fundamentals | Jeff Davis | 17:21 |
| Thread | Author | Time |
|---|---|---|
| Re: Recover rows deleted | Alejandro Carrillo | 16:14 |
| Re: Recover rows deleted | Shaun Thomas | 16:43 |
| Re: Recover rows deleted | Alejandro Carrillo | 16:47 |
| Re: Recover rows deleted | Merlin Moncure | 17:04 |
| Re: Recover rows deleted | Alejandro Carrillo | 17:46 |
| Re: Recover rows deleted | Merlin Moncure | 18:23 |
| Re: Recover rows deleted | Alejandro Carrillo | 18:37 |
| Re: Recover rows deleted | Kevin Grittner | 18:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Trouble with plan statistics for behaviour for query. | Trevor Campbell | 01:25 |
| Re: Trouble with plan statistics for behaviour for query. | Trevor Campbell | 03:49 |
| Sequencial scan in a JOIN | Andrew Jaimes | 12:48 |
| Re: Sequencial scan in a JOIN | Shaun Thomas | 13:15 |
| Re: Sequencial scan in a JOIN | Andrew Jaimes | 13:31 |
| Re: Sequencial scan in a JOIN | Shaun Thomas | 14:02 |
| Re: Sequencial scan in a JOIN | Shaun Thomas | 14:57 |
| Missing block Magic | Alejandro Carrillo | 16:12 |
| Re: Missing block Magic | Tom Lane | 17:00 |
| Re: Missing block Magic | Alejandro Carrillo | 18:51 |
| Thread | Author | Time |
|---|---|---|
| pg 9.1 brings host machine down | Konstantin Mikhailov | 12:05 |
| Re: pg 9.1 brings host machine down | Vitalii Tymchyshyn | 12:25 |
| Re: pg 9.1 brings host machine down | Patric Bechtel | 12:40 |
| Re: pg 9.1 brings host machine down 📎 | Julien Cigar | 12:55 |
| Thread | Author | Time |
|---|---|---|
| Multiple Concurrent Updates of Shared Resource Counter | Nir Zilberman | 07:53 |
| Re: Multiple Concurrent Updates of Shared Resource Counter | Robert Klemme | 11:48 |
| Thread | Author | Time |
|---|---|---|
| Re: how to change the index chosen in plan? | Rural Hunter | 02:08 |
| Re: how to change the index chosen in plan? | Kevin Grittner | 14:39 |
| Re: how to change the index chosen in plan? | Kevin Grittner | 15:38 |
| partitioning performance question | Kevin Kempter | 17:58 |
| Thread | Author | Time |
|---|---|---|
| Re: pg 9.1 brings host machine down | Craig Ringer | 03:26 |
| Performance of CLUSTER | Mark Thornton | 08:20 |
| Re: partitioning performance question | Robert Klemme | 11:16 |
| Re: pg_dump and thousands of schemas | Jeff Janes | 23:47 |
| Thread | Author | Time |
|---|---|---|
| Re: how to change the index chosen in plan? | Rural Hunter | 04:46 |
| Re: Tablespaces and query planning | Albe Laurenz | 07:01 |
| Re: how to change the index chosen in plan? | Kevin Grittner | 12:07 |
| Re: how to change the index chosen in plan? | Rural Hunter | 12:55 |
| Re: Performance of CLUSTER | Shaun Thomas | 13:42 |
| postgres clustering interactions with pg_dump | Fitch, Britt | 13:55 |
| Re: Performance of CLUSTER | Mark Thornton | 14:02 |
| Re: Performance of CLUSTER | Shaun Thomas | 14:14 |
| Re: Performance of CLUSTER | Shaun Thomas | 14:44 |
| Re: pg_dump and thousands of schemas | Jeff Janes | 16:32 |
| Re: Performance of CLUSTER | Jeff Davis | 23:53 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_dump and thousands of schemas | Tatsuo Ishii | 08:54 |
| Performance of pg_basebackup | Shaun Thomas | 14:54 |
| Re: Performance of pg_basebackup | Magnus Hagander | 14:57 |
| Re: Performance of pg_basebackup | Shaun Thomas | 15:00 |
| Re: pg_dump and thousands of schemas 📎 | Jeff Janes | 15:33 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_dump and thousands of schemas | Tatsuo Ishii | 01:45 |
| Thread | Author | Time |
|---|---|---|
| High CPU Usage | Siddharth Shah | 15:15 |
| Thread | Author | Time |
|---|---|---|
| correlated exists with join is slow. | Віталій Тимчишин | 13:47 |
| Re: correlated exists with join is slow. | Tom Lane | 14:52 |
| Re: correlated exists with join is slow. | Kevin Grittner | 14:58 |
| Re: correlated exists with join is slow. | Віталій Тимчишин | 15:02 |
| Re: Expected performance of querying 5k records from 4 million records? | Anish Kejariwal | 16:39 |
| Re: Expected performance of querying 5k records from 4 million records? | Samuel Gendler | 16:49 |
| Re: Expected performance of querying 5k records from 4 million records? | Josh Berkus | 19:08 |
| Thread | Author | Time |
|---|---|---|
| pgbouncer - massive overhead? | Strange, John W | 16:00 |
| Why is a hash join being used? | Tim Jacobs | 21:34 |
| Thread | Author | Time |
|---|---|---|
| index-only scan is missing the INCLUDE feature | Eyal Wilde | 04:46 |
| Re: scale up (postgresql vs mssql) | Eyal Wilde | 06:01 |
| Re: Why is a hash join being used? | Sergey Konoplev | 13:36 |
| Re: scale up (postgresql vs mssql) | Andy Colson | 13:43 |
| Re: index-only scan is missing the INCLUDE feature | Craig Ringer | 14:11 |
| SSD, Postgres and safe write cache | Michal Szymanski | 14:51 |
| Re: scale up (postgresql vs mssql) | Merlin Moncure | 14:55 |
| Re: pgbouncer - massive overhead? | Steve Crawford | 15:27 |
| Re: index-only scan is missing the INCLUDE feature | Shaun Thomas | 15:32 |
| random char or text variable in pgbench | philippe.beaudoin | 19:51 |
| moving tables | Midge Brown | 22:27 |
| Thread | Author | Time |
|---|---|---|
| Re: moving tables | Josh Berkus | 00:28 |
| Re: index-only scan is missing the INCLUDE feature | Craig Ringer | 02:45 |
| Re: moving tables | Albe Laurenz | 08:34 |
| Can I do better than this heapscan and sort? | Andy Halsall | 20:07 |
| Thread | Author | Time |
|---|---|---|
| Performance of a large array access by position (tested version 9.1.3) | Maxim Boguk | 07:02 |
| Re: Why is a hash join being used? | Kevin Grittner | 15:59 |
| Drop statistics? | David Kerr | 17:07 |
| Re: Drop statistics? | Tom Lane | 17:27 |
| Re: Drop statistics? | David Kerr | 18:04 |
| "global/pgstat.stat" corrupt | David Kerr | 18:46 |
| Re: "global/pgstat.stat" corrupt | Tom Lane | 19:49 |
| Re: "global/pgstat.stat" corrupt | David Kerr | 20:11 |
| Thread | Author | Time |
|---|---|---|
| Re: index-only scan is missing the INCLUDE feature | Cédric Villemain | 15:22 |
| Postgres delete performance problem | Frits Jalvingh | 15:42 |
| Re: Postgres delete performance problem | Vitalii Tymchyshyn | 15:52 |