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 |
|---|---|---|
| planner index choice | Chris | 00:51 |
| Re: Testing Sandforce SSD | Greg Spiegelberg | 02:07 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Robert Haas | 03:16 |
| Re: planner index choice | Tom Lane | 03:53 |
| Re: planner index choice | Chris | 07:29 |
| Re: planner index choice | tv | 11:14 |
| Re: Testing Sandforce SSD | Michael Stone | 14:45 |
| Re: planner index choice | Tom Lane | 15:20 |
| On Scalability | Vincenzo Romano | 17:08 |
| Re: On Scalability | Joshua D. Drake | 17:12 |
| Re: On Scalability | Vincenzo Romano | 17:34 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Josh Berkus | 17:39 |
| Re: On Scalability | Joshua D. Drake | 17:39 |
| Re: On Scalability | Vincenzo Romano | 17:52 |
| Re: On Scalability | Joshua D. Drake | 18:16 |
| Re: On Scalability | Josh Berkus | 20:09 |
| Re: On Scalability | Vincenzo Romano | 21:30 |
| How to improve: performance of query on postgresql 8.3 takes days | Dino Vliet | 21:58 |
| Re: How to improve: performance of query on postgresql 8.3 takes days | John R Pierce | 22:17 |
| Thread | Author | Time |
|---|---|---|
| Re: How to improve: performance of query on postgresql 8.3 takes days | A. Kretschmer | 06:11 |
| Re: On Scalability | Vincenzo Romano | 10:24 |
| Re: How to improve: performance of query on postgresql 8.3 takes days | Alban Hertroys | 10:48 |
| Re: On Scalability | Greg Stark | 10:49 |
| Re: On Scalability | Vincenzo Romano | 11:40 |
| Re: Questions on query planner, join types, and work_mem | Tom Lane | 14:03 |
| view columns and performance | Eric Schwarzenbach | 14:55 |
| Re: Testing Sandforce SSD | Yeb Havinga | 15:01 |
| Re: view columns and performance | Tom Lane | 15:11 |
| Re: Testing Sandforce SSD 📎 | Karl Denninger | 15:14 |
| Re: On Scalability | Josh Berkus | 18:51 |
| Re: On Scalability | Vincenzo Romano | 19:50 |
| Re: On Scalability | Greg Smith | 20:38 |
| Re: On Scalability | Robert Haas | 20:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Explains of queries to partitioned tables | Robert Haas | 02:21 |
| what does "initplan" operation in explain output mean? | Mark Rostron | 02:27 |
| Thread | Author | Time |
|---|---|---|
| what does "initplan" operation in explain output mean? | Mark Rostron | 06:36 |
| Re: what does "initplan" operation in explain output mean? | Tom Lane | 14:08 |
| Thread | Author | Time |
|---|---|---|
| Re: Testing Sandforce SSD | Greg Smith | 00:07 |
| Re: Testing Sandforce SSD | Scott Marlowe | 00:12 |
| Re: Questions on query planner, join types, and work_mem | Robert Haas | 02:48 |
| Re: Questions on query planner, join types, and work_mem | Tom Lane | 02:55 |
| Re: Questions on query planner, join types, and work_mem | Hannu Krosing | 07:03 |
| Re: Testing Sandforce SSD | Yeb Havinga | 08:40 |
| Re: Testing Sandforce SSD | Hannu Krosing | 09:08 |
| Re: Testing Sandforce SSD | Yeb Havinga | 11:19 |
| Re: Testing Sandforce SSD | Greg Smith | 14:02 |
| Re: Testing Sandforce SSD | Yeb Havinga | 15:37 |
| Re: Testing Sandforce SSD | Merlin Moncure | 16:27 |
| Re: Testing Sandforce SSD | Chris Browne | 16:58 |
| Re: Testing Sandforce SSD | Chris Browne | 17:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Advice configuring ServeRAID 8k for performance | Mark Kirkwood | 00:31 |
| Re: Advice configuring ServeRAID 8k for performance | Mark Kirkwood | 00:35 |
| Re: Advice configuring ServeRAID 8k for performance | Matthew Wakeling | 09:17 |
| Re: Advice configuring ServeRAID 8k for performance | Scott Marlowe | 16:39 |
| Re: Advice configuring ServeRAID 8k for performance | Justin Pitts | 17:32 |
| Re: Advice configuring ServeRAID 8k for performance | Scott Marlowe | 17:59 |
| Re: Advice configuring ServeRAID 8k for performance | Justin Pitts | 18:17 |
| Thread | Author | Time |
|---|---|---|
| Re: vacuum performance on insert | Sean Chen | 04:32 |
| Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD | Michael March | 23:47 |
| Thread | Author | Time |
|---|---|---|
| Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD | Scott Carey | 06:36 |
| Re: Advice configuring ServeRAID 8k for performance | Scott Carey | 06:46 |
| Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD | Michael March | 06:49 |
| Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD | Scott Marlowe | 06:55 |
| Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD | Michael March | 07:03 |
| Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD | Scott Marlowe | 07:30 |
| Re: Advice configuring ServeRAID 8k for performance | Scott Marlowe | 07:50 |
| Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD | Yeb Havinga | 10:12 |
| Thread | Author | Time |
|---|---|---|
| Re: vacuum performance on insert | Kevin Grittner | 14:03 |
| Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD | Scott Carey | 16:49 |
| Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD | Jeff Davis | 22:41 |
| Thread | Author | Time |
|---|---|---|
| Re: Sorted group by | Matthew Wakeling | 13:46 |
| 32 vs 64 bit build on Solaris Sparc | Joseph Conway | 15:17 |
| Re: 32 vs 64 bit build on Solaris Sparc | Tom Lane | 15:23 |
| Re: Sorted group by | Alvaro Herrera | 15:54 |
| Re: Testing Sandforce SSD | Bruce Momjian | 22:31 |
| Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD | Scott Carey | 23:05 |
| Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD | Scott Carey | 23:10 |
| Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD | Scott Carey | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD | Arjen van der Meijden | 05:59 |
| Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD | Michael March | 06:06 |
| Re: Very bad plan when using VIEW and IN (SELECT...*) | Kevin Grittner | 13:28 |
| Re: Very bad plan when using VIEW and IN (SELECT...*) | Carlo Stonebanks | 14:51 |
| Can WINDOW be used? | Greg Spiegelberg | 16:43 |
| Re: Advice configuring ServeRAID 8k for performance | Bruce Momjian | 18:17 |
| Re: Advice configuring ServeRAID 8k for performance | Greg Smith | 18:41 |
| Re: Can WINDOW be used? | Josh Berkus | 21:17 |
| Thread | Author | Time |
|---|---|---|
| Re: Advice configuring ServeRAID 8k for performance | Scott Carey | 16:28 |
| Re: Advice configuring ServeRAID 8k for performance | Greg Smith | 17:46 |
| Re: Advice configuring ServeRAID 8k for performance | Andres Freund | 20:02 |
| Re: Advice configuring ServeRAID 8k for performance | Greg Smith | 20:13 |
| Re: Advice configuring ServeRAID 8k for performance | Andres Freund | 20:18 |
| Re: Advice configuring ServeRAID 8k for performance | Greg Smith | 20:54 |
| Re: Advice configuring ServeRAID 8k for performance | Andres Freund | 21:05 |
| Thread | Author | Time |
|---|---|---|
| Very poor performance 📎 | Aaron Burnett | 01:06 |
| Re: Advice configuring ServeRAID 8k for performance | Bruce Momjian | 01:31 |
| Re: Very poor performance | Mark Rostron | 01:51 |
| Re: Very poor performance | Aaron Burnett | 02:19 |
| Quesion on the use of indexes | Benjamin Krajmalnik | 03:22 |
| Re: Quesion on the use of indexes | Tom Lane | 03:33 |