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: 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: Order by (for 15 rows) adds 30 seconds to query time | Richard Neill | 01:31 |
| Re: Query times change by orders of magnitude as DB ages | Scott Carey | 03:15 |
| Re: Analyse without locking? | Richard Neill | 06:23 |
| Re: Cost of sort/order by not estimated by the query planner | Hitoshi Harada | 06:58 |
| Re: Checkpoint spikes | Greg Smith | 07:04 |
| BUG #5228: Execution of prepared query is slow when timestamp parameter is used | aftab | 08:25 |
| Re: Cost of sort/order by not estimated by the query planner | Laurent Laborde | 08:51 |
| Re: [BUGS] BUG #5228: Execution of prepared query is slow when timestamp parameter is used | Craig Ringer | 08:52 |
| Re: Cost of sort/order by not estimated by the query planner | Laurent Laborde | 09:08 |
| Re: Analyse without locking? | Laurent Laborde | 09:44 |
| Re: Checkpoint spikes | Heikki Linnakangas | 11:27 |
| Re: Checkpoint spikes | Greg Smith | 20:57 |
| Thread | Author | Time |
|---|---|---|
| Re: SSD + RAID | Scott Carey | 00:04 |
| query cost too high, anyway to reduce it | nair rajiv | 10:15 |
| Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum | Andreas Thiel | 23:03 |
| Thread | Author | Time |
|---|---|---|
| Time Profiling inside the procedure | niraj patel | 01:18 |
| Re: performance while importing a very large data set in to database | Ing . Marcos Luís Ortíz Valmaseda | 14:16 |
| Re: performance while importing a very large data set in to database | Jeremy Harris | 19:25 |
| Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum | Andres Freund | 20:00 |
| Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum | Scott Marlowe | 20:39 |
| Re: performance while importing a very large data set in to database | Scott Marlowe | 20:42 |
| Re: query cost too high, anyway to reduce it | Scott Marlowe | 20:45 |
| Re: performance while importing a very large data set in to database | Scott Marlowe | 23:09 |
| Thread | Author | Time |
|---|---|---|
| Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum | Craig Ringer | 01:15 |
| Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum | Greg Smith | 01:33 |
| Re: performance while importing a very large data set in to database | Pierre Frédéric Caillaud | 14:14 |
| Re: performance while importing a very large data set in to database | Kris Kewley | 14:15 |
| Re: performance while importing a very large data set in to database | Greg Smith | 15:15 |
| Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum | Andres Freund | 16:51 |
| Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum | Andres Freund | 19:09 |
| Re: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum | Scott Marlowe | 20:24 |
| Thread | Author | Time |
|---|---|---|
| Load experimentation | Ben Brehmer | 18:12 |
| Re: Load experimentation | Kevin Grittner | 18:33 |
| Re: Load experimentation | Scott Mead | 18:33 |
| Re: Load experimentation | Thom Brown | 18:39 |
| Re: Load experimentation | Ben Brehmer | 18:45 |
| Re: Load experimentation | Craig James | 18:50 |
| Re: RAID card recommendation | Scott Carey | 19:04 |
| Re: RAID card recommendation | Scott Carey | 19:10 |
| Re: Load experimentation | Ben Brehmer | 19:12 |
| Re: Load experimentation | Craig James | 19:21 |
| Re: RAID card recommendation 📎 | Karl Denninger | 19:47 |
| Re: Load experimentation | Alan Hodgson | 19:48 |
| Re: Load experimentation | Greg Smith | 20:59 |