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: 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 |
Thread | Author | Time |
---|---|---|
Re: Random Page Cost and Planner | Tom Lane | 00:24 |
Re: Random Page Cost and Planner | Rob Wultsch | 00:56 |
Re: Random Page Cost and Planner | David Jarvis | 03:50 |
Re: Function scan/Index scan to nested loop | Robert Haas | 04:13 |
Re: Performance issues when the number of records are around 10 Million | Robert Haas | 04:25 |
Re: Random Page Cost and Planner | David Jarvis | 06:13 |