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: planner costs in "warm cache" tests | Scott Carey | 07:13 |
| Re: Zeus IOPS | Mindaugas Riauba | 07:27 |
| Re: Optimize date query for large child tables: GiST or GIN? | Matthew Wakeling | 09:55 |
| Re: PostgreSQL Function Language Performance: C vs PL/PGSQL | Matthew Wakeling | 12:47 |
| Re: PostgreSQL Function Language Performance: C vs PL/PGSQL | Stephen Frost | 12:54 |
| Re: PostgreSQL Function Language Performance: C vs PL/PGSQL | Matthew Wakeling | 12:59 |
| Re: Zeus IOPS | Brad Nicholson | 13:17 |
| Re: planner costs in "warm cache" tests | Tom Lane | 14:03 |
| How to insert a bulk of data with unique-violations very fast | Torsten Zühlsdorff | 15:03 |
| Re: PostgreSQL Function Language Performance: C vs PL/PGSQL | Merlin Moncure | 16:28 |
| Re: Optimize date query for large child tables: GiST or GIN? | Alvaro Herrera | 17:14 |
| PgAdmin iii - Explain. | Jeres Caldeira Gomes | 17:47 |
| Re: Optimize date query for large child tables: GiST or GIN? | David Jarvis | 18:01 |
| Re: Optimize date query for large child tables: GiST or GIN? | Alvaro Herrera | 19:00 |
| Thread | Author | Time |
|---|---|---|
| Re: planner costs in "warm cache" tests | Robert Haas | 01:29 |
| Re: how to force hashaggregate plan? | Robert Haas | 01:40 |
| Re: PgAdmin iii - Explain. | Robert Haas | 01:43 |
| Re: slow query | hubert depesz lubaczewski | 09:02 |
| Re: slow query | Scott Marlowe | 09:38 |
| Re: slow query | Anj Adu | 14:02 |
| Re: slow query | Scott Marlowe | 21:25 |
| Re: How filesystems matter with PostgreSQL | Greg Smith | 22:36 |
| Re: How filesystems matter with PostgreSQL | Jon Schewe | 22:41 |
| Re: Weird XFS WAL problem | Greg Smith | 22:50 |
| Re: How filesystems matter with PostgreSQL | Greg Smith | 22:52 |
| Re: How filesystems matter with PostgreSQL | Jon Schewe | 23:03 |
| Re: How filesystems matter with PostgreSQL | Scott Marlowe | 23:54 |
| Re: How filesystems matter with PostgreSQL | Jon Schewe | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Re: How filesystems matter with PostgreSQL | Scott Marlowe | 00:02 |
| Re: How filesystems matter with PostgreSQL | Jon Schewe | 00:07 |
| Re: How filesystems matter with PostgreSQL | Scott Marlowe | 03:34 |
| Re: How filesystems matter with PostgreSQL | Ron Mayer | 06:51 |
| Re: How filesystems matter with PostgreSQL | Craig Ringer | 07:48 |
| Re: How to insert a bulk of data with unique-violations very fast | Torsten Zühlsdorff | 12:02 |
| Re: How to insert a bulk of data with unique-violations very fast | Torsten Zühlsdorff | 12:05 |
| Re: How to insert a bulk of data with unique-violations very fast | Andy Colson | 12:45 |
| Re: How to insert a bulk of data with unique-violations very fast | Scott Marlowe | 17:46 |
| Re: How to insert a bulk of data with unique-violations very fast | Pierre C | 22:35 |
| Re: performance of temporary vs. regular tables | Pierre C | 22:37 |
| Thread | Author | Time |
|---|---|---|
| Re: How to insert a bulk of data with unique-violations very fast | Torsten Zühlsdorff | 13:21 |
| Re: How to insert a bulk of data with unique-violations very fast | Pierre C | 16:52 |
| Thread | Author | Time |
|---|---|---|
| Re: How to insert a bulk of data with unique-violations very fast | Torsten Zühlsdorff | 07:45 |
| Re: How to insert a bulk of data with unique-violations very fast | Pierre C | 10:51 |
| Large (almost 50%!) performance drop after upgrading to 8.4.4? | Max Williams | 10:56 |
| Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? | Pierre C | 11:35 |
| Re: No hash join across partitioned tables? | Robert Haas | 19:47 |
| Re: No hash join across partitioned tables? | Tom Lane | 20:11 |
| Thread | Author | Time |
|---|---|---|
| Re: Analysis Function | David Jarvis | 00:41 |
| Re: slow query performance | Robert Haas | 00:49 |
| Re: Analysis Function | Andy Colson | 02:11 |