Mailing lists [pgsql-performance]

1 June 2010

• 07:15   Re: planner costs in "warm cache" tests Scott Carey
• 07:32   Re: Zeus IOPS Mindaugas Riauba
• 09:55   Re: Optimize date query for large child tables: GiST or GIN? Matthew Wakeling
• 12:47   Re: PostgreSQL Function Language Performance: C vs PL/PGSQL Matthew Wakeling
• 12:55   Re: PostgreSQL Function Language Performance: C vs PL/PGSQL Stephen Frost
• 12:59   Re: PostgreSQL Function Language Performance: C vs PL/PGSQL Matthew Wakeling
• 13:17   Re: Zeus IOPS Brad Nicholson
• 14:05   Re: planner costs in "warm cache" tests Tom Lane
• 16:28   Re: PostgreSQL Function Language Performance: C vs PL/PGSQL Merlin Moncure
• 17:14   Re: Optimize date query for large child tables: GiST or GIN? Alvaro Herrera
• 19:00   Re: Optimize date query for large child tables: GiST or GIN? Alvaro Herrera

2 June 2010

• 03:06   File system choice for Red Hat systems Mark Kirkwood
• 03:26   Re: File system choice for Red Hat systems Tom Lane
• 03:41   Re: File system choice for Red Hat systems Mark Kirkwood
• 05:18   Re: File system choice for Red Hat systems Devrim GÜNDÜZ
• 05:31   Re: File system choice for Red Hat systems Mark Kirkwood
• 06:17   Re: File system choice for Red Hat systems Greg Smith
• 10:10   Re: performance of temporary vs. regular tables Pierre C
• 11:19   Overusing 1 CPU Mozzi
• 11:24   Re: Overusing 1 CPU Matthew Wakeling
• 11:42   Re: Overusing 1 CPU Mozzi
• 11:59   Re: Overusing 1 CPU A. Kretschmer
• 11:59   Re: Overusing 1 CPU Stephen Frost
• 12:54   Re: performance of temporary vs. regular tables Joachim Worringen
• 12:56   Re: Overusing 1 CPU J. Roeleveld
• 14:52   Re: File system choice for Red Hat systems Alan Hodgson
• 15:29   Re: File system choice for Red Hat systems Wales Wang
• 19:51   Re: Autovacuum in postgres. venu madhav
• 19:51   how to force hashaggregate plan? Slava Moudry
• 19:51   Re: [BUGS] Query causing explosion of temp space with join involving partitioning Krzysztof Nienartowicz
• 19:51   答复: [PERFORM] About Tom Lane's Xeon CS test case  黄永卫
• 19:51   How to insert a bulk of data with unique-violations very fast Torsten Zühlsdorff
• 19:52   PgAdmin iii - Explain. Jeres Caldeira Gomes
• 19:52   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 19:52   Re: Optimize date query for large child tables: GiST or GIN? David Jarvis
• 19:53   Re: requested shared memory size overflows size_t Tom Wilcox
• 20:00   Re: How to insert a bulk of data with unique-violations very fast Scott Marlowe
• 20:14   Re: Autovacuum in postgres. Scott Marlowe
• 20:53   Re: requested shared memory size overflows size_t Kevin Grittner
• 21:00   Re: requested shared memory size overflows size_t Stephen Frost
• 21:26   Re: Certain query eating up all free memory (out of memory error) Robert Haas
• 22:13   Re: File system choice for Red Hat systems Mark Kirkwood
• 22:17   SELECT ignoring index even though ORDER BY and LIMIT present Jori Jovanovich
• 22:26   Re: SELECT ignoring index even though ORDER BY and LIMIT present Kevin Grittner
• 22:31   Re: SELECT ignoring index even though ORDER BY and LIMIT present Szymon Guz
• 22:42   Re: SELECT ignoring index even though ORDER BY and LIMIT present Tom Lane
• 23:36   Weird XFS WAL problem Craig James
• 23:41   Re: Weird XFS WAL problem Mark Kirkwood

3 June 2010

• 01:27   Re: requested shared memory size overflows size_t Bob Lunney
• 01:49   Re: SELECT ignoring index even though ORDER BY and LIMIT present Bob Lunney
• 02:27   Re: requested shared memory size overflows size_t Joshua Tolley
• 10:18   Re: SELECT ignoring index even though ORDER BY and LIMIT present Matthew Wakeling
• 13:01   Re: Weird XFS WAL problem Merlin Moncure
• 15:32   Re: SELECT ignoring index even though ORDER BY and LIMIT present Jori Jovanovich
• 16:52   Re: Weird XFS WAL problem Greg Smith
• 17:06   Re: Weird XFS WAL problem Craig James
• 17:14   Re: Weird XFS WAL problem Matthew Wakeling
• 17:31   Re: Weird XFS WAL problem Kevin Grittner
• 17:48   slow query performance Anj Adu
• 18:18   Re: Weird XFS WAL problem Greg Smith
• 18:27   Re: Weird XFS WAL problem Greg Smith
• 18:40   Re: Weird XFS WAL problem Kevin Grittner
• 18:43   Re: slow query performance Andy Colson
• 19:16   Re: Weird XFS WAL problem Scott Marlowe
• 19:17   Re: Weird XFS WAL problem Kevin Grittner
• 19:31   Re: Weird XFS WAL problem Greg Smith
• 19:44   Re: Weird XFS WAL problem Scott Marlowe
• 20:01   Re: Weird XFS WAL problem Kevin Grittner
• 20:09   Re: How to insert a bulk of data with unique-violations very fast Scott Marlowe
• 20:37   Re: slow query performance Anj Adu
• 23:04   Re: How to insert a bulk of data with unique-violations very fast Cédric Villemain

