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: Postgres query completion status? | Greg Smith | 00:07 |
| Re: Postgres query completion status? | Greg Smith | 00:18 |
| Re: SSD + RAID | Greg Smith | 00:27 |
| Re: SSD + RAID | Merlin Moncure | 14:25 |
| Performance degrade running on multicore computer | afancy | 22:56 |
| Re: Performance degrade running on multicore computer | Tom Lane | 23:13 |
| Thread | Author | Time |
|---|---|---|
| sub-select makes query take too long - unusable | Mark Dueck | 04:41 |
| sub-select makes query take too long - unusable | Mark Dueck | 05:13 |
| Re: sub-select makes query take too long - unusable | Sergey Aleynikov | 08:06 |
| Re: Performance degrade running on multicore computer | afancy | 09:02 |
| Why is the query not using the index for sorting? | Jonathan Blitz | 12:50 |
| Re: Why is the query not using the index for sorting? | Thom Brown | 13:10 |
| Re: Why is the query not using the index for sorting? | Craig Ringer | 13:25 |
| Re: Why is the query not using the index for sorting? | Jonathan Blitz | 13:34 |
| Re: Postgres query completion status? | Richard Neill | 15:10 |
| Re: Postgres query completion status? | Richard Neill | 15:10 |
| Re: Postgres query completion status? | Richard Neill | 15:14 |
| Query times change by orders of magnitude as DB ages | Richard Neill | 15:31 |
| Re: Query times change by orders of magnitude as DB ages | Sergey Aleynikov | 16:13 |
| Thread | Author | Time |
|---|---|---|
| Re: Why is the query not using the index for sorting? | Matthew Wakeling | 11:00 |
| Re: Query times change by orders of magnitude as DB ages | Matthew Wakeling | 12:44 |
| Re: Why is the query not using the index for sorting? | Jonathan Blitz | 14:10 |
| Re: View based upon function won't use index on joins | Robert Haas | 16:47 |
| Re: Query times change by orders of magnitude as DB ages | Robert Haas | 18:11 |
| Re: Performance degrade running on multicore computer | Dave Youatt | 19:10 |
| Re: Strange performance degradation | Lorenzo Allegrucci | 20:46 |
| Best possible way to insert and get returned ids | Jason Dictos | 20:53 |
| Re: Strange performance degradation | Bill Moran | 21:05 |
| Re: Strange performance degradation | Tom Lane | 21:26 |
| Re: Best possible way to insert and get returned ids | Scott Marlowe | 21:55 |
| query optimization | Faheem Mitha | 22:47 |
| Re: query optimization | Thom Brown | 23:25 |
| Re: query optimization | Faheem Mitha | 23:49 |
| Re: query optimization | marcin mank | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Query times change by orders of magnitude as DB ages | Matthew Wakeling | 11:14 |
| Re: Query times change by orders of magnitude as DB ages | Sergey Aleynikov | 12:11 |
| Re: Query times change by orders of magnitude as DB ages | Sergey Aleynikov | 12:36 |
| Re: Query times change by orders of magnitude as DB ages | Richard Neill | 16:04 |
| Analyse without locking? | Richard Neill | 16:20 |
| Re: Analyse without locking? | Grzegorz Jaśkiewicz | 16:26 |
| Re: Analyse without locking? | Tom Lane | 16:26 |
| Re: Analyse without locking? | Andres Freund | 17:26 |
| Thread | Author | Time |
|---|---|---|
| Re: RAID card recommendation | Ron Mayer | 04:49 |
| Re: Analyse without locking? | Greg Smith | 11:51 |
| Re: query optimization | Faheem Mitha | 21:47 |
| Thread | Author | Time |
|---|---|---|
| OpenMP in PostgreSQL-8.4.0 | Reydan Cankur | 12:10 |
| Re: OpenMP in PostgreSQL-8.4.0 | Denis Lussier | 14:21 |
| Re: SSD + RAID 📎 | Bruce Momjian | 16:20 |
| Re: OpenMP in PostgreSQL-8.4.0 | Tom Lane | 16:42 |
| Re: Analyse without locking? | Richard Neill | 17:57 |
| Re: Analyse without locking? | Tom Lane | 19:21 |
| Re: OpenMP in PostgreSQL-8.4.0 | Reydan Cankur | 21:00 |
| Re: Analyse without locking? | Greg Smith | 22:28 |
| Thread | Author | Time |
|---|---|---|
| Re: Analyse without locking? | Richard Neill | 01:31 |
| Re: OpenMP in PostgreSQL-8.4.0 | Bruce Momjian | 13:05 |
| Re: OpenMP in PostgreSQL-8.4.0 | Reydan Cankur | 13:24 |
| Re: OpenMP in PostgreSQL-8.4.0 | Tom Lane | 14:52 |
| Re: OpenMP in PostgreSQL-8.4.0 | Greg Stark | 15:34 |
| Any have tested ZFS like PostgreSQL installation filesystem? | Ing . Marcos Luís Ortíz Valmaseda | 21:42 |
| Thread | Author | Time |
|---|---|---|
| Re: SSD + RAID | Ron Mayer | 00:46 |
| Re: SSD + RAID | Bruce Momjian | 03:09 |
| Re: SSD + RAID | Greg Smith | 05:12 |
| Re: Any have tested ZFS like PostgreSQL installation filesystem? | Ing . Marcos Luís Ortíz Valmaseda | 06:27 |
| Re: Any have tested ZFS like PostgreSQL installation filesystem? | Ivan Voras | 12:00 |
| Re: SSD + RAID | Bruce Momjian | 12:08 |
| Re: Any have tested ZFS like PostgreSQL installation filesystem? | Ivan Voras | 12:33 |
| Re: query optimization | Robert Haas | 15:40 |
| Re: SSD + RAID | Ron Mayer | 15:48 |
| Re: SSD + RAID | Ron Mayer | 16:32 |
| Re: SSD + RAID | Bruce Momjian | 16:40 |
| Cost of sort/order by not estimated by the query planner | Laurent Laborde | 16:54 |
| Re: Server Freezing | Denis Lussier | 17:12 |
| truncate in transaction blocks read access | Craig James | 18:50 |
| Re: truncate in transaction blocks read access | Joshua D. Drake | 19:31 |
| Re: Server Freezing | Fernando Hevia | 20:12 |
| Re: Server Freezing | Robert Haas | 22:08 |
| Thread | Author | Time |
|---|---|---|
| Re: Server Freezing | Greg Smith | 00:08 |
| Server Freezing | Waldomiro | 01:02 |
| Re: Server Freezing | Waldomiro | 11:02 |
| Re: Server Freezing 📎 | Waldomiro | 11:18 |
| Re: Server Freezing | Fernando Hevia | 15:50 |
| Order by (for 15 rows) adds 30 seconds to query time | Richard Neill | 18:52 |
| Re: Order by (for 15 rows) adds 30 seconds to query time | Jean-Michel Pouré | 20:06 |
| Re: Order by (for 15 rows) adds 30 seconds to query time | Kevin Grittner | 20:06 |
| Re: Order by (for 15 rows) adds 30 seconds to query time | Richard Neill | 22:46 |
| Re: Order by (for 15 rows) adds 30 seconds to query time | Kevin Grittner | 23:36 |
| Thread | Author | Time |
|---|---|---|
| Re: RAID card recommendation | Scott Carey | 01:37 |
| Re: RAID card recommendation 📎 | Karl Denninger | 02:08 |
| Re: RAID card recommendation | Greg Smith | 02:49 |
| Re: Order by (for 15 rows) adds 30 seconds to query time | Richard Neill | 05:42 |
| Re: Order by (for 15 rows) adds 30 seconds to query time | Matthew Wakeling | 11:08 |
| Re: Cost of sort/order by not estimated by the query planner | Laurent Laborde | 11:13 |
| Re: Cost of sort/order by not estimated by the query planner | Greg Stark | 12:42 |
| Re: Cost of sort/order by not estimated by the query planner | Laurent Laborde | 12:47 |