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: how to handle a big table for data log | kuopo | 03:51 |
| Using more tha one index per table | Elias Ghanem | 07:31 |
| Re: Using more tha one index per table | A. Kretschmer | 07:53 |
| Re: Using more tha one index per table | Rob Wultsch | 07:58 |
| Re: Using more tha one index per table | Scott Marlowe | 08:01 |
| Re: Using more tha one index per table | Scott Marlowe | 08:03 |
| tune memory usage for master/slave nodes in cluster | stanimir petrov | 12:42 |
| Re: Using more tha one index per table | Andy Colson | 14:14 |
| Re: Using more tha one index per table | Greg Smith | 14:59 |
| Re: tune memory usage for master/slave nodes in cluster | Greg Smith | 15:08 |
| Re: potential performance gain by query planner optimization | Kneringer, Armin | 16:47 |
| Re: potential performance gain by query planner optimization | Pavel Stehule | 17:21 |
| Thread | Author | Time |
|---|---|---|
| Re: Pooling in Core WAS: Need help in performance tuning. | Robert Haas | 00:57 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Robert Haas | 01:00 |
| Execution Plan | std pik | 04:06 |
| Re: Execution Plan | Pavel Stehule | 07:43 |
| Re: Using more tha one index per table | Torsten Zühlsdorff | 09:22 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Joshua Tolley | 15:55 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Hannu Krosing | 15:58 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Joshua D. Drake | 16:52 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Robert Haas | 17:28 |
| Re: Using more tha one index per table | Craig James | 21:47 |
| Re: Strange explain on partitioned tables | Gerald Fontenay | 22:03 |
| Re: Strange explain on partitioned tables | Joshua D. Drake | 22:16 |
| Thread | Author | Time |
|---|---|---|
| Re: Using more tha one index per table | Dimitri Fontaine | 08:29 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Dimitri Fontaine | 08:40 |
| Slow query using the Cube contrib module. | Liviu Mirea-Ghiban | 10:32 |
| Re: Testing Sandforce SSD | Yeb Havinga | 18:35 |
| Re: Testing Sandforce SSD | Yeb Havinga | 19:13 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Robert Haas | 22:09 |
| 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 |