4 June 2010

• 01:45   slow query Anj Adu
• 04:41   Performance tuning for postgres Yogesh Naik
• 08:13   Re: slow query tv@fuzzy.cz
• 09:00   Re: slow query Matthew Wakeling
• 09:27   Re: Weird XFS WAL problem Matthew Wakeling
• 12:27   How filesystems matter with PostgreSQL Jon Schewe
• 12:39   Re: How filesystems matter with PostgreSQL J. Roeleveld
• 13:04   Re: How filesystems matter with PostgreSQL Andres Freund
• 13:39   performance regression with Linux 2.6.33 and glibc 2.12 Marc Cousin
• 13:59   Re: performance regression with Linux 2.6.33 and glibc 2.12 Tom Lane
• 14:00   Re: Performance tuning for postgres Kevin Grittner
• 14:25   Re: How filesystems matter with PostgreSQL Tom Lane
• 14:33   Re: How filesystems matter with PostgreSQL Andres Freund
• 14:45   Re: Performance tuning for postgres Michael Gould
• 15:06   Re: Weird XFS WAL problem Bruce Momjian
• 15:16   Re: Weird XFS WAL problem Kevin Grittner
• 15:18   Re: Weird XFS WAL problem Bruce Momjian
• 15:24   Re: Weird XFS WAL problem Kevin Grittner
• 15:25   Re: performance regression with Linux 2.6.33 and glibc 2.12 Andres Freund
• 15:29   Re: performance regression with Linux 2.6.33 and glibc 2.12 Marc Cousin
• 15:30   Re: Weird XFS WAL problem Bruce Momjian
• 15:36   Re: Weird XFS WAL problem Kevin Grittner
• 15:42   Re: Weird XFS WAL problem Bruce Momjian
• 17:25   Re: slow query Anj Adu
• 17:41   Re: slow query Anj Adu
• 18:01   Re: slow query Anj Adu
• 18:17   Re: Performance tuning for postgres Bryan Hinton
• 18:20   Re: How filesystems matter with PostgreSQL Bryan Hinton
• 18:21   Re: slow query Anj Adu
• 18:23   Re: How filesystems matter with PostgreSQL Jon Schewe
• 18:26   Re: How filesystems matter with PostgreSQL Jon Schewe
• 18:44   Re: How filesystems matter with PostgreSQL Bryan Hinton
• 18:44   Re: How filesystems matter with PostgreSQL Jon Schewe
• 18:47   Re: How filesystems matter with PostgreSQL Andres Freund
• 18:49   Re: How filesystems matter with PostgreSQL Jon Schewe

5 June 2010

• 01:29   Re: planner costs in "warm cache" tests Robert Haas
• 01:40   Re: how to force hashaggregate plan? Robert Haas
• 01:43   Re: PgAdmin iii - Explain. Robert Haas
• 09:02   Re: slow query hubert depesz lubaczewski
• 09:38   Re: slow query Scott Marlowe
• 14:02   Re: slow query Anj Adu
• 21:25   Re: slow query Scott Marlowe
• 22:37   Re: How filesystems matter with PostgreSQL Greg Smith
• 22:41   Re: How filesystems matter with PostgreSQL Jon Schewe
• 22:50   Re: Weird XFS WAL problem Greg Smith
• 22:53   Re: How filesystems matter with PostgreSQL Greg Smith
• 23:04   Re: How filesystems matter with PostgreSQL Jon Schewe
• 23:54   Re: How filesystems matter with PostgreSQL Scott Marlowe
• 23:59   Re: How filesystems matter with PostgreSQL Jon Schewe

6 June 2010

