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: Performance question 83 GB Table 150 million rows, distinct select | Alan Hodgson | 23:27 |
| Re: Performance question 83 GB Table 150 million rows, distinct select | Scott Marlowe | 23:32 |
| Re: Performance question 83 GB Table 150 million rows, distinct select | Samuel Gendler | 23:52 |
| Re: Performance question 83 GB Table 150 million rows, distinct select | Tomas Vondra | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: probably cause (and fix) for floating-point assist faults on itanium | Tom Lane | 05:39 |
| Re: Benchmarking tools, methods | Greg Smith | 16:21 |
| Thread | Author | Time |
|---|---|---|
| Re: external sort performance | Jeremy Harris | 13:56 |
| Re: external sort performance | Jon Nelson | 15:00 |
| Re: external sort performance | Jeremy Harris | 16:11 |
| Thread | Author | Time |
|---|---|---|
| Re: Problems with FTS | Rauan Maemirov | 05:53 |
| SSD endurance calculations | Christiaan Willemsen | 21:03 |
| Thread | Author | Time |
|---|---|---|
| Re: SSD endurance calculations | Edgardo Portal | 16:59 |
| Re: SSD options, small database, ZFS | Bruce Momjian | 18:10 |
| Re: SSD options, small database, ZFS | Bruce Momjian | 18:11 |
| Thread | Author | Time |
|---|---|---|
| Autovacuum Issue | J Ramesh Kumar | 05:55 |
| Re: Autovacuum Issue | Raghavendra | 06:10 |
| Re: SSD options, small database, ZFS | Amitabh Kant | 11:33 |
| Re: SSD endurance calculations | Greg Smith | 15:19 |
| Seq Scan used instead of Index Scan | Gary Warner | 22:24 |
| Re: Seq Scan used instead of Index Scan | Claudio Freire | 22:42 |
| Thread | Author | Time |
|---|---|---|
| Re: Seq Scan used instead of Index Scan | Mark Kirkwood | 01:30 |
| Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries | Maxim Boguk | 02:56 |
| Re: Seq Scan used instead of Index Scan | Tom Lane | 03:06 |
| Re: Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries | Tom Lane | 17:05 |
| query uses index but takes too much time? | MirrorX | 17:20 |
| Re: query uses index but takes too much time? | Aidan Van Dyk | 17:51 |
| Re: query uses index but takes too much time? | Cédric Villemain | 19:24 |
| Re: Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries | Maxim Boguk | 22:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries | Craig Ringer | 22:50 |
| Thread | Author | Time |
|---|---|---|
| Re: Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries | Maxim Boguk | 00:05 |
| PostgreSQL 9.1 : why is this query slow? | Joost Kraaijeveld | 16:42 |
| Re: PostgreSQL 9.1 : why is this query slow? | Joost Kraaijeveld | 16:57 |
| Re: PostgreSQL 9.1 : why is this query slow? | Kevin Grittner | 17:05 |
| Re: PostgreSQL 9.1 : why is this query slow? | Joost Kraaijeveld | 17:23 |
| Re: PostgreSQL 9.1 : why is this query slow? | Kevin Grittner | 17:32 |
| Re: PostgreSQL 9.1 : why is this query slow? | Kevin Grittner | 17:36 |
| Re: PostgreSQL 9.1 : why is this query slow? | Tomas Vondra | 19:32 |
| Re: Benchmarking tools, methods | CSS | 22:32 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL 9.1 : why is this query slow? | Joost Kraaijeveld | 15:39 |
| Re: WAL in RAM | Marcus Engene | 16:58 |
| vacuum internals and performance affect | MirrorX | 17:12 |
| Thread | Author | Time |
|---|---|---|
| Guidance Requested - Bulk Inserting + Queries | Benjamin Johnson | 15:27 |
| Re: Guidance Requested - Bulk Inserting + Queries | Leonardo Francalanci | 16:17 |
| Re: Query planner suggestion, for indexes with similar but not exact ordering. | Robert Haas | 20:50 |
| Re: Problems with FTS | Robert Haas | 20:58 |
| Re: vacuum internals and performance affect | Josh Berkus | 21:19 |
| Re: vacuum internals and performance affect | MirrorX | 21:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Guidance Requested - Bulk Inserting + Queries | Benjamin Johnson | 02:00 |
| Re: Problems with FTS | Jesper Krogh | 06:11 |
| Re: Guidance Requested - Bulk Inserting + Queries | Jeff Janes | 15:06 |
| Re: vacuum internals and performance affect | Josh Berkus | 18:01 |
| Re: Autovacuum Issue | Robert Haas | 18:18 |
| Re: vacuum internals and performance affect | MirrorX | 19:23 |
| Re: Autovacuum Issue | Mark Kirkwood | 22:35 |
| Thread | Author | Time |
|---|---|---|
| Re: Autovacuum Issue | Scott Marlowe | 03:02 |
| Intersect/Union X AND/OR | Thiago Godoi | 15:55 |
| Re: Intersect/Union X AND/OR | Bruce Momjian | 19:49 |
| Re: Intersect/Union X AND/OR | Merlin Moncure | 20:52 |
| Thread | Author | Time |
|---|---|---|
| Question about VACUUM | Ernesto Quiñones | 03:32 |
| Re: Question about VACUUM | Scott Marlowe | 03:42 |
| pg_upgrade | Tory M Blue | 04:09 |
| Re: Question about VACUUM | Ernesto Quiñones | 13:11 |
| Re: pg_upgrade | Klaus Ita | 14:03 |
| Re: pg_upgrade | Bruce Momjian | 14:04 |
| manually force planner to use of index A vs index B | MirrorX | 14:34 |
| Re: manually force planner to use of index A vs index B | Tomas Vondra | 15:10 |
| Re: manually force planner to use of index A vs index B | MirrorX | 15:15 |
| Re: Question about VACUUM | Kevin Grittner | 16:00 |
| Re: pg_upgrade | Tory M Blue | 19:35 |
| Re: Question about VACUUM | Scott Marlowe | 20:05 |
| Re: pg_upgrade | Bruce Momjian | 23:42 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_upgrade | Bruce Momjian | 02:20 |
| Re: unlogged tables | Pierre C | 12:28 |
| Thread | Author | Time |
|---|---|---|
| Re: Intersect/Union X AND/OR | Thiago Godoi | 12:14 |
| Re: pg_upgrade | Nicholson, Brad (Toronto, ON, CA) | 13:36 |
| Re: Intersect/Union X AND/OR | Bruce Momjian | 15:19 |
| Re: pg_upgrade | Bruce Momjian | 15:24 |
| Re: pg_upgrade | Nicholson, Brad (Toronto, ON, CA) | 15:29 |
| Re: pg_upgrade | Bruce Momjian | 15:34 |
| Re: Question about VACUUM | Ernesto Quiñones | 17:19 |
| Re: pg_upgrade | Tory M Blue | 17:21 |
| Re: Question about VACUUM | Scott Marlowe | 17:42 |
| Re: Question about VACUUM | Scott Marlowe | 17:44 |
| Re: Question about VACUUM | Ernesto Quiñones | 17:46 |
| Re: pg_upgrade | Bruce Momjian | 18:22 |
| Re: pg_upgrade | Tory M Blue | 18:31 |
| Re: Question about VACUUM | Kevin Grittner | 18:36 |
| Re: pg_upgrade | Tory M Blue | 19:00 |
| Re: pg_upgrade | Bruce Momjian | 19:08 |
| Re: pg_upgrade | Bruce Momjian | 19:08 |
| Re: Question about VACUUM | Scott Marlowe | 20:29 |
| Re: pg_upgrade | Tory M Blue | 23:25 |
| Thread | Author | Time |
|---|---|---|
| Different query plans on same servers | Mario Splivalo | 19:48 |
| Re: Different query plans on same servers | Tom Lane | 20:00 |
| Re: Different query plans on same servers | Kevin Grittner | 20:17 |
| Re: Different query plans on same servers | Kevin Grittner | 20:29 |
| Response time increases over time | Havasvölgyi Ottó | 21:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Response time increases over time | Aidan Van Dyk | 04:37 |
| Re: Response time increases over time | Havasvölgyi Ottó | 08:50 |
| Re: Response time increases over time | Marti Raudsepp | 13:44 |
| Re: Partitions and joins lead to index lookups on all partitions | voodooless | 13:57 |
| Re: Response time increases over time | Havasvölgyi Ottó | 15:48 |
| Re: Response time increases over time | Bob Lunney | 15:58 |
| Re: Response time increases over time | Havasvölgyi Ottó | 17:21 |
| Slow query after upgrade from 8.2 to 8.4 | Kaloyan Iliev Iliev | 17:29 |
| Re: Slow query after upgrade from 8.2 to 8.4 | Shaun Thomas | 17:52 |
| Re: pg_upgrade | Bruce Momjian | 20:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow query after upgrade from 8.2 to 8.4 | Tom Lane | 03:28 |
| Re: Slow query after upgrade from 8.2 to 8.4 📎 | Kaloyan Iliev Iliev | 12:23 |
| Re: Slow query after upgrade from 8.2 to 8.4 | Tom Lane | 15:30 |
| Thread | Author | Time |
|---|---|---|
| Common slow query reasons - help with a special log | Daniel Cristian Cruz | 16:52 |
| Re: Common slow query reasons - help with a special log | Andreas Kretschmer | 17:25 |
| Re: Common slow query reasons - help with a special log | Tomas Vondra | 17:25 |
| Re: Common slow query reasons - help with a special log | Daniel Cristian Cruz | 22:40 |
| Re: Common slow query reasons - help with a special log | Tomas Vondra | 23:50 |
| Thread | Author | Time |
|---|---|---|
| copy vs. C function | Jon Nelson | 01:27 |
| Re: Common slow query reasons - help with a special log | Daniel Cristian Cruz | 01:27 |
| Re: copy vs. C function | Craig Ringer | 02:32 |
| Re: copy vs. C function | Sam Gendler | 02:35 |
| Re: copy vs. C function | Jon Nelson | 03:08 |
| Re: Common slow query reasons - help with a special log | Tomas Vondra | 03:11 |
| Thread | Author | Time |
|---|---|---|
| autovacuum, exclude table | Anibal David Acosta | 14:25 |
| Re: autovacuum, exclude table | Craig Ringer | 14:45 |
| Re: autovacuum, exclude table | Anibal David Acosta | 14:55 |
| Re: autovacuum, exclude table | Heikki Linnakangas | 15:16 |
| Re: autovacuum, exclude table | Tom Lane | 15:26 |
| Re: copy vs. C function | Merlin Moncure | 16:38 |
| Thread | Author | Time |
|---|---|---|
| Postgres array parser | Aleksej Trofimov | 13:55 |
| Re: Postgres array parser | Pavel Stehule | 14:02 |
| Re: Postgres array parser | Aleksej Trofimov | 14:28 |
| Re: copy vs. C function | Jon Nelson | 14:29 |
| Re: Postgres array parser | Pavel Stehule | 14:42 |
| select distinct uses index scan vs full table scan | Jon Nelson | 18:12 |
| Re: select distinct uses index scan vs full table scan | Tom Lane | 19:57 |
| Re: select distinct uses index scan vs full table scan | Jon Nelson | 20:17 |
| Re: Slow query after upgrade from 8.2 to 8.4 | Mark Kirkwood | 22:13 |
| Thread | Author | Time |
|---|---|---|
| Re: copy vs. C function | Tom Lane | 06:18 |
| Re: copy vs. C function | idc danny | 07:02 |
| Re: Postgres array parser | Marc Mamin | 09:21 |
| Re: Postgres array parser | Aleksej Trofimov | 09:59 |
| Re: Postgres array parser | Marc Mamin | 10:27 |