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: parallel query evaluation | Tom Lane | 15:32 |
| Thread | Author | Time |
|---|---|---|
| Planner sometimes doesn't use a relevant index with IN (subquery) condition | Rafał Rzepecki | 03:18 |
| Thread | Author | Time |
|---|---|---|
| Re: PostreSQL v9.2 uses a lot of memory in Windows XP | Craig Ringer | 02:08 |
| postgres 8.4, COPY, and high concurrency | Jon Nelson | 19:13 |
| Re: postgres 8.4, COPY, and high concurrency | Heikki Linnakangas | 19:27 |
| Re: postgres 8.4, COPY, and high concurrency | Jeff Janes | 19:30 |
| Re: postgres 8.4, COPY, and high concurrency | Jon Nelson | 20:03 |
| Re: postgres 8.4, COPY, and high concurrency | Jeff Janes | 20:43 |
| Poor performance using CTE | David Greco | 20:57 |
| Re: PostreSQL v9.2 uses a lot of memory in Windows XP | Craig Ringer | 23:07 |
| Thread | Author | Time |
|---|---|---|
| Re: SOLVED - RE: Poor performance using CTE | Craig Ringer | 01:17 |
| Re: SOLVED - RE: Poor performance using CTE | Tom Lane | 01:31 |
| Re: SOLVED - RE: Poor performance using CTE | Andrew Dunstan | 01:46 |
| Re: SOLVED - RE: Poor performance using CTE | Peter Geoghegan | 02:03 |
| PQconnectStart/PQconnectPoll | Sergio Mayoral | 09:02 |
| help on slow query using postgres 8.4 | Maria L. Wilson | 15:03 |
| Re: Thousands databases or schemas | Bruce Momjian | 15:49 |
| slow query on postgres 8.4 | Maria L. Wilson | 15:59 |
| Re: SOLVED - RE: Poor performance using CTE | Gavin Flower | 18:26 |
| Query that uses lots of memory in PostgreSQL 9.2.1 in Windows 7 | Antti Jokipii | 19:20 |
| Re: performance regression with 9.2 | Tom Lane | 19:21 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL strange query plan for my query | David Popiashvili | 11:32 |
| PostgreSQL strange query plan for my query | David Popiashvili | 11:40 |
| Re: PostgreSQL strange query plan for my query | Albe Laurenz | 12:55 |
| Re: PostgreSQL strange query plan for my query | David Popiashvili | 13:04 |
| Re: PostgreSQL strange query plan for my query 📎 | Julien Cigar | 13:18 |
| intercepting where clause on a view or other performance tweak | Russell Keane | 14:28 |
| Re: intercepting where clause on a view or other performance tweak | Tom Lane | 15:05 |
| Re: intercepting where clause on a view or other performance tweak | Russell Keane | 15:17 |
| Re: intercepting where clause on a view or other performance tweak | Russell Keane | 15:22 |
| Re: intercepting where clause on a view or other performance tweak | Tom Lane | 15:41 |
| Re: PostgreSQL strange query plan for my query | Craig James | 16:32 |
| Re: PostgreSQL strange query plan for my query | David Popiashvili | 16:35 |
| Re: PostgreSQL strange query plan for my query | Julien Cigar | 16:53 |
| Thread | Author | Time |
|---|---|---|
| partitioning versus clustering | Andrew W. Gibbs | 17:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Poor performance using CTE | Craig Ringer | 00:08 |
| Re: Poor performance using CTE | Gavin Flower | 00:38 |
| Re: Poor performance using CTE | Craig Ringer | 00:42 |
| Re: Hints (was Poor performance using CTE) | Jeff Janes | 00:53 |
| Re: fast read of binary data | Eildert Groeneveld | 07:54 |
| Re: Hints (was Poor performance using CTE) | Heikki Linnakangas | 09:10 |
| Re: fast read of binary data | Heikki Linnakangas | 09:17 |
| Re: PQconnectStart/PQconnectPoll | Craig Ringer | 10:34 |
| SQL performance question | Niklas Paulsson | 12:06 |
| Re: Poor performance using CTE | Jeremy Harris | 13:42 |
| Re: Poor performance using CTE | Jon Nelson | 14:23 |
| Re: SOLVED - RE: Poor performance using CTE | Vitalii Tymchyshyn | 17:37 |
| Thread | Author | Time |
|---|---|---|
| Re: Hints (was Poor performance using CTE) | Cédric Villemain | 10:05 |
| Thread | Author | Time |
|---|---|---|
| Re: SOLVED - RE: Poor performance using CTE | Bruce Momjian | 00:21 |
| Thread | Author | Time |
|---|---|---|
| Re: How to keep queries low latency as concurrency increases | Catalin Iacob | 16:30 |
| Thread | Author | Time |
|---|---|---|
| Re: How to keep queries low latency as concurrency increases | Heikki Linnakangas | 07:46 |
| Thread | Author | Time |
|---|---|---|
| Postgres configuration for 8 CPUs, 6 GB RAM 📎 | Syed Asif Tanveer | 07:47 |
| Re: Postgres configuration for 8 CPUs, 6 GB RAM | Heikki Linnakangas | 13:43 |
| Re: Postgres configuration for 8 CPUs, 6 GB RAM | Andrew Dunstan | 13:56 |
| Re: Postgres configuration for 8 CPUs, 6 GB RAM | Scott Marlowe | 19:53 |
| Savepoints in transactions for speed? | Mike Blackwell | 22:04 |
| Re: Savepoints in transactions for speed? | Richard Huxton | 22:52 |
| Re: How to keep queries low latency as concurrency increases | Scott Marlowe | 23:17 |
| Re: Savepoints in transactions for speed? | Steve Atkins | 23:26 |
| Re: Query that uses lots of memory in PostgreSQL 9.2.1 in Windows 7 | Merlin Moncure | 23:37 |
| Re: Hints (was Poor performance using CTE) | Scott Marlowe | 23:42 |
| Thread | Author | Time |
|---|---|---|
| Re: Optimize update query | Niels Kristian Schjødt | 03:32 |
| Re: Savepoints in transactions for speed? | Claudio Freire | 03:48 |
| Re: Optimize update query | Mark Kirkwood | 04:30 |
| 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL 📎 | Guillaume Cottenceau | 11:33 |
| Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL | Pavan Deolasee | 11:50 |
| Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL | Andres Freund | 12:12 |
| Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL | Pavan Deolasee | 12:29 |
| Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL | Andres Freund | 12:36 |
| Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL | Pavan Deolasee | 12:45 |
| Re: Savepoints in transactions for speed? | Mike Blackwell | 16:38 |
| Re: Savepoints in transactions for speed? | Scott Marlowe | 16:54 |