• 00:02   Re: How filesystems matter with PostgreSQL Scott Marlowe
• 00:07   Re: How filesystems matter with PostgreSQL Jon Schewe
• 03:34   Re: How filesystems matter with PostgreSQL Scott Marlowe
• 06:51   Re: How filesystems matter with PostgreSQL Ron Mayer
• 07:48   Re: How filesystems matter with PostgreSQL Craig Ringer
• 12:45   Re: How to insert a bulk of data with unique-violations very fast Andy Colson
• 13:15   Re: How to insert a bulk of data with unique-violations very fast Torsten Zühlsdorff
• 13:15   Re: How to insert a bulk of data with unique-violations very fast Torsten Zühlsdorff
• 17:47   Re: How to insert a bulk of data with unique-violations very fast Scott Marlowe
• 22:42   Re: How to insert a bulk of data with unique-violations very fast Pierre C
• 22:44   Re: performance of temporary vs. regular tables Pierre C

7 June 2010

• 13:45   Re: How to insert a bulk of data with unique-violations very fast Torsten Zühlsdorff
• 16:52   Re: How to insert a bulk of data with unique-violations very fast Pierre C

9 June 2010

• 07:46   Re: How to insert a bulk of data with unique-violations very fast Torsten Zühlsdorff
• 10:51   Re: How to insert a bulk of data with unique-violations very fast Pierre C
• 10:55   Large (almost 50%!) performance drop after upgrading to 8.4.4? Max Williams
• 11:35   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Pierre C
• 19:59   Re: No hash join across partitioned tables? Robert Haas
• 20:11   Re: No hash join across partitioned tables? Tom Lane

10 June 2010

• 01:50   Re: requested shared memory size overflows size_t Robert Haas
• 01:51   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Robert Haas
• 02:12   Re: slow query performance Robert Haas
• 02:55   Re: slow query performance Tom Lane
• 03:17   Re: slow query performance Anj Adu
• 08:16   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Max Williams
• 08:30   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Devrim GÜNDÜZ
• 08:48   Autovaccum settings while Bulk Loading data Ambarish Bhattacharya
• 09:01   Re: Autovaccum settings while Bulk Loading data Heikki Linnakangas
• 10:16   query hangs AI Rumman
• 10:18   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Max Williams
• 11:26   Re: query hangs Szymon Guz
• 11:36   Re: query hangs AI Rumman
• 11:44   Re: query hangs Szymon Guz
• 12:28   Re: query hangs Kevin Grittner
• 12:35   Re: query hangs AI Rumman
• 12:56   Re: query hangs Amit Khandekar
• 13:17   Re: query hangs AI Rumman
• 13:28   Re: slow query performance Robert Haas
• 14:11   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Tom Lane
• 14:41   Re: requested shared memory size overflows size_t Bob Lunney
• 15:07   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Max Williams
• 15:16   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Kevin Grittner
• 15:21   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Tom Lane
• 15:27   Re: Autovaccum settings while Bulk Loading data Heikki Linnakangas
• 15:32   Re: slow query performance Anj Adu
• 15:38   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Max Williams
• 15:46   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Tom Lane
• 16:35   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Alvaro Herrera
• 16:42   Re: slow query performance Robert Haas
• 16:44   Re: Performance tuning for postgres Robert Haas
• 16:59   Re: slow query performance Anj Adu
• 17:50   Need to increase performance of a query Anne Rosset
• 18:13   Re: Need to increase performance of a query Jesper Krogh
• 18:34   Re: Need to increase performance of a query hubert depesz lubaczewski
• 18:36   Re: Need to increase performance of a query Anne Rosset
• 19:34   Re: Need to increase performance of a query Anne Rosset
• 19:37   Re: Need to increase performance of a query Kenneth Marshall
• 19:39   Re: Need to increase performance of a query Jochen Erwied
• 19:41   Re: Need to increase performance of a query Jochen Erwied
• 19:42   Re: Need to increase performance of a query Anne Rosset
• 19:45   Re: Need to increase performance of a query Anne Rosset
• 19:47   Re: Need to increase performance of a query Craig James
• 19:57   Re: Need to increase performance of a query Anne Rosset
• 19:57   Re: Need to increase performance of a query Heikki Linnakangas
• 20:08   Re: Need to increase performance of a query Anne Rosset
• 20:10   Re: Need to increase performance of a query Joe Conway
• 20:13   Re: Need to increase performance of a query Joe Conway
• 20:16   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Greg Smith
• 20:21   Re: Need to increase performance of a query Anne Rosset
• 21:00   Re: Need to increase performance of a query Heikki Linnakangas
• 21:06   Re: Need to increase performance of a query Joe Conway
• 21:20   Re: Need to increase performance of a query Anne Rosset

11 June 2010

