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 |
|---|---|---|
| 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 |