Mailing lists [pgsql-performance]

1 May 2010

• 03:08   Re: autovacuum strategy / parameters Alvaro Herrera
• 10:53   Re: Optimization idea Cédric Villemain
• 11:39   Re: autovacuum strategy / parameters Robert Haas
• 12:01   Re: Optimization idea Cédric Villemain
• 16:08   Re: autovacuum strategy / parameters Scott Marlowe
• 16:13   Re: autovacuum strategy / parameters Scott Marlowe
• 17:11   Re: autovacuum strategy / parameters Greg Smith
• 17:26   Re: autovacuum strategy / parameters Tom Lane
• 19:08   Re: autovacuum strategy / parameters Robert Haas
• 19:17   Re: autovacuum strategy / parameters Scott Marlowe
• 19:19   Re: autovacuum strategy / parameters Scott Marlowe
• 19:20   Re: autovacuum strategy / parameters Robert Haas

5 May 2010

• 20:25   partioning tips? Richard Yen
• 21:31   Re: partioning tips? Dave Crooke

6 May 2010

• 04:24   PgPool II configuration with PostgreSQL 8.4 Neha Mehta
• 07:41   Re: PgPool II configuration with PostgreSQL 8.4 Tatsuo Ishii
• 12:30   Re: PgPool II configuration with PostgreSQL 8.4 Marcos Ortiz
• 22:28   Re: PgPool II configuration with PostgreSQL 8.4 Rosser Schwarz

7 May 2010

• 13:38   debugging handle exhaustion and 15 min/ 5mil row delete Mark Stosberg
• 13:42   Re: debugging handle exhaustion and 15 min/ 5mil row delete Kenneth Marshall
• 13:44   Re: debugging handle exhaustion and 15 min/ 5mil row delete Marcos Ortiz
• 14:17   Re: debugging handle exhaustion and 15 min/ 5mil row delete Mark Stosberg
• 14:35   Re: Planner issue on sorting joining of two tables with limit Alexander Korotkov
• 14:35   Re: Planner issue on sorting joining of two tables with limit Alexander Korotkov
• 15:27   Re: Planner issue on sorting joining of two tables with limit Kevin Grittner
• 15:35   Re: Planner issue on sorting joining of two tables with limit Tom Lane
• 17:48   Re: partioning tips? Josh Berkus
• 19:23   Re: debugging handle exhaustion and 15 min/ 5mil row delete Marcos Ortiz
• 21:11   Dell Perc HX00 RAID controllers: What's inside? Craig James

8 May 2010

• 00:10   8K recordsize bad on ZFS? Josh Berkus
• 13:17   Re: Slow Bulk Delete Andy Colson
• 20:35   Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this? Karl Denninger

9 May 2010

• 06:54   Re: Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this? Jesper Krogh
• 08:45   Re: 8K recordsize bad on ZFS? Dimitri
• 09:36   Re: Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this? Oleg Bartunov
• 21:20   Re: Dell Perc HX00 RAID controllers: What's inside? Greg Smith

10 May 2010

• 02:39   Re: Dell Perc HX00 RAID controllers: What's inside? Scott Marlowe
• 18:39   Re: 8K recordsize bad on ZFS? Josh Berkus
• 19:14   Re: 8K recordsize bad on ZFS? Ivan Voras
• 19:26   Re: 8K recordsize bad on ZFS? Dimitri
• 19:30   Re: 8K recordsize bad on ZFS? Josh Berkus
• 20:01   Re: 8K recordsize bad on ZFS? Greg Stark
• 21:16   Re: 8K recordsize bad on ZFS? Josh Berkus

11 May 2010

• 05:42   Function scan/Index scan to nested loop Carlo Stonebanks
• 07:07   Re: Function scan/Index scan to nested loop Scott Marlowe
• 07:15   Re: Function scan/Index scan to nested loop Craig Ringer
• 18:14   Re: Function scan/Index scan to nested loop Carlo Stonebanks
• 21:30   Slow Bulk Delete thilo
• 21:30   Re: 8K recordsize bad on ZFS? Jignesh Shah
• 21:30   Re: Slow Bulk Delete thilo
• 21:30   Performance issues when the number of records are around 10 Million venu madhav
• 21:50   Re: Performance issues when the number of records are around 10 Million Kevin Grittner
• 21:58   Re: Performance issues when the number of records are around 10 Million Jorge Montero
• 22:37   Re: Performance issues when the number of records are around 10 Million Shrirang Chitnis