• 00:48   Re: Analysis Function David Jarvis
• 00:49   Re: slow query performance Robert Haas
• 02:11   Re: Analysis Function Andy Colson
• 02:54   Re: slow query performance Anj Adu
• 02:56   Re: Analysis Function David Jarvis
• 05:10   Re: query hangs Amit Khandekar
• 06:25   Re: requested shared memory size overflows size_t Bob Lunney
• 08:26   Re: Analysis Function David Jarvis
• 08:58   Re: Analysis Function Tim Landscheidt
• 09:18   Re: Analysis Function David Jarvis
• 09:42   Re: Analysis Function Heikki Linnakangas
• 09:56   Query about index usage Jayadevan M
• 11:19   Re: Analysis Function Tim Landscheidt
• 12:44   Re: slow query performance Kenneth Marshall
• 13:23   Re: slow query performance Anj Adu
• 13:28   Re: slow query performance Kenneth Marshall
• 13:49   Re: slow query performance Matthew Wakeling
• 15:25   Re: Query about index usage Kevin Grittner
• 15:32   Re: Query about index usage Greg Smith
• 15:58   O/T: performance tuning cars Dave Crooke
• 16:50   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? John Reeve
• 17:10   Re: Analysis Function David Jarvis
• 18:17   Re: Analysis Function David Jarvis
• 18:50   Re: Query about index usage Bob Lunney
• 18:54   Re: Analysis Function Tim Landscheidt
• 20:21   Re: Analysis Function Tom Lane
• 20:31   Re: Analysis Function David Jarvis
• 20:38   Re: Analysis Function David Jarvis

12 June 2010

• 12:10   ~400 TPS - good or bad? Szymon Kosok
• 12:37   Re: ~400 TPS - good or bad? Szymon Kosok
• 13:39   Re: ~400 TPS - good or bad? Merlin Moncure
• 20:46   Re: ~400 TPS - good or bad? Greg Smith

13 June 2010

• 06:03   Re: Analysis Function Heikki Linnakangas
• 07:38   Re: Analysis Function David Jarvis
• 10:08   Re: Analysis Function Magnus Hagander
• 10:45   Re: query hangs AI Rumman
• 13:25   out of memory AI Rumman
• 14:00   Re: out of memory Anj Adu
• 15:34   Re: Analysis Function Tom Lane
• 15:42   Re: Analysis Function Tom Lane
• 15:49   Re: Analysis Function Magnus Hagander
• 15:58   Re: Analysis Function Tom Lane
• 19:19   Re: Analysis Function David Jarvis

14 June 2010

• 02:10   Re: out of memory Kenichiro Tanaka
• 03:41   Re: Query about index usage Jayadevan M
• 09:01   Re: Analysis Function Magnus Hagander
• 09:03   Re: Analysis Function Magnus Hagander
• 10:41   query tuning help AI Rumman
• 11:10   Re: Analysis Function David Jarvis
• 12:50   Dead lock Elias Ghanem
• 12:54   Re: Dead lock Tom Molesworth
• 13:50   Re: query tuning help Andy Colson
• 13:59   Re: Analysis Function Tom Lane
• 13:59   Re: Dead lock Andy Colson
• 15:00   Re: query hangs Kevin Grittner
• 15:37   Fwd: Dead lock Elias Ghanem
• 15:58   Re: Fwd: Dead lock Dave Crooke
• 18:28   RE: [PERFORM] Dbt2 with postgres issues on CentOS-5.3‏ MUHAMMAD ASIF
• 20:16   Re: query hangs Scott Marlowe
• 20:44   Re: Fwd: Dead lock Merlin Moncure
• 22:46   Re: requested shared memory size overflows size_t Tom Wilcox
• 22:49   Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Lacey Powers
• 23:08   Re: requested shared memory size overflows size_t Robert Haas

15 June 2010

• 00:27   Re: requested shared memory size overflows size_t Dave Crooke
• 00:41   Re: requested shared memory size overflows size_t Tom Wilcox
• 00:56   Re: requested shared memory size overflows size_t Dave Crooke
• 01:12   Re: requested shared memory size overflows size_t Tom Wilcox
• 02:07   Re: requested shared memory size overflows size_t Greg Smith
• 03:21   B-Heaps Eliot Gable
• 03:27   Re: requested shared memory size overflows size_t Scott Carey
• 03:49   Re: requested shared memory size overflows size_t Scott Carey
• 03:57   Re: requested shared memory size overflows size_t Tom Lane
• 06:10   Re: B-Heaps Heikki Linnakangas
• 06:41   Re: B-Heaps Greg Smith
• 06:49   Re: B-Heaps A. Kretschmer
• 12:23   Re: B-Heaps Matthew Wakeling
• 15:48   Re: PostgreSQL as a local in-memory cache Chris Browne
• 17:02   Re: PostgreSQL as a local in-memory cache Steve Wampler
• 17:12   Re: PostgreSQL as a local in-memory cache Craig James
• 17:18   Re: PostgreSQL as a local in-memory cache jgardner@jonathangardner.net
• 18:18   Re: PostgreSQL as a local in-memory cache Chris Browne
• 19:33   Re: B-Heaps Yeb Havinga
• 23:10   Re: PostgreSQL as a local in-memory cache Jaime Casanova
• 23:18   Re: PostgreSQL as a local in-memory cache Josh Berkus

16 June 2010

