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: Optimization idea | Vlad Arkhipov | 02:52 |
| Re: Optimization idea | Cédric Villemain | 09:33 |
| Re: Planner issue on sorting joining of two tables with limit | Tom Lane | 16:51 |
| Re: autovacuum strategy / parameters | Alvaro Herrera | 16:58 |
| tmpfs and postgres memory | Anj Adu | 23:24 |
| Thread | Author | Time |
|---|---|---|
| Re: tmpfs and postgres memory | Greg Spiegelberg | 03:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Optimization idea | Robert Haas | 00:46 |
| Re: autovacuum strategy / parameters | Robert Haas | 00:55 |
| Re: tmpfs and postgres memory | Robert Haas | 00:56 |
| Re: Optimization idea | Cédric Villemain | 07:49 |
| Re: Optimization idea | Vlad Arkhipov | 09:38 |
| Re: autovacuum strategy / parameters | Kevin Grittner | 13:53 |
| Re: autovacuum strategy / parameters | Thomas Kellerer | 14:20 |
| Re: autovacuum strategy / parameters | akp geek | 14:37 |
| Re: autovacuum strategy / parameters | Kenneth Marshall | 14:45 |
| Re: autovacuum strategy / parameters | Thomas Kellerer | 14:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Optimization idea | Robert Haas | 03:17 |
| Re: Optimization idea | Cédric Villemain | 08:21 |
| Thread | Author | Time |
|---|---|---|
| Re: autovacuum strategy / parameters | Josh Berkus | 22:50 |
| Thread | Author | Time |
|---|---|---|
| Re: autovacuum strategy / parameters | Alvaro Herrera | 03:08 |
| Re: Optimization idea | Cédric Villemain | 10:52 |
| Re: autovacuum strategy / parameters | Robert Haas | 11:39 |
| Re: Optimization idea | Cédric Villemain | 12:00 |
| Re: autovacuum strategy / parameters | Scott Marlowe | 16:08 |
| Re: autovacuum strategy / parameters | Scott Marlowe | 16:13 |
| Re: autovacuum strategy / parameters | Greg Smith | 17:11 |
| Re: autovacuum strategy / parameters | Tom Lane | 17:25 |
| Re: autovacuum strategy / parameters | Robert Haas | 19:08 |
| Re: autovacuum strategy / parameters | Scott Marlowe | 19:17 |
| Re: autovacuum strategy / parameters | Scott Marlowe | 19:19 |
| Re: autovacuum strategy / parameters | Robert Haas | 19:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Planner issue on sorting joining of two tables with limit | Alexander Korotkov | 13:57 |
| Thread | Author | Time |
|---|---|---|
| partioning tips? | Richard Yen | 20:25 |
| Re: partioning tips? | Dave Crooke | 21:31 |
| Thread | Author | Time |
|---|---|---|
| PgPool II configuration with PostgreSQL 8.4 | Neha Mehta | 04:17 |
| Re: PgPool II configuration with PostgreSQL 8.4 | Marcos Ortiz | 06:29 |
| Re: Planner issue on sorting joining of two tables with limit | Alexander Korotkov | 06:54 |
| Re: PgPool II configuration with PostgreSQL 8.4 | Tatsuo Ishii | 07:09 |
| Re: PgPool II configuration with PostgreSQL 8.4 | Rosser Schwarz | 22:28 |
| Thread | Author | Time |
|---|---|---|
| Re: debugging handle exhaustion and 15 min/ 5mil row delete | Marcos Ortiz | 07:44 |
| Re: debugging handle exhaustion and 15 min/ 5mil row delete | Marcos Ortiz | 13:22 |
| debugging handle exhaustion and 15 min/ 5mil row delete | Mark Stosberg | 13:37 |
| Re: debugging handle exhaustion and 15 min/ 5mil row delete | Kenneth Marshall | 13:42 |
| Re: debugging handle exhaustion and 15 min/ 5mil row delete | Mark Stosberg | 14:10 |
| Re: Planner issue on sorting joining of two tables with limit | Kevin Grittner | 15:27 |
| Re: Planner issue on sorting joining of two tables with limit | Tom Lane | 15:35 |
| Re: partioning tips? | Josh Berkus | 17:48 |
| Dell Perc HX00 RAID controllers: What's inside? | Craig James | 21:11 |
| Thread | Author | Time |
|---|---|---|
| 8K recordsize bad on ZFS? | Josh Berkus | 00:09 |
| Slow Bulk Delete | thilo | 11:39 |
| Re: Slow Bulk Delete | Andy Colson | 13:17 |
| Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this? 📎 | Karl Denninger | 20:35 |
| Re: 8K recordsize bad on ZFS? | Jignesh Shah | 21:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this? | Jesper Krogh | 06:53 |
| Re: 8K recordsize bad on ZFS? | Dimitri | 08:45 |
| Re: Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this? | Oleg Bartunov | 09:35 |
| Re: Dell Perc HX00 RAID controllers: What's inside? | Greg Smith | 21:20 |
| Re: Slow Bulk Delete | thilo | 21:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Dell Perc HX00 RAID controllers: What's inside? | Scott Marlowe | 02:39 |
| Re: 8K recordsize bad on ZFS? | Josh Berkus | 18:39 |
| Re: 8K recordsize bad on ZFS? | Ivan Voras | 19:13 |
| Re: 8K recordsize bad on ZFS? | Dimitri | 19:26 |
| Re: 8K recordsize bad on ZFS? | Josh Berkus | 19:30 |
| Re: 8K recordsize bad on ZFS? | Greg Stark | 20:01 |
| Re: 8K recordsize bad on ZFS? | Josh Berkus | 21:16 |
| Thread | Author | Time |
|---|---|---|
| Function scan/Index scan to nested loop | Carlo Stonebanks | 05:32 |
| Re: Function scan/Index scan to nested loop | Scott Marlowe | 07:07 |
| Re: Function scan/Index scan to nested loop | Craig Ringer | 07:14 |
| Performance issues when the number of records are around 10 Million | venu madhav | 08:47 |
| Re: Function scan/Index scan to nested loop | Carlo Stonebanks | 18:00 |
| Re: Performance issues when the number of records are around 10 Million | Jorge Montero | 21:47 |
| Re: Performance issues when the number of records are around 10 Million | Kevin Grittner | 21:50 |
| Re: Performance issues when the number of records are around 10 Million | Shrirang Chitnis | 21:52 |
| Thread | Author | Time |
|---|---|---|
| Re: 8K recordsize bad on ZFS? | Josh Berkus | 01:01 |
| Re: Performance issues when the number of records are around 10 Million | Josh Berkus | 01:04 |
| Re: Performance issues when the number of records are around 10 Million | venu madhav | 05:45 |
| Re: Performance issues when the number of records are around 10 Million | venu madhav | 06:42 |
| Re: Performance issues when the number of records are around 10 Million | venu madhav | 06:59 |
| Re: Performance issues when the number of records are around 10 Million | Kevin Grittner | 11:55 |
| Re: Performance issues when the number of records are around 10 Million | venu madhav | 12:14 |
| Re: Performance issues when the number of records are around 10 Million | Kevin Grittner | 13:56 |
| Re: Performance issues when the number of records are around 10 Million | Craig James | 14:08 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow Bulk Delete | Bob Lunney | 03:13 |
| Re: Performance issues when the number of records are around 10 Million | venu madhav | 04:41 |
| Re: Performance issues when the number of records are around 10 Million | Kevin Grittner | 13:56 |
| Thread | Author | Time |
|---|---|---|
| old server, new server, same performance | Piotr Legiecki | 08:24 |
| old server, new server, same performance | Piotr Legiecki | 13:14 |
| Re: old server, new server, same performance | Thom Brown | 14:03 |
| Re: old server, new server, same performance | Kevin Grittner | 14:04 |
| Re: old server, new server, same performance | Scott Marlowe | 14:07 |
| Re: old server, new server, same performance | Yeb Havinga | 14:13 |
| Re: old server, new server, same performance | Scott Marlowe | 22:52 |
| Thread | Author | Time |
|---|---|---|
| Re: old server, new server, same performance | Scott Carey | 00:46 |
| Re: old server, new server, same performance | Sarwani Dwinanto | 02:26 |
| Benchmark with FreeBSD 8.0 and pgbench | joao.pinheiro | 16:42 |
| Re: Benchmark with FreeBSD 8.0 and pgbench | Josh Berkus | 19:48 |
| Re: Benchmark with FreeBSD 8.0 and pgbench | joao.pinheiro | 20:41 |
| Thread | Author | Time |
|---|---|---|
| Re: Planner issue on sorting joining of two tables with limit | Robert Haas | 12:21 |
| Thread | Author | Time |
|---|---|---|
| pg_dump and pg_restore | Jayadevan M | 05:04 |
| Re: Benchmark with FreeBSD 8.0 and pgbench | Віталій Тимчишин | 07:06 |
| Re: old server, new server, same performance | Piotr Legiecki | 08:06 |
| Re: old server, new server, same performance | Scott Marlowe | 08:10 |
| Re: old server, new server, same performance | Scott Marlowe | 08:52 |
| Re: old server, new server, same performance | Scott Marlowe | 08:53 |
| Re: old server, new server, same performance | Piotr Legiecki | 09:52 |
| Re: Slow Bulk Delete | Pierre C | 10:10 |
| Re: old server, new server, same performance | Scott Marlowe | 10:25 |
| Re: Slow Bulk Delete | Jon Nelson | 11:54 |
| Re: Slow Bulk Delete | Віталій Тимчишин | 12:07 |
| Re: Slow Bulk Delete | Grzegorz Jaśkiewicz | 12:15 |
| Re: Slow Bulk Delete | A. Kretschmer | 12:28 |
| Re: Slow Bulk Delete | Jon Nelson | 12:28 |
| Re: Slow Bulk Delete | Grzegorz Jaśkiewicz | 12:33 |
| Re: Slow Bulk Delete | Jon Nelson | 12:35 |
| Thread | Author | Time |
|---|---|---|
| Does FILTER in SEQSCAN short-circuit AND? | Carlo Stonebanks | 22:28 |
| Thread | Author | Time |
|---|---|---|
| merge join killing performance | Scott Marlowe | 00:17 |
| Re: merge join killing performance | Matthew Wakeling | 03:00 |
| Re: merge join killing performance | Scott Marlowe | 03:06 |
| Re: merge join killing performance | Tom Lane | 16:53 |
| Re: merge join killing performance | Scott Marlowe | 17:08 |
| Re: merge join killing performance | Scott Marlowe | 20:27 |
| Re: merge join killing performance | Scott Marlowe | 20:47 |
| Thread | Author | Time |
|---|---|---|
| Re: prepared query performs much worse than regular query | Rosser Schwarz | 00:30 |
| Re: prepared query performs much worse than regular query | Matthew Wakeling | 03:26 |
| Re: Optimize date query for large child tables: GiST or GIN? | David Jarvis | 08:11 |
| Re: pg_dump and pg_restore | Robert Haas | 11:29 |
| Re: Optimize date query for large child tables: GiST or GIN? | David Jarvis | 17:54 |
| Re: pg_dump and pg_restore | Peter Koczan | 19:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Optimize date query for large child tables: GiST or GIN? | David Jarvis | 22:55 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_dump and pg_restore | Jayadevan M | 03:45 |
| Re: shared_buffers advice | Konrad Garus | 11:25 |
| [SPAM] Re: shared_buffers advice | Ben Chobot | 15:27 |
| Certain query eating up all free memory (out of memory error) | Łukasz Dejneka | 16:50 |
| Re: shared_buffers advice | Merlin Moncure | 18:25 |
| which hardware setup | Pedro Axelrud | 21:03 |