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: 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 |
| Re: SSD, Postgres and safe write cache | Yeb Havinga | 16:05 |
| MemSQL the "world's fastest database"? | Craig James | 16:25 |
| Re: MemSQL the "world's fastest database"? | Shaun Thomas | 17:03 |
| Re: MemSQL the "world's fastest database"? | Kevin Grittner | 17:23 |
| Re: MemSQL the "world's fastest database"? | Josh Berkus | 17:41 |
| Re: MemSQL the "world's fastest database"? | gnuoytr | 18:02 |
| Re: Postgres delete performance problem | Alejandro Carrillo | 19:14 |
| Re: MemSQL the "world's fastest database"? | Tom Lane | 20:15 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of a large array access by position (tested version 9.1.3) | Jesper Krogh | 05:03 |
| Re: Performance of a large array access by position (tested version 9.1.3) | Marc Mamin | 07:53 |
| Re: Performance of a large array access by position (tested version 9.1.3) | Pavel Stehule | 08:04 |
| Re: Performance of a large array access by position (tested version 9.1.3) | Marc Mamin | 08:19 |
| Re: Performance of a large array access by position (tested version 9.1.3) | Pavel Stehule | 08:22 |
| Re: Performance of a large array access by position (tested version 9.1.3) | Pavel Stehule | 09:03 |
| Re: Can I do better than this heapscan and sort? | Merlin Moncure | 13:36 |
| Re: Can I do better than this heapscan and sort? | Merlin Moncure | 13:42 |
| [performance] fast reads on a busy server | Willy-Bas Loos | 22:16 |
| Thread | Author | Time |
|---|---|---|
| Re: [performance] fast reads on a busy server | Hannu Krosing | 07:34 |
| Re: [performance] fast reads on a busy server | Willy-Bas Loos | 10:01 |
| Re: [performance] fast reads on a busy server | Willy-Bas Loos | 11:28 |
| Re: [performance] fast reads on a busy server | Willy-Bas Loos | 11:58 |
| Re: [PERFORM] [performance] fast reads on a busy server | Ants Aasma | 12:58 |
| Re: [PERFORM] [performance] fast reads on a busy server | Willy-Bas Loos | 13:23 |
| Re: Can I do better than this heapscan and sort? | Merlin Moncure | 16:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of a large array access by position (tested version 9.1.3) | Cédric Villemain | 10:22 |
| Thread | Author | Time |
|---|---|---|
| Re: MemSQL the "world's fastest database"? | Greg Smith | 04:18 |
| Re: SSD, Postgres and safe write cache | Greg Smith | 04:37 |
| Re: MemSQL the "world's fastest database"? | Scott Marlowe | 05:00 |
| Thread | Author | Time |
|---|---|---|
| static virtual columns as result? | PV | 09:29 |
| Re: static virtual columns as result? | Kevin Grittner | 13:44 |
| PostgreSQL db, 30 tables with number of rows < 100 (not huge) - the fastest way to clean each non-empty table and reset unique identifier column of empty ones. | Stanislaw Pankevich | 15:22 |
| Re: static virtual columns as result? | PV | 15:43 |
| Re: Drop statistics? | Bruce Momjian | 17:16 |
| Re: MemSQL the "world's fastest database"? | Gregg Jaskiewicz | 21:46 |
| Introducing the TPC-V benchmark, and its relationship to PostgreSQL | Reza Taheri | 23:08 |
| The need for clustered indexes to boost TPC-V performance | Reza Taheri | 23:13 |
| Thread | Author | Time |
|---|---|---|
| Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL | Craig Ringer | 05:19 |
| Re: The need for clustered indexes to boost TPC-V performance | Craig Ringer | 05:43 |
| Re: The need for clustered indexes to boost TPC-V performance | Thomas Kellerer | 07:57 |
| Re: The need for clustered indexes to boost TPC-V performance | Craig Ringer | 08:31 |
| Re: static virtual columns as result? | PV | 10:35 |
| Paged Query | Hermann Matthes | 12:25 |
| Re: The need for clustered indexes to boost TPC-V performance | Daniel Farina | 13:39 |
| Re: The need for clustered indexes to boost TPC-V performance | Claudio Freire | 14:26 |
| Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL | Reza Taheri | 18:24 |
| Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL | Mark Kirkwood | 22:35 |
| Thread | Author | Time |
|---|---|---|
| Re: Drop statistics? | David Kerr | 05:53 |
| Re: The need for clustered indexes to boost TPC-V performance | Robert Klemme | 12:30 |
| Re: The need for clustered indexes to boost TPC-V performance | Reza Taheri | 19:10 |
| Re: The need for clustered indexes to boost TPC-V performance | Reza Taheri | 19:13 |
| Re: The need for clustered indexes to boost TPC-V performance | Samuel Gendler | 19:46 |
| Re: The need for clustered indexes to boost TPC-V performance | Reza Taheri | 20:37 |
| Re: The need for clustered indexes to boost TPC-V performance | Samuel Gendler | 20:52 |