• 06:36   Re: Analysis Function Magnus Hagander
• 07:18   Re: PostgreSQL as a local in-memory cache jgardner@jonathangardner.net
• 07:48   Re: PostgreSQL as a local in-memory cache Mark Kirkwood
• 07:59   Re: PostgreSQL as a local in-memory cache Pierre C
• 08:01   Re: PostgreSQL as a local in-memory cache Pierre C
• 08:27   Re: PostgreSQL as a local in-memory cache Greg Smith
• 08:48   Re: Analysis Function David Jarvis
• 18:30   Re: PostgreSQL as a local in-memory cache Pierre C
• 18:33   Re: PostgreSQL as a local in-memory cache Alvaro Herrera
• 19:00   Re: PostgreSQL as a local in-memory cache Josh Berkus
• 19:13   Confirm calculus Juan Pablo Sandoval Rivera
• 19:13   Confirm calculus Juan Pablo Sandoval Rivera
• 19:22   Re: PostgreSQL as a local in-memory cache Jonathan Gardner
• 19:25   Re: PostgreSQL as a local in-memory cache Jonathan Gardner
• 19:25   Re: PostgreSQL as a local in-memory cache Jonathan Gardner
• 19:26   Re: Confirm calculus Kevin Grittner
• 19:33   Re: PostgreSQL as a local in-memory cache Balkrishna Sharma
• 19:34   Re: Confirm calculus Scott Marlowe
• 19:37   Re: PostgreSQL as a local in-memory cache Jonathan Gardner
• 19:43   Re: PostgreSQL as a local in-memory cache Craig James
• 20:42   Re: PostgreSQL as a local in-memory cache Pierre C
• 20:46   Re: Analysis Function Tom Lane
• 20:54   Parallel queries for a web-application |performance testing Balkrishna Sharma
• 20:54   Re: requested shared memory size overflows size_t Alvaro Herrera
• 20:55   PostgreSQL as a local in-memory cache jgardner@jonathangardner.net
• 20:56   Re: requested shared memory size overflows size_t Tom Wilcox
• 21:19   Re: Parallel queries for a web-application |performance testing Kevin Grittner

17 June 2010

• 03:48   Re: PostgreSQL as a local in-memory cache jgardner@jonathangardner.net
• 08:20   Query slow after analyse on postgresql 8.2 Kaufhold, Christian (LFD)
• 09:00   Re: Parallel queries for a web-application |performance testing Dimitri Fontaine
• 09:41   Re: Parallel queries for a web-application |performance testing Matthew Wakeling
• 11:13   Re: Parallel queries for a web-application |performance testing Pierre C
• 11:32   Re: Parallel queries for a web-application |performance testing Dimitri Fontaine
• 14:59   Re: Query slow after analyse on postgresql 8.2 Tom Lane
• 15:30   Re: Query slow after analyse on postgresql 8.2 Kaufhold, Christian (LFD)
• 17:29   Re: PostgreSQL as a local in-memory cache Josh Berkus
• 18:45   Re: PostgreSQL as a local in-memory cache Pierre C
• 19:01   Re: PostgreSQL as a local in-memory cache Dimitri Fontaine
• 19:38   Re: PostgreSQL as a local in-memory cache Tom Lane
• 19:59   Re: PostgreSQL as a local in-memory cache Greg Smith
• 20:13   Re: PostgreSQL as a local in-memory cache Pierre C
• 21:42   Re: requested shared memory size overflows size_t Greg Smith
• 22:37   Add slowdown after conversion to UTF8 Brant Fitzsimmons
• 23:01   Re: PostgreSQL as a local in-memory cache Josh Berkus
• 23:17   Re: Add slowdown after conversion to UTF8 Tom Lane
• 23:25   Re: PostgreSQL as a local in-memory cache Tom Lane
• 23:46   Re: requested shared memory size overflows size_t Tom Wilcox

18 June 2010

• 01:40   wal_synch_method = open_sync safe on RHEL 5.5? Mark Kirkwood
• 03:29   Re: wal_synch_method = open_sync safe on RHEL 5.5? Greg Smith
• 03:57   Re: wal_synch_method = open_sync safe on RHEL 5.5? Mark Mielke
• 04:09   Re: Add slowdown after conversion to UTF8 Peter Eisentraut
• 04:20   Re: wal_synch_method = open_sync safe on RHEL 5.5? Mark Kirkwood
• 06:03   Re: wal_synch_method = open_sync safe on RHEL 5.5? Greg Smith
• 09:15   Re: PostgreSQL as a local in-memory cache Matthew Wakeling
• 09:42   Re: PostgreSQL as a local in-memory cache Pierre C
• 11:54   Re: B-Heaps Robert Haas
• 12:48   Re: requested shared memory size overflows size_t Kenneth Marshall
• 16:03   HashAggregate slower than sort? Jatinder Sangha
• 16:34   Re: B-Heaps Matthew Wakeling
• 17:53   Re: B-Heaps Greg Smith
• 17:59   Re: HashAggregate slower than sort? Kevin Grittner
• 18:12   Re: requested shared memory size overflows size_t Greg Smith
• 18:30   Re: B-Heaps Yeb Havinga
• 18:44   Re: B-Heaps Kevin Grittner
• 19:41   Re: B-Heaps Tom Lane
• 20:18   Re: B-Heaps Yeb Havinga
• 20:55   Re: PostgreSQL as a local in-memory cache Josh Berkus
• 20:56   Re: PostgreSQL as a local in-memory cache Josh Berkus