12 May 2010

• 01:02   Re: 8K recordsize bad on ZFS? Josh Berkus
• 01:05   Re: Performance issues when the number of records are around 10 Million Josh Berkus
• 11:55   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 Kevin Grittner
• 14:17   Re: Performance issues when the number of records are around 10 Million Craig James

13 May 2010

• 03:13   Re: Slow Bulk Delete Bob Lunney
• 13:56   Re: Performance issues when the number of records are around 10 Million Kevin Grittner

14 May 2010

• 13:54   old server, new server, same performance Piotr Legiecki
• 14:05   Re: old server, new server, same performance Kevin Grittner
• 14:08   Re: old server, new server, same performance Scott Marlowe
• 14:13   Re: old server, new server, same performance Yeb Havinga
• 20:42   Re: Performance issues when the number of records are around 10 Million venu madhav
• 20:42   Re: Performance issues when the number of records are around 10 Million venu madhav
• 20:42   Re: Performance issues when the number of records are around 10 Million venu madhav
• 20:42   Re: Performance issues when the number of records are around 10 Million venu madhav
• 20:42   Re: Performance issues when the number of records are around 10 Million venu madhav
• 20:42   old server, new server, same performance Piotr Legiecki
• 20:42   Re: old server, new server, same performance Thom Brown
• 22:52   Re: old server, new server, same performance Scott Marlowe

15 May 2010

• 00:47   Re: old server, new server, same performance Scott Carey
• 02:36   Re: old server, new server, same performance Sarwani Dwinanto
• 16:42   Benchmark with FreeBSD 8.0 and pgbench joao.pinheiro
• 19:48   Re: Benchmark with FreeBSD 8.0 and pgbench Josh Berkus
• 20:41   Re: Benchmark with FreeBSD 8.0 and pgbench joao.pinheiro

16 May 2010

• 12:21   Re: Planner issue on sorting joining of two tables with limit Robert Haas

17 May 2010

• 05:06   pg_dump and pg_restore Jayadevan M
• 07:06   Re: Benchmark with FreeBSD 8.0 and pgbench Віталій Тимчишин
• 08:06   Re: old server, new server, same performance Piotr Legiecki
• 08:11   Re: old server, new server, same performance Scott Marlowe
• 08:53   Re: old server, new server, same performance Scott Marlowe
• 08:53   Re: old server, new server, same performance Scott Marlowe
• 09:52   Re: old server, new server, same performance Piotr Legiecki
• 10:17   Re: Slow Bulk Delete Pierre C
• 10:25   Re: old server, new server, same performance Scott Marlowe
• 12:02   Re: Slow Bulk Delete Jon Nelson
• 12:15   Re: Slow Bulk Delete Віталій Тимчишин
• 12:16   Re: Slow Bulk Delete Grzegorz Jaśkiewicz
• 12:28   Re: Slow Bulk Delete A. Kretschmer
• 12:29   Re: Slow Bulk Delete Jon Nelson
• 12:33   Re: Slow Bulk Delete Grzegorz Jaśkiewicz
• 12:36   Re: Slow Bulk Delete Jon Nelson

19 May 2010

• 00:17   merge join killing performance Scott Marlowe
• 03:00   Re: merge join killing performance Matthew Wakeling
• 03:06   Re: merge join killing performance Scott Marlowe
• 16:53   Re: merge join killing performance Tom Lane
• 17:08   Re: merge join killing performance Scott Marlowe
• 20:27   Re: merge join killing performance Scott Marlowe
• 20:47   Re: merge join killing performance Scott Marlowe

20 May 2010

