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: Analysis Function | Bruce Momjian | 00:42 |
| What is the best way to optimize this query | Srikanth Kata | 05:19 |
| how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer | Rajesh Kumar Mallah | 09:41 |
| Re: Extremely high CPU usage when building tables | Rajesh Kumar Mallah | 09:49 |
| Re: PostgreSQL as a local in-memory cache | Greg Smith | 10:00 |
| Re: What is the best way to optimize this query | Rajesh Kumar Mallah | 12:40 |
| Re: What is the best way to optimize this query | Thom Brown | 12:51 |
| optimal ZFS filesystem on JBOD layout | Joachim Worringen | 13:14 |
| Re: optimal ZFS filesystem on JBOD layout | Greg Smith | 14:15 |
| Re: how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer | Craig Ringer | 16:37 |
| Re: how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer | Rajesh Kumar Mallah | 17:59 |
| big data - slow select (speech search) | Michal Fapso | 22:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Highly Efficient Custom Sorting | Craig Ringer | 01:44 |
| Re: Highly Efficient Custom Sorting | Eliot Gable | 03:17 |
| Re: Highly Efficient Custom Sorting | Merlin Moncure | 18:08 |
| Re: Highly Efficient Custom Sorting | Eliot Gable | 20:17 |
| Re: Highly Efficient Custom Sorting | Merlin Moncure | 22:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Highly Efficient Custom Sorting | Alvaro Herrera | 02:47 |
| Re: Performance issues with postgresql-8.4.0 | Craig Ringer | 12:38 |
| Thread | Author | Time |
|---|---|---|
| Two "equivalent" WITH RECURSIVE queries, one of them slow. | Octavio Alvarez | 06:07 |
| Re: Slow query with planner row strange estimation | damien hostin | 07:28 |
| Re: how to (temporarily) disable/minimize benefits of disk block cache or postgresql shared buffer | Matthew Wakeling | 09:55 |
| SeqScans on boolen values / How to speed this up? | Jens Hoffrichter | 11:36 |
| Re: SeqScans on boolen values / How to speed this up? | Stephen Frost | 13:47 |
| Re: using dbt2 postgresql 8.4 - rampup time issue | MUHAMMAD ASIF | 17:24 |
| 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 |