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: CPU 100% usage caused by unknown postgres process.. | Laurenz Albe | 10:36 |
| Re: CPU 100% usage caused by unknown postgres process.. | Justin Pryzby | 12:19 |
| Re: CPU 100% usage caused by unknown postgres process.. | Tomas Vondra | 15:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Bitmap scan is undercosted? - overestimated correlation and cost_index | Justin Pryzby | 20:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Bitmap scan is undercosted? - overestimated correlation and cost_index | Justin Pryzby | 19:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Bitmap scan is undercosted? - overestimated correlation and cost_index | Justin Pryzby | 02:37 |
| Thread | Author | Time |
|---|---|---|
| WHERE IN for JOIN subquery? | Dave Johansen | 00:00 |
| Re: WHERE IN for JOIN subquery? | David G. Johnston | 00:10 |
| Re: WHERE IN for JOIN subquery? | Dave Johansen | 00:29 |
| Autoanalyze CPU usage | Habib Nahas | 16:47 |
| Re: Autoanalyze CPU usage | Justin Pryzby | 17:09 |
| Re: Autoanalyze CPU usage | Tomas Vondra | 22:03 |
| Re: Autoanalyze CPU usage | Habib Nahas | 22:53 |
| Re: Autoanalyze CPU usage | Habib Nahas | 22:53 |
| Re: Autoanalyze CPU usage | Justin Pryzby | 22:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Autoanalyze CPU usage | Michaeldba@sqlexec.com | 01:10 |
| Re: Autoanalyze CPU usage | Laurenz Albe | 07:15 |
| Re: Autoanalyze CPU usage | Nikolay Samokhvalov | 08:24 |
| Re: Autoanalyze CPU usage | Habib Nahas | 14:38 |
| Thread | Author | Time |
|---|---|---|
| Updating a large table | Timokhin Maxim | 16:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Updating a large table | salah jubeh | 11:31 |
| Re: Updating a large table | Tomas Vondra | 20:58 |
| Thread | Author | Time |
|---|---|---|
| Batch insert heavily affecting query performance. | Jean Baro | 19:51 |
| Re: Batch insert heavily affecting query performance. | MichaelDBA@sqlexec.com | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Batch insert heavily affecting query performance. | Jean Baro | 00:09 |
| Re: Batch insert heavily affecting query performance. | MichaelDBA | 01:30 |
| Re: Batch insert heavily affecting query performance. | Danylo Hlynskyi | 02:59 |
| Re: Batch insert heavily affecting query performance. | Jean Baro | 03:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Batch insert heavily affecting query performance. | Jean Baro | 15:13 |
| Re: Batch insert heavily affecting query performance. | Rick Otten | 15:38 |
| RE: Batch insert heavily affecting query performance. | Mike Sofen | 15:58 |
| Re: Batch insert heavily affecting query performance. | Jeremy Finzel | 16:02 |
| Re: Batch insert heavily affecting query performance. | Jean Baro | 16:23 |
| Re: Batch insert heavily affecting query performance. | Jeff Janes | 16:23 |
| Re: Batch insert heavily affecting query performance. | Jean Baro | 16:34 |
| RE: Batch insert heavily affecting query performance. | Jean Baro | 16:36 |
| Re: Batch insert heavily affecting query performance. | Jean Baro | 16:37 |
| Re: Batch insert heavily affecting query performance. | Jean Baro | 17:02 |
| Re: Batch insert heavily affecting query performance. | Alvaro Hernandez | 17:09 |
| RE: Batch insert heavily affecting query performance. | Mike Sofen | 17:10 |
| Re: Batch insert heavily affecting query performance. | David Miller | 17:15 |
| Thread | Author | Time |
|---|---|---|
| Table performance with millions of rows | Robert Blayzor | 00:54 |
| Re: Table performance with millions of rows (partitioning) | Justin Pryzby | 01:20 |
| Re: Table performance with millions of rows (partitioning) | Robert Blayzor | 01:27 |
| Re: Table performance with millions of rows (partitioning) | pinker | 02:22 |
| Thread | Author | Time |
|---|---|---|
| partitioning an existing table | Robert Blayzor | 04:37 |
| Re: partitioning an existing table | Justin Pryzby | 05:38 |
| analyze stats: child vs parent | Justin Pryzby | 05:56 |
| Re: partitioning an existing table | Robert Blayzor | 14:19 |
| Re: partitioning an existing table - efficient pg_dump | Justin Pryzby | 18:42 |
| Thread | Author | Time |
|---|---|---|
| Restoring a table is ten times slower on Ubuntu 14.04 than on Ubuntu 16.04 | Hans Braxmeier | 13:27 |
| Re: Restoring a table is ten times slower on Ubuntu 14.04 than on Ubuntu 16.04 | Vasilis Ventirozos | 13:30 |
| primary key hash index | Rick Otten | 14:02 |
| Re: primary key hash index | Magnus Hagander | 14:09 |
| Thread | Author | Time |
|---|---|---|
| Re: primary key hash index | Jeff Janes | 20:01 |
| Thread | Author | Time |
|---|---|---|
| GEQO and join_collapse_limit correlation 📎 | Juan José Santamaría Flecha | 14:30 |
| Re: GEQO and join_collapse_limit correlation | Tom Lane | 16:16 |
| Re: GEQO and join_collapse_limit correlation | Juan José Santamaría Flecha | 20:17 |
| Re: GEQO and join_collapse_limit correlation | Tom Lane | 20:29 |
| Thread | Author | Time |
|---|---|---|
| Re: GEQO and join_collapse_limit correlation | Juan José Santamaría Flecha | 11:31 |
| Thread | Author | Time |
|---|---|---|
| seeing lag in postgresql replication | Rambabu V | 09:21 |
| Re: seeing lag in postgresql replication | Mariel Cherkassky | 10:31 |
| Thread | Author | Time |
|---|---|---|
| Need Help on wal_compression | Rambabu V | 06:53 |
| Re: Updating a large table | Timokhin Maxim | 12:18 |
| Re: Updating a large table | Sergei Kornilov | 12:53 |
| Re: Updating a large table | Timokhin Maxim | 16:31 |
| Re: Need Help on wal_compression | Claudio Freire | 16:53 |
| Re: Batch insert heavily affecting query performance. | Claudio Freire | 19:45 |
| Re: Need Help on wal_compression | Scott Marlowe | 20:39 |
| Performance of a Query 📎 | Kumar, Virendra | 21:18 |
| View preformance oracle to postgresql | Reddygari, Pavan | 21:32 |
| Re: Need Help on wal_compression | Jeff Janes | 21:33 |
| Re: Performance of a Query | Scott Marlowe | 22:08 |
| RE: Performance of a Query | Kumar, Virendra | 22:25 |
| PG 9.5 2 tables same DDL with diff size | ghiureai | 22:54 |
| Re: Performance of a Query | Scott Marlowe | 22:59 |
| RE: Performance of a Query 📎 | Kumar, Virendra | 23:09 |
| Re: Performance of a Query | Scott Marlowe | 23:25 |
| Thread | Author | Time |
|---|---|---|
| Slow queries after Windows startup | POUSSEL, Guillaume | 08:19 |
| Re: Slow queries after Windows startup | Robert Zenz | 09:01 |
| RE: Slow queries after Windows startup | POUSSEL, Guillaume | 09:06 |
| Re: Slow queries after Windows startup | Robert Zenz | 09:54 |
| RE: Slow queries after Windows startup | POUSSEL, Guillaume | 13:36 |
| Disjunctions and sequential scans 📎 | Ronuk Raval | 16:30 |
| RE: Slow queries after Windows startup | Éric Fontaine | 21:08 |
| Thread | Author | Time |
|---|---|---|
| PGadmin error while connecting with database. | Dinesh Chandra 12108 | 04:55 |
| Re: Query is slow when run for first time; subsequent execution is fast | Nandakumar M | 08:03 |
| Re: PGadmin error while connecting with database. | Mariel Cherkassky | 08:44 |
| Re: Query is slow when run for first time; subsequent execution is fast | Pavel Stehule | 10:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: PGadmin error while connecting with database. | Dinesh Chandra 12108 | 04:10 |
| HDD vs SSD without explanation | Neto pr | 20:44 |
| Re: HDD vs SSD without explanation | Justin Pryzby | 21:40 |
| Re: HDD vs SSD without explanation | Neto pr | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: HDD vs SSD without explanation | Neto pr | 02:25 |
| Re: HDD vs SSD without explanation | Neto pr | 02:36 |
| Re: HDD vs SSD without explanation | Justin Pryzby | 03:09 |
| Re: HDD vs SSD without explanation | Neto pr | 11:04 |
| Re: HDD vs SSD without explanation | Neto pr | 12:35 |
| Re: HDD vs SSD without explanation | Georg H. | 18:32 |
| Re: HDD vs SSD without explanation | Brian Busch | 19:46 |
| Re: HDD vs SSD without explanation | Fernando Hevia | 19:55 |
| Re: HDD vs SSD without explanation | Neto pr | 23:10 |
| Re: HDD vs SSD without explanation | Neto pr | 23:25 |
| Thread | Author | Time |
|---|---|---|
| Re: HDD vs SSD without explanation | Fernando Hevia | 00:18 |
| Re: HDD vs SSD without explanation | Neto pr | 01:19 |
| Re: HDD vs SSD without explanation | Justin Pryzby | 01:58 |
| Re: HDD vs SSD without explanation | Neto pr | 02:25 |
| Re: HDD vs SSD without explanation | Mark Kirkwood | 04:04 |
| Re: HDD vs SSD without explanation | Neto pr | 10:14 |
| Fwd: Re: Query is slow when run for first time; subsequent execution is fast | Nandakumar M | 11:46 |
| Re: Query is slow when run for first time; subsequent execution is fast | Thomas Kellerer | 12:20 |
| Re: HDD vs SSD without explanation | Nicolas Charles | 15:08 |
| Re: HDD vs SSD without explanation | Mark Kirkwood | 21:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Query is slow when run for first time; subsequent execution is fast | Jeff Janes | 05:18 |
| RE: Query is slow when run for first time; subsequent execution is fast | POUSSEL, Guillaume | 07:25 |
| RE: Query is slow when run for first time; subsequent execution is fast | Nandakumar M | 10:09 |
| Thread | Author | Time |
|---|---|---|
| Re: Query is slow when run for first time; subsequent execution is fast | Michael Paquier | 01:55 |
| pgaudit and create postgis extension logs a lot inserts | Svensson Peter | 12:12 |
| need help on memory allocation | Rambabu V | 15:25 |
| Re: pgaudit and create postgis extension logs a lot inserts | Joe Conway | 16:54 |
| Thread | Author | Time |
|---|---|---|
| Re: need help on memory allocation | Laurenz Albe | 10:07 |
| SV: pgaudit and create postgis extension logs a lot inserts | Svensson Peter | 11:03 |
| Re: pgaudit and create postgis extension logs a lot inserts | Magnus Hagander | 11:05 |
| RE: pgaudit and create postgis extension logs a lot inserts | Karen Stone | 12:24 |
| Re: pgaudit and create postgis extension logs a lot inserts | David Steele | 13:41 |
| Re: pgaudit and create postgis extension logs a lot inserts | David Steele | 13:51 |
| Performance impact of lowering max_files_per_process | Thomas Kellerer | 16:48 |
| Thread | Author | Time |
|---|---|---|
| Re: pgaudit and create postgis extension logs a lot inserts | Magnus Hagander | 13:05 |
| Thread | Author | Time |
|---|---|---|
| query execution time (with cache) | Neto pr | 18:43 |
| Thread | Author | Time |
|---|---|---|
| Re: 8.2 Autovacuum BUG ? | pavan95 | 06:09 |
| SV: pgaudit and create postgis extension logs a lot inserts | Svensson Peter | 08:20 |
| Re: 8.2 Autovacuum BUG ? | Sergei Kornilov | 09:41 |
| Re: 8.2 Autovacuum BUG ? | pavan95 | 10:21 |
| Re: 8.2 Autovacuum BUG ? | Andreas Kretschmer | 11:47 |
| PG 9.6 Slow inserts with long-lasting LWLocks | Pavel Suderevsky | 18:43 |
| Thread | Author | Time |
|---|---|---|
| Re: 8.2 Autovacuum BUG ? | pavan95 | 07:04 |
| Re: 8.2 Autovacuum BUG ? | pavan95 | 11:51 |
| Bad plan | Laurent Martelli | 12:03 |
| Re: need help on memory allocation | Rambabu V | 13:59 |
| Re: need help on memory allocation | Andreas Kretschmer | 14:08 |
| RE: Inefficient full seq scan on pg_largeobject instead of index scan | Jean-Marc Lessard | 14:08 |
| Re: 8.2 Autovacuum BUG ? | Andreas Kretschmer | 14:17 |
| Re: 8.2 Autovacuum BUG ? | Pavan Teja | 14:39 |
| Re: 8.2 Autovacuum BUG ? | David G. Johnston | 14:45 |
| Re: 8.2 Autovacuum BUG ? | Andreas Kretschmer | 14:57 |
| Re: Bad plan | Justin Pryzby | 15:18 |
| Re: 8.2 Autovacuum BUG ? | Pavan Teja | 15:20 |
| Re: 8.2 Autovacuum BUG ? | Andreas Kretschmer | 15:26 |
| Re: Bad plan 📎 | Laurent Martelli | 15:38 |
| Re: Bad plan | Laurent Martelli | 15:59 |
| Re: 8.2 Autovacuum BUG ? | Claudio Freire | 16:07 |
| Re: 8.2 Autovacuum BUG ? | Pavan Teja | 16:16 |
| Re: Bad plan | Matthew Bellew | 17:18 |
| Re: need help on memory allocation | Laurenz Albe | 18:36 |
| Re: need help on memory allocation | Jeff Janes | 22:36 |
| Re: 8.2 Autovacuum BUG ? | Claudio Freire | 22:59 |
| Thread | Author | Time |
|---|---|---|
| Re: need help on memory allocation | pavan95 | 05:54 |
| Re: 8.2 Autovacuum BUG ? | pavan95 | 06:54 |
| Re: Performance impact of lowering max_files_per_process | Thomas Kellerer | 07:09 |
| Re: need help on memory allocation | Michael Paquier | 07:15 |
| Re: need help on memory allocation | pavan95 | 07:34 |
| Re: 8.2 Autovacuum BUG ? | Claudio Freire | 07:42 |
| Re: need help on memory allocation | Vitaliy Garnashevich | 08:03 |
| pg_xlog unbounded growth 📎 | Stefan Petrea | 11:48 |
| Re: 8.2 Autovacuum BUG ? | pavan95 | 11:50 |
| Re: 8.2 Autovacuum BUG ? | Claudio Freire | 14:27 |
| Re: 8.2 Autovacuum BUG ? | Pavan Teja | 14:48 |
| Re: 8.2 Autovacuum BUG ? | David G. Johnston | 14:57 |
| Re: 8.2 Autovacuum BUG ? | Alvaro Herrera | 15:19 |
| Thread | Author | Time |
|---|---|---|
| Re: 8.2 Autovacuum BUG ? | pavan95 | 03:47 |
| Re: pg_xlog unbounded growth | Laurenz Albe | 16:57 |
| Re: 8.2 Autovacuum BUG ? | Alvaro Herrera | 21:30 |
| Re: pg_xlog unbounded growth | Tomas Vondra | 21:36 |
| Thread | Author | Time |
|---|---|---|
| Re: 8.2 Autovacuum BUG ? | Pavan Teja | 00:32 |
| Re: Query is slow when run for first time; subsequent execution is fast | Nandakumar M | 07:43 |
| Re: pg_xlog unbounded growth | Andreas Kretschmer | 08:18 |
| PG 10 hash index create times | Rick Otten | 10:58 |
| Thread | Author | Time |
|---|---|---|
| copy csv into partitioned table with unique index | Mariel Cherkassky | 09:11 |
| Re: copy csv into partitioned table with unique index | legrand legrand | 10:55 |
| SV: copy csv into partitioned table with unique index | Lars Aksel Opsahl | 11:57 |
| SV: copy csv into partitioned table with unique index | Lars Aksel Opsahl | 12:04 |
| Query Slow After 2018 | Nur Agus | 17:32 |
| Re: Query Slow After 2018 | Justin Pryzby | 17:51 |
| Re: Query Slow After 2018 | David G. Johnston | 21:40 |
| Re: [PERFORM] performance drop after upgrade (9.6 > 10) | Bruce Momjian | 23:53 |
| Thread | Author | Time |
|---|---|---|
| Re: 8.2 Autovacuum BUG ? | Pavan Teja | 04:46 |