• 01:46   Re: merge join killing performance Matthew Wakeling
• 02:04   Re: merge join killing performance Scott Marlowe
• 02:06   Re: merge join killing performance Scott Marlowe
• 02:07   Re: merge join killing performance Scott Marlowe
• 05:06   Optimize date query for large child tables: GiST or GIN? David Jarvis
• 08:20   Re: Optimize date query for large child tables: GiST or GIN? Yeb Havinga
• 08:33   Re: Optimize date query for large child tables: GiST or GIN? Thom Brown
• 13:03   Re: Optimize date query for large child tables: GiST or GIN? Matthew Wakeling
• 13:57   Re: Optimize date query for large child tables: GiST or GIN? Tom Lane
• 14:28   Re: merge join killing performance Tom Lane
• 14:35   Re: merge join killing performance Scott Marlowe
• 15:43   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 18:37   Re: Optimize date query for large child tables: GiST or GIN? Thom Brown
• 18:59   Re: Optimize date query for large child tables: GiST or GIN? Thom Brown
• 19:02   Re: Optimize date query for large child tables: GiST or GIN? Tom Lane
• 19:22   Re: Optimize date query for large child tables: GiST or GIN? Thom Brown
• 19:22   Re: [BUGS] Query causing explosion of temp space with join involving partitioning Tom Lane
• 19:46   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 19:53   Re: Optimize date query for large child tables: GiST or GIN? Tom Lane
• 19:58   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 20:04   Re: Optimize date query for large child tables: GiST or GIN? Tom Lane
• 20:09   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 20:19   Re: Optimize date query for large child tables: GiST or GIN? Tom Lane
• 20:19   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 20:30   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 21:01   Re: Optimize date query for large child tables: GiST or GIN? Stephen Frost
• 21:08   Re: Optimize date query for large child tables: GiST or GIN? Yeb Havinga
• 21:19   Re: Optimize date query for large child tables: GiST or GIN? Stephen Frost
• 21:30   Re: Optimize date query for large child tables: GiST or GIN? Stephen Frost

21 May 2010

• 00:19   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 00:28   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 00:46   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 02:02   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 03:28   Re: Optimize date query for large child tables: GiST or GIN? Matthew Wakeling
• 04:12   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 08:38   Re: Optimize date query for large child tables: GiST or GIN? Yeb Havinga
• 08:45   Re: Optimize date query for large child tables: GiST or GIN? Yeb Havinga
• 12:15   Re: old server, new server, same performance Piotr Legiecki
• 15:08   Re: Optimize date query for large child tables: GiST or GIN? Matthew Wakeling
• 15:18   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 18:21   Re: Optimize date query for large child tables: GiST or GIN? Yeb Havinga
• 18:49   Re: Optimize date query for large child tables: GiST or GIN? Yeb Havinga
• 19:12   Re: Optimize date query for large child tables: GiST or GIN? Matthew Wakeling
• 19:18   Re: Optimize date query for large child tables: GiST or GIN? Stephen Frost
• 22:53   prepared query performs much worse than regular query Richard Yen

22 May 2010

• 00:30   Re: prepared query performs much worse than regular query Rosser Schwarz
• 03:27   Re: prepared query performs much worse than regular query Matthew Wakeling
• 08:11   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 11:29   Re: pg_dump and pg_restore Robert Haas
• 17:54   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 19:55   Re: pg_dump and pg_restore Peter Koczan

23 May 2010

• 22:55   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis

24 May 2010

• 03:45   Re: pg_dump and pg_restore Jayadevan M
• 11:26   Re: shared_buffers advice Konrad Garus
• 15:27   [SPAM] Re: shared_buffers advice Ben Chobot
• 18:26   Re: shared_buffers advice Merlin Moncure
• 21:03   which hardware setup Pedro Axelrud

25 May 2010