19 June 2010

• 02:59   Re: requested shared memory size overflows size_t Scott Carey
• 12:08   Re: B-Heaps Robert Haas

20 June 2010

• 08:55   join vs exists AI Rumman
• 11:18   Obtaining the exact size of the database. venu madhav
• 11:18   HashAggregate slower than sort? Jatinder Sangha
• 11:18   Slow function in queries SELECT clause. Davor J.
• 11:23   Re: Slow function in queries SELECT clause. Szymon Guz
• 12:48   Re: Slow function in queries SELECT clause. Davor J.
• 14:22   Re: Obtaining the exact size of the database. Dave Crooke
• 15:02   Re: join vs exists Kevin Grittner
• 15:21   Re: Slow function in queries SELECT clause. Tom Lane
• 15:34   Re: Obtaining the exact size of the database. Tom Lane
• 17:44   Aggressive autovacuuming ? Jesper Krogh
• 19:57   Re: B-Heaps Greg Smith
• 20:04   Re: Obtaining the exact size of the database. Greg Smith
• 20:13   Re: Aggressive autovacuuming ? Scott Marlowe
• 20:31   Re: Obtaining the exact size of the database. Scott Marlowe

21 June 2010

• 09:59   Re: HashAggregate slower than sort? Jatinder Sangha
• 13:54   Re: HashAggregate slower than sort? Kevin Grittner
• 14:42   Low perfomance SUM and Group by large databse Sergio Charpinel Jr.
• 14:52   Re: Slow function in queries SELECT clause. Davor J.
• 16:37   Re: Aggressive autovacuuming ? Alvaro Herrera
• 17:01   Re: Aggressive autovacuuming ? Kevin Grittner
• 18:02   Re: mysql to postgresql, performance questions Thom Brown
• 18:08   Re: mysql to postgresql, performance questions Scott Marlowe
• 22:07   Re: Low perfomance SUM and Group by large databse Craig Ringer
• 22:15   Re: PostgreSQL as a local in-memory cache Robert Haas

22 June 2010

• 09:31   raid10 write performance Grzegorz Jaśkiewicz
• 09:45   Re: Low perfomance SUM and Group by large databse Russell Smith
• 13:56   Re: raid10 write performance Justin Graf
• 14:40   Re: raid10 write performance Greg Smith
• 14:50   Re: raid10 write performance Karl Denninger
• 16:01   Re: raid10 write performance Dave Crooke
• 17:29   Re: raid10 write performance Scott Carey
• 17:30   ALTER Table and CLUSTER does adding a new column rewrite clustered? (8.4.3) Scott Carey
• 22:24   slow index lookup Anj Adu
• 23:44   Re: slow index lookup Alvaro Herrera

23 June 2010

• 01:00   Re: slow index lookup Anj Adu
• 01:11   Re: slow index lookup Joshua D. Drake
• 01:21   Re: slow index lookup Anj Adu
• 02:02   Re: slow index lookup Tom Lane
• 03:05   Re: slow index lookup Anj Adu
• 04:17   Re: Query about index usage Jayadevan M
• 06:06   Re: Query about index usage Greg Smith
• 06:16   Re: Query about index usage Jayadevan M
• 08:10   Re: slow index lookup Joshua D. Drake
• 10:07   Re: raid10 write performance Ivan Voras
• 11:40   Re: Low perfomance SUM and Group by large databse Sergio Charpinel Jr.
• 12:00   Re: raid10 write performance Florian Weimer
• 12:25   Re: raid10 write performance Ivan Voras
• 12:46   Re: raid10 write performance Matthew Wakeling
• 12:54   Re: raid10 write performance Scott Marlowe
• 12:56   Re: raid10 write performance Scott Marlowe
• 14:54   Re: cpu bound postgresql setup. Rajesh Kumar Mallah
• 15:29   Re: cpu bound postgresql setup. Kevin Grittner
• 16:59   Re: slow index lookup Anj Adu
• 17:08   Re: slow index lookup Kevin Grittner
• 17:30   Re: cpu bound postgresql setup. Firstly many thanks for responding. I am concerned because the load averages have increased and users complaining of slowness. I do not change settings frequenly. I was curious if there is any half dead component in th Rajesh Kumar Mallah
• 17:43   Re: cpu bound postgresql setup. Kevin Grittner
• 17:58   Re: Aggressive autovacuuming ? Robert Haas
• 18:20   Re: Aggressive autovacuuming ? Scott Marlowe
• 18:49   Re: Aggressive autovacuuming ? Robert Haas
• 19:01   WAL+Os on a single disk Anj Adu
• 19:34   Re: WAL+Os on a single disk Scott Marlowe
• 19:37   Re: PostgreSQL as a local in-memory cache Bruce Momjian
• 19:40   Re: PostgreSQL as a local in-memory cache Bruce Momjian
• 19:51   Re: PostgreSQL as a local in-memory cache Pavel Stehule
• 20:16   Re: PostgreSQL as a local in-memory cache Bruce Momjian
• 20:25   Re: PostgreSQL as a local in-memory cache Robert Haas
• 20:27   Re: PostgreSQL as a local in-memory cache Dave Page
• 20:27   Re: PostgreSQL as a local in-memory cache Bruce Momjian
• 20:43   Re: PostgreSQL as a local in-memory cache Tom Lane
• 20:45   Re: PostgreSQL as a local in-memory cache Bruce Momjian

