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: Index usage with functions in where condition | Jeremy Palmer | 00:25 |
| Re: Need help in performance tuning. | Kevin Grittner | 00:31 |
| Re: Need help in performance tuning. | Mark Kirkwood | 01:01 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Josh Berkus | 01:25 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Samuel Gendler | 03:29 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Craig Ringer | 03:33 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Robert Haas | 03:47 |
| Re: Need help in performance tuning. | Jesper Krogh | 06:33 |
| Re: Need help in performance tuning. | Greg Smith | 12:30 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Josh Berkus | 18:42 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Tom Lane | 18:51 |
| Thread | Author | Time |
|---|---|---|
| Re: performance on new linux box | Ryan Wexler | 20:02 |
| Re: Need help in performance tuning. | Pierre C | 22:47 |
| Thread | Author | Time |
|---|---|---|
| Re: partition queries hitting all partitions even though check key is specified | Josh Berkus | 03:01 |
| Re: partition queries hitting all partitions even though check key is specified | Joshua D. Drake | 04:00 |
| Who are you voting for? 📎 | kangayarkanni | 05:52 |
| Re: Slow query with planner row strange estimation | damien hostin | 08:51 |
| Queries with conditions using bitand operator | Elias Ghanem | 11:48 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Dimitri Fontaine | 14:42 |
| Re: Pooling in Core WAS: Need help in performance tuning. | Magnus Hagander | 14:44 |
| Re: Queries with conditions using bitand operator | Andy Colson | 23:19 |
| Re: performance on new linux box | Andy Colson | 23:26 |
| 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 |