• 05:54   Random Page Cost and Planner David Jarvis
• 06:16   Certain query eating up all free memory (out of memory error) Łukasz Dejneka
• 06:22   Re: which hardware setup Jesper Krogh
• 06:37   Re: Certain query eating up all free memory (out of memory error) Łukasz Dejneka
• 06:41   Re: Random Page Cost and Planner David Jarvis
• 08:16   performance of temporary vs. regular tables Joachim Worringen
• 08:49   Re: performance of temporary vs. regular tables Grzegorz Jaśkiewicz
• 09:00   Re: performance of temporary vs. regular tables Joachim Worringen
• 09:16   Re: performance of temporary vs. regular tables Thom Brown
• 09:32   Re: performance of temporary vs. regular tables Joachim Worringen
• 09:38   Re: performance of temporary vs. regular tables Grzegorz Jaśkiewicz
• 09:58   Re: shared_buffers advice Konrad Garus
• 09:59   Query timing increased from 3s to 55s when used as a function instead of select Tyler Hildebrandt
• 10:01   Re: performance of temporary vs. regular tables Joachim Worringen
• 10:30   Re: Query timing increased from 3s to 55s when used as a function instead of select A. Kretschmer
• 10:42   Re: performance of temporary vs. regular tables Andres Freund
• 13:41   Re: Query timing increased from 3s to 55s when used as a function instead of select Tyler Hildebrandt
• 14:04   tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp) Juan Pablo Sandoval Rivera
• 14:27   Re: tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp) Joshua Tolley
• 14:55   Re: Query timing increased from 3s to 55s when used as a function instead of select Merlin Moncure
• 14:57   Re: Query timing increased from 3s to 55s when used as a function instead of select Merlin Moncure
• 16:19   Re: Query timing increased from 3s to 55s when used as a function instead of select Jorge Montero
• 17:07   Re: which hardware setup Pedro Axelrud
• 18:28   Re: prepared query performs much worse than regular query Scott Carey
• 18:29   Re: Random Page Cost and Planner Kevin Grittner
• 19:02   Re: prepared query performs much worse than regular query Joshua Tolley
• 21:03   Re: shared_buffers advice Merlin Moncure
• 23:27   Re: Random Page Cost and Planner David Jarvis

26 May 2010

• 00:24   Re: Random Page Cost and Planner Tom Lane
• 00:57   Re: Random Page Cost and Planner Rob Wultsch
• 03:50   Re: Random Page Cost and Planner David Jarvis
• 04:13   Re: Function scan/Index scan to nested loop Robert Haas
• 04:26   Re: Performance issues when the number of records are around 10 Million Robert Haas
• 06:13   Re: Random Page Cost and Planner David Jarvis
• 09:00   Re: Random Page Cost and Planner Alexey Klyukin
• 09:48   Re: shared_buffers advice Cédric Villemain
• 10:28   Re: Random Page Cost and Planner tv@fuzzy.cz
• 15:55   Re: Random Page Cost and Planner Kevin Grittner
• 16:03   Re: performance of temporary vs. regular tables Joachim Worringen
• 16:06   PostgreSQL Function Language Performance: C vs PL/PGSQL Eliot Gable
• 16:18   Re: PostgreSQL Function Language Performance: C vs PL/PGSQL Stephen Frost
• 16:29   Re: PostgreSQL Function Language Performance: C vs PL/PGSQL Eliot Gable
• 16:30   Re: Random Page Cost and Planner David Jarvis
• 16:32   Re: PostgreSQL Function Language Performance: C vs PL/PGSQL Stephen Frost
• 16:41   Re: PostgreSQL Function Language Performance: C vs PL/PGSQL Eliot Gable
• 16:47   Re: PostgreSQL Function Language Performance: C vs PL/PGSQL Stephen Frost
• 16:48   Re: performance of temporary vs. regular tables Grzegorz Jaśkiewicz
• 17:09   Re: PostgreSQL Function Language Performance: C vs PL/PGSQL Craig James
• 18:16   Re: Random Page Cost and Planner tv@fuzzy.cz
• 18:27   Re: Random Page Cost and Planner David Jarvis
• 18:55   Re: Random Page Cost and Planner David Jarvis
• 20:21   Re: Random Page Cost and Planner David Jarvis

27 May 2010