24 June 2010

• 08:25   Re: PostgreSQL as a local in-memory cache Dimitri Fontaine
• 08:40   Re: PostgreSQL as a local in-memory cache Rob Wultsch
• 09:14   Re: WAL+Os on a single disk Matthew Wakeling
• 10:45   Small Queries Really Fast, Large Queries Really Slow... Tom Wilcox
• 11:20   Re: Small Queries Really Fast, Large Queries Really Slow... tv@fuzzy.cz
• 11:35   Re: PostgreSQL as a local in-memory cache Robert Haas
• 12:43   Write performance Janning
• 12:47   Re: Write performance Kenneth Marshall
• 12:54   Re: Write performance Matthew Wakeling
• 13:16   Re: Write performance Janning
• 13:31   Re: Write performance Janning
• 13:32   Re: WAL+Os on a single disk Scott Marlowe
• 13:58   Re: Write performance Greg Smith
• 14:55   Re: WAL+Os on a single disk Anj Adu
• 14:56   Re: cpu bound postgresql setup. Rajesh Kumar Mallah
• 15:03   Re: ALTER Table and CLUSTER does adding a new column rewrite clustered? (8.4.3) Bruce Momjian
• 15:28   Re: cpu bound postgresql setup. Kevin Grittner
• 16:46   Re: Write performance Janning Vygen
• 17:03   Re: Write performance Jesper Krogh
• 17:25   Re: cpu bound postgresql setup. Rajesh Kumar Mallah
• 17:27   Re: cpu bound postgresql setup. Rajesh Kumar Mallah
• 18:38   Re: cpu bound postgresql setup. Benjamin Krajmalnik
• 18:56   Re: PostgreSQL as a local in-memory cache Josh Berkus
• 18:58   Re: cpu bound postgresql setup. Alvaro Herrera
• 19:00   Re: cpu bound postgresql setup. Kevin Grittner
• 19:15   Re: PostgreSQL as a local in-memory cache Pavel Stehule
• 19:48   Re: PostgreSQL as a local in-memory cache Joshua D. Drake
• 20:02   Re: PostgreSQL as a local in-memory cache Pavel Stehule
• 20:38   Re: PostgreSQL as a local in-memory cache A.M.
• 21:33   Re: PostgreSQL as a local in-memory cache Pavel Stehule
• 21:37   Re: PostgreSQL as a local in-memory cache Josh Berkus
• 21:56   Re: PostgreSQL as a local in-memory cache Pavel Stehule
• 23:03   Re: requested shared memory size overflows size_t Craig James
• 23:19   Re: requested shared memory size overflows size_t Alvaro Herrera
• 23:32   Re: System tables screwed up? (WAS requested shared memory size overflows size_t) Craig James
• 23:55   Re: System tables screwed up? (WAS requested shared memory size overflows size_t) Alvaro Herrera

25 June 2010

