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: Question of using COPY on a table with triggers | Tom Lane | 00:24 |
| Re: performance on new linux box | Scott Marlowe | 01:22 |
| Re: performance on new linux box | Scott Carey | 03:16 |
| Re: performance on new linux box | Scott Carey | 03:42 |
| Re: performance on new linux box | Ben Chobot | 04:30 |
| Re: performance on new linux box | Craig Ringer | 11:17 |
| Re: performance on new linux box | Craig Ringer | 11:36 |
| Re: Identical query slower on 8.4 vs 8.3 | Igor Neyman | 14:10 |
| Re: Identical query slower on 8.4 vs 8.3 | tv | 14:17 |
| Re: performance on new linux box | Greg Smith | 16:55 |
| Thread | Author | Time |
|---|---|---|
| What is the best way to optimize the query. | Srikanth | 08:50 |
| Thread | Author | Time |
|---|---|---|
| Re: now() gives same time within the session | Heikki Linnakangas | 08:54 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Rajesh Kumar Mallah | 16:18 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Rajesh Kumar Mallah | 16:26 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Hannu Krosing | 16:54 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Rajesh Kumar Mallah | 17:09 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Greg Smith | 17:25 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Rajesh Kumar Mallah | 17:47 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Rajesh Kumar Mallah | 18:08 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Rajesh Kumar Mallah | 18:36 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Scott Carey | 19:00 |
| Thread | Author | Time |
|---|---|---|
| dates and partitioning | Kevin Kempter | 15:36 |
| Re: dates and partitioning | Brad Nicholson | 15:55 |
| Re: dates and partitioning | Jochen Erwied | 15:55 |
| potential performance gain by query planner optimization | Kneringer, Armin | 16:25 |
| Re: potential performance gain by query planner optimization | Pavel Stehule | 19:39 |
| Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem | Scott Carey | 22:58 |
| 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 |