• 07:24   Re: shared_buffers advice Konrad Garus
• 07:43   Re: Random Page Cost and Planner David Jarvis
• 07:51   Re: shared_buffers advice Cédric Villemain
• 08:03   Re: Random Page Cost and Planner Cédric Villemain
• 09:00   Re: shared_buffers advice Konrad Garus
• 10:29   Re: shared_buffers advice Cédric Villemain
• 13:54   Query causing explosion of temp space with join involving partitioning Krzysztof Nienartowicz
• 13:54   Autovacuum in postgres. venu madhav
• 13:55   Re: Autovacuum in postgres. venu madhav
• 13:55   Query timing increased from 3s to 55s when used as function instead of select Tyler Hildebrandt
• 13:55   Certain query eating up all free memory (out of memory error) Łukasz Dejneka
• 13:55   Re: [BUGS] Query causing explosion of temp space with join involving partitioning Krzysztof Nienartowicz
• 13:55   About Tom Lane's Xeon CS test case 黄永卫
• 14:10   Re: About Tom Lane's Xeon CS test case Tom Lane
• 14:33   Re: Autovacuum in postgres. Bruce Momjian
• 15:07   Re: Autovacuum in postgres. Bruce Momjian
• 15:18   Re: shared_buffers advice Konrad Garus
• 15:25   Re: shared_buffers advice Cédric Villemain
• 15:34   Re: Query timing increased from 3s to 55s when used as function instead of select Craig Ringer
• 15:51   Re: shared_buffers advice Konrad Garus
• 15:56   Re: Random Page Cost and Planner David Jarvis
• 15:56   Re: Query timing increased from 3s to 55s when used as function instead of select Craig Ringer
• 16:10   Re: Autovacuum in postgres. alvherre
• 16:41   Re: [BUGS] Query causing explosion of temp space with join involving partitioning Tom Lane
• 18:22   Re: shared_buffers advice Cédric Villemain
• 18:29   Re: Random Page Cost and Planner Cédric Villemain
• 19:29   Does FILTER in SEQSCAN short-circuit AND? Carlo Stonebanks
• 20:27   Re: Does FILTER in SEQSCAN short-circuit AND? Kevin Grittner
• 21:21   Re: Does FILTER in SEQSCAN short-circuit AND? Craig James
• 21:26   Re: Does FILTER in SEQSCAN short-circuit AND? Thomas Kellerer
• 21:28   Re: Does FILTER in SEQSCAN short-circuit AND? Kevin Grittner
• 21:44   Re: Does FILTER in SEQSCAN short-circuit AND? Craig James
• 22:04   Re: Random Page Cost and Planner Bryan Hinton

28 May 2010

• 01:16   Re: merge join killing performance Tom Lane
• 01:24   hp hpsa vs cciss driver Mark Wong
• 02:46   Re: merge join killing performance Scott Marlowe
• 02:56   Re: merge join killing performance Tom Lane
• 03:29   Re: Random Page Cost and Planner David Jarvis
• 07:57   Re: shared_buffers advice Konrad Garus
• 08:13   Re: shared_buffers advice Cédric Villemain
• 11:04   Re: performance of temporary vs. regular tables Joachim Worringen
• 12:22   Re: PostgreSQL Function Language Performance: C vs PL/PGSQL Merlin Moncure
• 17:08   Re: performance of temporary vs. regular tables Rob Wultsch
• 18:27   Wildly inaccurate query plan Thom Brown
• 18:54   Re: Wildly inaccurate query plan Tom Lane
• 18:58   Re: shared_buffers advice Greg Smith
• 19:06   Re: Wildly inaccurate query plan Thom Brown
• 19:49   Zeus IOPS Scott Marlowe
• 20:31   Re: shared_buffers advice Merlin Moncure
• 21:03   Re: shared_buffers advice Greg Smith
• 21:11   Re: shared_buffers advice Scott Marlowe
• 21:14   Re: shared_buffers advice Dave Crooke
• 21:16   Re: shared_buffers advice Merlin Moncure

29 May 2010

• 17:01   Re: Wildly inaccurate query plan Kevin Grittner
• 21:19   Re: Strange workaround for slow query Sander Verhagen

30 May 2010

• 17:41   planner costs in "warm cache" tests Jesper Krogh
• 18:35   Re: planner costs in "warm cache" tests Tom Lane

31 May 2010

• 13:15   Re: Zeus IOPS Brad Nicholson
• 13:20   Re: Zeus IOPS Scott Marlowe
• 18:48   Re: planner costs in "warm cache" tests Jesper Krogh
• 19:55   Re: planner costs in "warm cache" tests Tom Lane