• 00:50   Re: Occasional giant spikes in CPU load Craig James
• 01:01   Re: Occasional giant spikes in CPU load Joshua D. Drake
• 01:14   Re: Occasional giant spikes in CPU load Greg Smith
• 02:47   Re: PostgreSQL as a local in-memory cache Joshua D. Drake
• 03:05   Re: requested shared memory size overflows size_t Robert Haas
• 04:05   Re: Occasional giant spikes in CPU load Tom Lane
• 06:11   Re: requested shared memory size overflows size_t Jim Montgomery
• 08:01   Re: Occasional giant spikes in CPU load Joshua D. Drake
• 09:55   sudden spurt in swap utilization (was:cpu bound postgresql setup.) Rajesh Kumar Mallah
• 11:28   Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) Devrim GÜNDÜZ
• 11:28   Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) Yeb Havinga
• 13:48   Re: Occasional giant spikes in CPU load Craig James
• 14:14   Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) Rajesh Kumar Mallah
• 14:32   Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) Kevin Grittner
• 14:47   Re: Occasional giant spikes in CPU load Tom Lane
• 15:15   Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) Rajesh Kumar Mallah
• 15:59   Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) Rajesh Kumar Mallah
• 16:07   Re: Occasional giant spikes in CPU load Rajesh Kumar Mallah
• 16:17   Re: Occasional giant spikes in CPU load Craig James
• 16:39   Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) Tom Molesworth
• 16:41   Re: Occasional giant spikes in CPU load Kevin Grittner
• 16:42   Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) Kevin Grittner
• 16:55   Re: Occasional giant spikes in CPU load Greg Smith
• 17:01   Re: Occasional giant spikes in CPU load Tom Lane
• 17:07   Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) Greg Smith
• 17:07   Re: Occasional giant spikes in CPU load Craig James
• 17:30   Re: Write performance Scott Carey
• 18:48   Any recent AMD purchases? Greg Smith
• 18:53   pgbench results on a new server Craig James
• 19:00   Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) Rajesh Kumar Mallah
• 19:01   Re: pgbench results on a new server Scott Marlowe
• 19:03   Re: pgbench results on a new server Greg Smith
• 20:04   Architecting a database tony@exquisiteimages.com
• 20:53   Re: Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) Tom Molesworth
• 22:29   Re: Architecting a database Kevin Grittner
• 23:37   Re: Architecting a database Craig James

26 June 2010

• 00:03   Re: Architecting a database Greg Smith
• 01:15   Re: WAL+Os on a single disk Robert Haas
• 01:41   Re: Architecting a database Bryan Hinton
• 02:48   Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) Rajesh Kumar Mallah
• 04:43   Re: Architecting a database Craig Ringer
• 09:55   Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) Rajesh Kumar Mallah
• 13:22   Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) Rajesh Kumar Mallah
• 15:49   Re: Architecting a database Merlin Moncure

28 June 2010

• 08:01   Re: Architecting a database Dimitri Fontaine
• 11:08   order by slowing down a query by 80 times Rajesh Kumar Mallah
• 11:39   Re: order by slowing down a query by 80 times Yeb Havinga
• 13:26   Re: order by slowing down a query by 80 times Andres Freund
• 13:42   Re: order by slowing down a query by 80 times Rajesh Kumar Mallah
• 13:52   Re: order by slowing down a query by 80 times Kevin Grittner
• 14:17   Re: order by slowing down a query by 80 times Tom Lane
• 17:37   Re: pgbench results on a new server Craig James
• 19:03   Re: order by slowing down a query by 80 times Rajesh Kumar Mallah
• 19:57   Re: order by slowing down a query by 80 times Rajesh Kumar Mallah
• 20:19   Re: order by slowing down a query by 80 times Tom Lane
• 21:44   Re: cpu bound postgresql setup. Bruce Momjian
• 21:57   Re: PostgreSQL as a local in-memory cache Bruce Momjian

29 June 2010

• 10:52   Re: PostgreSQL as a local in-memory cache Robert Haas
• 11:59   Re: Low perfomance SUM and Group by large databse Sergio Charpinel Jr.
• 13:18   Re: pgbench results on a new server Merlin Moncure
• 13:32   Re: PostgreSQL as a local in-memory cache Bruce Momjian
• 14:14   Re: PostgreSQL as a local in-memory cache Kevin Grittner
• 15:12   Re: cpu bound postgresql setup. Benjamin Krajmalnik
• 15:29   Re: cpu bound postgresql setup. Bruce Momjian
• 17:09   Re: PostgreSQL as a local in-memory cache Robert Haas
• 17:20   Re: PostgreSQL as a local in-memory cache Bruce Momjian
• 17:28   Re: PostgreSQL as a local in-memory cache Tom Lane
• 18:45   Re: PostgreSQL as a local in-memory cache Bruce Momjian
• 21:00   ideal storage configuration Samuel Gendler
• 21:30   Re: ideal storage configuration Kevin Grittner

30 June 2010

• 00:48   Re: PostgreSQL as a local in-memory cache Jignesh Shah
• 01:23   Re: pgbench results on a new server Greg Smith
• 01:39   Re: PostgreSQL as a local in-memory cache Bruce Momjian
• 09:56   Re: ideal storage configuration Matthew Wakeling
• 13:52   Re: ideal storage configuration Greg Smith
• 14:31   Re: PostgreSQL as a local in-memory cache Brad Nicholson
• 15:45   Re: PostgreSQL as a local in-memory cache Bruce Momjian
• 16:43   Re: PostgreSQL as a local in-memory cache Dave Crooke
• 17:06   Re: PostgreSQL as a local in-memory cache Craig James
• 18:12   Re: Architecting a database tony@exquisiteimages.com
• 18:21   Re: PostgreSQL as a local in-memory cache Jignesh Shah
• 18:28   Re: Architecting a database Ben Chobot