Mailing lists [pgsql-performance]

1 August 2003

• 03:40   Re: Views With Unions Rajesh Kumar Mallah
• 12:20   Re: Odd explain estimate Andrew Sullivan
• 12:21   Re: Views With Unions Christopher Browne
• 15:10   Re: Views With Unions Stephan Szabo
• 15:50   Re: Views With Unions Christopher Browne
• 16:08   How number of columns affects performance Francisco Reyes
• 16:34   Re: How number of columns affects performance Ron Johnson
• 16:51   Re: Views With Unions Tom Lane
• 17:13   Re: How number of columns affects performance Francisco J Reyes
• 17:32   Re: How number of columns affects performance Ron Johnson
• 17:45   Re: How number of columns affects performance Josh Berkus
• 17:56   OSDL Database Test Suite 3 is available on PostgreSQL Jenny Zhang
• 18:59   Re: OSDL Database Test Suite 3 is available on PostgreSQL Josh Berkus
• 19:19   Re: How number of columns affects performance Ron Johnson
• 19:23   Re: How number of columns affects performance Josh Berkus
• 20:54   Re: How number of columns affects performance Francisco J Reyes
• 21:17   I can't wait too much: Total runtime 432478.44 msec Fernando Papa
• 21:19   Re: How number of columns affects performance Josh Berkus
• 21:27   Re: I can't wait too much: Total runtime 432478.44 msec Christopher Browne
• 21:33   Re: I can't wait too much: Total runtime 432478.44 msec Josh Berkus

2 August 2003

• 10:37   Re: I can't wait too much: Total runtime 432478.44 msec Mendola Gaetano
• 15:59   Re: Odd explain estimate Jim C. Nasby

3 August 2003

• 07:10   testing Ron Johnson

4 August 2003

• 14:08   Re: OSDL Database Test Suite 3 is available on PostgreSQL Manfred Koizar
• 14:14   Re: I can't wait too much: Total runtime 432478.44 msec Manfred Koizar
• 14:15   Re: I can't wait too much: Total runtime 432478.44 msec Fernando Papa
• 14:19   Re: I can't wait too much: Total runtime 432478.44 msec Fernando Papa
• 14:51   Re: I can't wait too much: Total runtime 432478.44 msec Fernando Papa
• 15:04   Re: I can't wait too much: Total runtime 432478.44 msec Fernando Papa
• 15:17   Re: I can't wait too much: Total runtime 432478.44 msec Manfred Koizar
• 15:26   Re: EXTERNAL storage and substring on long strings Scott Cain
• 15:27   Re: I can't wait too much: Total runtime 432478.44 msec Fernando Papa
• 15:57   Re: [SQL] EXTERNAL storage and substring on long strings Tom Lane
• 16:00   Re: [SQL] EXTERNAL storage and substring on long strings Richard Huxton
• 16:14   Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain
• 16:17   Re: [SQL] EXTERNAL storage and substring on long strings Shridhar Daithankar
• 16:23   Re: OSDL Database Test Suite 3 is available on PostgreSQL scott.marlowe
• 16:24   Re: OSDL Database Test Suite 3 is available on PostgreSQL scott.marlowe
• 16:28   Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain
• 16:37   Re: OSDL Database Test Suite 3 is available on PostgreSQL Shridhar Daithankar
• 16:56   Re: [SQL] EXTERNAL storage and substring on long strings Matt Clark
• 20:17   Re: I can't wait too much: Total runtime 432478.44 msec Fernando Papa
• 20:33   Re: [SQL] EXTERNAL storage and substring on long strings Joe Conway
• 21:14   Re: Indexes not used for "min()" Bruno Wolff III
• 21:28   Re: I can't wait too much: Total runtime 432478.44 msec Tom Lane
• 22:02   Re: I can't wait too much: Total runtime 432478.44 msec Fernando Papa
• 22:31   Re: I can't wait too much: Total runtime 432478.44 msec Tom Lane
• 22:42   Re: [osdldbt-general] Re: OSDL Database Test Suite 3 is Jenny Zhang
• 22:49   Re: [osdldbt-general] Re: OSDL Database Test Suite 3 is Craig Thomas
• 22:54   Re: [osdldbt-general] Re: OSDL Database Test Suite 3 is scott.marlowe
• 23:36   Re: I can't wait too much: Total runtime 432478.44 msec Manfred Koizar

5 August 2003

• 06:23   Re: I can't wait too much: Total runtime 432478.44 msec Volker Helm
• 09:45   query/table design help Ara Anjargolian
• 09:56   Re: query/table design help Shridhar Daithankar
• 12:09   Some vacuum & tuning help Jeff
• 12:35   Re: Some vacuum & tuning help Shridhar Daithankar
• 13:16   Re: Some vacuum & tuning help Peter Childs
• 13:21   Fwd: Re: postgresql.conf Hilary Forbes
• 13:21   Re: Some vacuum & tuning help Jeff
• 13:33   Re: Some vacuum & tuning help Shridhar Daithankar
• 13:46   Re: Some vacuum & tuning help Shridhar Daithankar
• 14:16   Re: Some vacuum & tuning help Peter Childs
• 14:29   Re: Some vacuum & tuning help Christopher Browne
• 14:38   Re: Some vacuum & tuning help Tom Lane
• 14:43   Re: Some vacuum & tuning help Shridhar Daithankar
• 15:01   Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain
• 15:05   Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain
• 15:07   Re: Some vacuum & tuning help Matthew T. O'Connor
• 15:23   Re: [SQL] EXTERNAL storage and substring on long strings Joe Conway
• 15:30   Re: Some vacuum & tuning help Matthew T. O'Connor
• 15:35   Re: Some vacuum & tuning help Tom Lane
• 15:45   Re: Some vacuum & tuning help Matthew T. O'Connor
• 15:59   How Many Inserts Per Transactions Trevor Astrope
• 16:01   Re: Some vacuum & tuning help Matthew T. O'Connor
• 16:17   Re: How Many Inserts Per Transactions scott.marlowe
• 16:19   Re: Some vacuum & tuning help Tom Lane
• 16:28   Re: How Many Inserts Per Transactions Christopher Browne
• 16:50   Re: Some vacuum & tuning help Bruce Momjian
• 17:31   Odd performance results - more info Medora Schauer
• 17:45   Re: Odd performance results - more info Joe Conway
• 17:50   Re: Odd performance results - more info Stephan Szabo
• 17:58   Re: Odd performance results - more info Medora Schauer
• 18:18   Re: Odd performance results - more info Medora Schauer
• 21:40   Re: Some vacuum & tuning help Christopher Browne
• 22:26   Re: Moving postgresql.conf tunables into 2003... Sean Chittenden

6 August 2003

• 01:38   Re: Some vacuum & tuning help Christopher Kings-Lynne
• 04:22   Re: Some vacuum & tuning help Matthew T. O'Connor
• 04:32   Re: Some vacuum & tuning help Bruce Momjian
• 04:36   Re: Some vacuum & tuning help Matthew T. O'Connor
• 04:39   Re: Some vacuum & tuning help Christopher Kings-Lynne
• 04:46   Re: Some vacuum & tuning help Tom Lane
• 05:36   Re: Some vacuum & tuning help Neil Conway
• 06:48   Re: How Many Inserts Per Transactions Hannu Krosing
• 07:35   PostgreSQL performance problem -> tuning Yaroslav Mazurak
• 09:31   Re: PostgreSQL performance problem -> tuning Richard Huxton
• 10:14   Re: How Many Inserts Per Transactions Shridhar Daithankar
• 11:49   Re: PostgreSQL performance problem -> tuning Mendola Gaetano
• 12:43   Re: PostgreSQL performance problem -> tuning Yaroslav Mazurak
• 12:52   Re: PostgreSQL performance problem -> tuning Shridhar Daithankar
• 12:55   Re: Some vacuum & tuning help Matthew T. O'Connor
• 14:00   Postgresql slow on XEON 2.4ghz/1gb ram Wilson A. Galafassi Jr.
• 15:39   Re: PostgreSQL performance problem -> tuning Richard Huxton
• 18:14   PostgreSql under Linux Wilson A. Galafassi Jr.
• 18:17   Re: PostgreSQL performance problem -> tuning Tom Lane
• 18:33   Re: PostgreSQL performance problem -> tuning Tom Lane
• 18:56   How to efficiently duplicate a whole schema? Sebastien Lemieux
• 19:11   Re: How to efficiently duplicate a whole schema? Nick Fankhauser
• 19:14   Re: How to efficiently duplicate a whole schema? Tom Lane
• 19:29   Re: How to efficiently duplicate a whole schema? scott.marlowe
• 19:29   Re: How to efficiently duplicate a whole schema? Tom Lane
• 20:09   partitioning for postgresql Wilson A. Galafassi Jr.
• 20:15   Re: How to efficiently duplicate a whole schema? scott.marlowe
• 20:24   Re: partitioning for postgresql scott.marlowe
• 20:36   Re: EXTERNAL storage and substring on long strings Tom Lane
• 20:39   ext3 block size Wilson A. Galafassi Jr.
• 20:51   Re: partitioning for postgresql Christopher Browne
• 20:52   Re: ext3 block size scott.marlowe
• 20:56   Re: EXTERNAL storage and substring on long strings Joe Conway
• 21:08   Re: EXTERNAL storage and substring on long strings Tom Lane
• 21:23   Re: How to efficiently duplicate a whole schema? Sebastien Lemieux
• 21:36   Re: PostgreSql under Linux Neil Conway
• 21:55   Re: How to efficiently duplicate a whole schema? Tom Lane
• 21:56   Re: How to efficiently duplicate a whole schema? Stephan Szabo
• 22:07   Re: How to efficiently duplicate a whole schema? Tom Lane

7 August 2003

• 07:05   Re: PostgreSQL performance problem -> tuning Yaroslav Mazurak
• 07:36   Re: PostgreSQL performance problem -> tuning Shridhar Daithankar
• 07:42   Re: PostgreSQL performance problem -> tuning Yaroslav Mazurak
• 08:11   Re: PostgreSQL performance problem -> tuning Richard Huxton
• 08:23   Re: PostgreSQL performance problem -> tuning Dennis Björklund
• 08:25   Re: PostgreSQL performance problem -> tuning Yaroslav Mazurak
• 08:27   Simple filesystem benchmark on Linux 2.6 Shridhar Daithankar
• 14:50   Re: Moving postgresql.conf tunables into 2003... Manfred Koizar
• 14:53   Re: PostgreSQL performance problem -> tuning Richard Huxton
• 15:05   Re: How to efficiently duplicate a whole schema? Sebastien Lemieux
• 16:35   Re: PostgreSQL performance problem -> tuning scott.marlowe
• 16:37   Re: PostgreSQL performance problem -> tuning Yaroslav Mazurak
• 16:41   Re: PostgreSQL performance problem -> tuning scott.marlowe
• 17:04   Re: PostgreSQL performance problem -> tuning Yaroslav Mazurak
• 18:06   Re: PostgreSQL performance problem -> tuning matt
• 18:15   Testing gateway Marc G. Fournier
• 19:12   Re: PostgreSQL performance problem -> tuning Richard Huxton
• 19:13   Re: PostgreSQL performance problem -> tuning Ron Johnson
• 19:16   Re: PostgreSQL performance problem -> tuning scott.marlowe
• 20:24   Re: Moving postgresql.conf tunables into 2003... Sean Chittenden
• 21:16   Re: EXTERNAL storage and substring on long strings Scott Cain
• 23:32   Re: Moving postgresql.conf tunables into 2003... Tom Lane

8 August 2003

• 07:54   Re: PostgreSQL performance problem -> tuning Yaroslav Mazurak
• 10:28   Perfomance Tuning mixo
• 10:41   Re: Perfomance Tuning Bjoern Metzdorf
• 10:51   Re: Perfomance Tuning Shridhar Daithankar
• 11:29   Re: Perfomance Tuning Paul Thomas
• 13:45   Re: Perfomance Tuning scott.marlowe
• 17:08   Re: Perfomance Tuning Jonathan Gardner
• 17:32   Index correlation (was: Moving postgresql.conf tunables into 2003... ) Manfred Koizar
• 19:04   Re: Perfomance Tuning Andrew Sullivan
• 19:21   Re: Perfomance Tuning Rod Taylor
• 19:37   Re: Perfomance Tuning Bruce Momjian
• 19:47   Re: Perfomance Tuning Rod Taylor
• 19:57   Re: Perfomance Tuning Andrew Sullivan
• 20:14   Re: Perfomance Tuning Tom Lane

11 August 2003

• 09:01   How to force PostgreeSQL to work faster? Serge Dorofeev
• 11:34   Peformance of Update 
• 11:38   Re: How to force PostgreeSQL to work faster? Tomka Gergely
• 12:31   Re: How to force PostgreeSQL to work faster? Paul Thomas
• 13:23   Re: How to force PostgreeSQL to work faster? Shridhar Daithankar
• 13:26   Re: Peformance of Update Shridhar Daithankar
• 14:16   Analyze makes queries slow... Stef
• 15:09   Re: Perfomance Tuning scott.marlowe
• 15:24   Re: Perfomance Tuning Andrew Sullivan
• 15:44   Re: Analyze makes queries slow... Tom Lane
• 16:48   Re: Analyze makes queries slow... Stef
• 18:26   Re: Analyze makes queries slow... Tom Lane
• 18:51   Re: Analyze makes queries slow... Tom Lane
• 21:18   Odd problem with performance in duplicate database Josh Berkus
• 22:05   Re: Odd problem with performance in duplicate database Josh Berkus
• 22:21   Re: Perfomance Tuning Bruce Momjian
• 22:42   Re: Odd problem with performance in duplicate database Ron Johnson
• 22:49   Re: Odd problem with performance in duplicate database Josh Berkus
• 22:52   Re: Odd problem with performance in duplicate database Peter Darley
• 22:56   Re: Perfomance Tuning Reece Hart
• 22:59   Re: Perfomance Tuning Bruce Momjian
• 23:00   Re: Odd problem with performance in duplicate database Josh Berkus
• 23:24   Re: Odd problem with performance in duplicate database Tom Lane

12 August 2003

• 00:12   Re: Odd problem with performance in duplicate database Tom Lane
• 00:13   Re: Odd problem with performance in duplicate database Josh Berkus
• 00:14   Re: Odd problem with performance in duplicate database Tom Lane
• 00:30   Re: Odd problem with performance in duplicate database Tom Lane
• 00:44   Re: Perfomance Tuning Christopher Kings-Lynne
• 00:45   Re: Odd problem with performance in duplicate database Josh Berkus
• 00:55   Re: Odd problem with performance in duplicate database Josh Berkus
• 02:37   about performance of postgreSQL xin fu
• 03:19   On Linux Filesystems Christopher Browne
• 04:07   Re: On Linux Filesystems Bruce Momjian
• 04:16   Re: On Linux Filesystems Bruce Momjian
• 04:37   Re: Perfomance Tuning Neil Conway
• 04:42   Re: Perfomance Tuning Ron Johnson
• 04:53   Re: Perfomance Tuning Bruce Momjian
• 05:08   Re: Perfomance Tuning Neil Conway
• 13:12   Re: Odd problem with performance in duplicate database Tom Lane
• 14:29   Re: On Linux Filesystems Andrew Sullivan
• 14:29   Re: Perfomance Tuning scott.marlowe
• 14:32   Re: Perfomance Tuning scott.marlowe
• 14:39   Re: Perfomance Tuning scott.marlowe
• 14:41   Re: Perfomance Tuning scott.marlowe
• 15:06   Re: On Linux Filesystems scott.marlowe
• 16:28   Re: Analyze makes queries slow... Jacek Rembisz
• 16:38   Re: On Linux Filesystems Josh Berkus
• 16:47   Re: On Linux Filesystems Andrew Sullivan
• 17:26   Re: about performance of postgreSQL Chris Travers
• 17:30   Re: Analyze makes queries slow... Stef
• 18:03   Re: about performance of postgreSQL Josh Berkus
• 18:26   Re: Perfomance Tuning Shridhar Daithankar
• 18:34   Re: Perfomance Tuning mixo
• 18:41   Re: Perfomance Tuning Bruce Momjian
• 18:42   Re: Perfomance Tuning Bill Moran
• 18:55   Re: Perfomance Tuning Andrew Sullivan
• 19:30   Re: Perfomance Tuning Gregory S. Williamson
• 19:46   Re: Perfomance Tuning Sean Chittenden
• 20:11   Re: Filesystems WAS: Perfomance Tuning Josh Berkus
• 20:33   Re: Filesystems WAS: Perfomance Tuning Richard Welty
• 20:40   Re: Filesystems WAS: Perfomance Tuning Andrew Sullivan
• 20:43   Re: Filesystems WAS: Perfomance Tuning Rod Taylor

13 August 2003

• 01:40   Re: Filesystems WAS: Perfomance Tuning Christopher Kings-Lynne
• 01:53   Re: Filesystems WAS: Perfomance Tuning Richard Welty
• 01:54   Re: Filesystems WAS: Perfomance Tuning Bruce Momjian
• 02:14   Re: Filesystems WAS: Perfomance Tuning Gavin Sherry
• 06:13   Re: Perfomance Tuning Ron Johnson
• 06:30   Re: Perfomance Tuning Dennis Björklund
• 06:39   Re: Perfomance Tuning Christopher Kings-Lynne
• 10:33   Re: Perfomance Tuning Ron Johnson
• 11:54   Re: Perfomance Tuning Christopher Browne
• 13:56   Re: Perfomance Tuning Jeff
• 14:04   How can I Improve performance in Solaris? ingrid martinez
• 14:33   Re: How can I Improve performance in Solaris? Andrew Sullivan
• 14:44   Re: Perfomance Tuning Tom Lane
• 15:16   Re: Perfomance Tuning Ron Johnson
• 15:18   Re: How can I Improve performance in Solaris? ingrid martinez
• 15:37   Re: Perfomance Tuning Bruce Momjian
• 15:47   Re: Perfomance Tuning Josh Berkus
• 15:50   Re: How can I Improve performance in Solaris? Rod Taylor
• 16:17   Re: How can I Improve performance in Solaris? Andrew Sullivan
• 16:21   Re: How can I Improve performance in Solaris? ingrid martinez
• 16:47   Re: How can I Improve performance in Solaris? scott.marlowe
• 16:56   Re: How can I Improve performance in Solaris? ingrid martinez
• 17:52   Re: Perfomance Tuning Bruce Momjian
• 19:00   Re: How can I Improve performance in Solaris? scott.marlowe
• 19:19   Re: Perfomance Tuning Christopher Browne
• 19:19   Re: Perfomance Tuning Christopher Browne
• 21:35   Re: Perfomance Tuning Ron Johnson
• 23:23   Re: Perfomance Tuning Sean Chittenden

14 August 2003

• 10:24   7.4 beta 1 getting out of swap Bertrand Petit
• 11:44   'View'-performance Alexander Priem
• 11:48   Re: 7.4 beta 1 getting out of swap Tom Lane
• 12:03   Re: 'View'-performance Tom Lane
• 12:30   Re: Perfomance Tuning Jeff
• 12:45   Re: Perfomance Tuning Jeff
• 12:45   Re: Perfomance Tuning Jeff
• 15:39   Re: 7.4 beta 1 getting out of swap Tom Lane
• 15:39   Re: Perfomance Tuning Christopher Browne
• 15:40   Re: Perfomance Tuning Christopher Browne
• 15:44   Re: [SQL] EXTERNAL storage and substring on long strings Jan Wieck
• 15:51   Re: 7.4 beta 1 getting out of swap Bertrand Petit
• 17:59   Vacuum performance question Jeremy M. Guthrie
• 18:11   Re: Vacuum performance question Rod Taylor
• 18:13   Re: [SQL] EXTERNAL storage and substring on long strings Tom Lane
• 18:19   Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain
• 19:12   Re: [SQL] EXTERNAL storage and substring on long strings Jan Wieck
• 19:38   Re: Vacuum performance question Tom Lane
• 22:03   Re: Perfomance Tuning Bruce Momjian
• 22:03   Re: Perfomance Tuning Bruce Momjian

15 August 2003

• 09:13   Benchmark mixo
• 10:26   Re: Benchmark Tomka Gergely
• 11:13   Re: On Linux Filesystems Toni Schlichting
• 14:35   Re: Benchmark Richard Huxton
• 16:44   Re: Benchmark Josh Berkus
• 18:24   Re: Benchmark Jeff
• 18:47   Re: Benchmark Balazs Wellisch

16 August 2003

• 08:38   Insert performance Shridhar Daithankar
• 20:33   Re: Insert performance Josh Berkus
• 22:50   Re: Insert performance Christopher Browne

17 August 2003

• 03:52   Re: Benchmark David Emery

18 August 2003

• 06:23   Re: Insert performance Shridhar Daithankar
• 17:25   bad join performance pginfo
• 17:32   Re: Insert performance Shridhar Daithankar
• 18:48   Re: Insert performance Josh Berkus
• 18:54   bad join preformance pginfo
• 19:11   Re: Insert performance Hannu Krosing
• 20:49   Re: bad join performance Tom Lane
• 21:51   Re: bad join performance Stephan Szabo
• 22:17   Re: Insert performance Hannu Krosing

19 August 2003

• 04:22   Re: bad join performance pginfo
• 04:24   Re: bad join performance Tom Lane
• 04:32   Re: bad join performance pginfo
• 06:27   Re: Insert performance Shridhar Daithankar
• 06:31   Re: Insert performance Shridhar Daithankar

20 August 2003

• 10:04   When NOT to index small tables? 
• 13:31   Re: When NOT to index small tables? Bruno Wolff III

21 August 2003

• 11:54   More connections in Solaris9 Tam MK
• 13:37   Sorting a query on a view ignores an index Mathieu De Zutter
• 14:07   A better look on the same problem (ignored index) Mathieu De Zutter
• 14:51   Tests Tomka Gergely
• 14:57   Re: Tests Shridhar Daithankar
• 14:59   Re: Sorting a query on a view ignores an index Tom Lane
• 16:25   Re: Sorting a query on a view ignores an index Mathieu De Zutter
• 16:28   Re: Tests Bill Moran
• 17:03   Re: Sorting a query on a view ignores an index Tom Lane
• 17:56   Re: Tests Tomka Gergely
• 18:17   Re: Tests Bill Moran
• 20:12   Re: Sorting a query on a view ignores an index Your Name
• 20:57   Re: Sorting a query on a view ignores an index Mathieu De Zutter

22 August 2003

• 10:14   Re: Sorting a query on a view ignores an index 
• 20:47   Re: Tests Robert Treat
• 20:54   Re: Tests Tomka Gergely
• 21:01   Re: Tests Bill Moran
• 22:19   Re: Tests Josh Berkus
• 22:25   Re: Tests Robert Treat
• 23:32   Re: Tests Paul Thomas
• 23:55   Re: Tests Bill Moran

23 August 2003

• 00:04   Re: Tests Josh Berkus
• 05:23   Re: Tests Tomka Gergely
• 07:55   Mail delivery failed: returning message to sender Mail Delivery System

25 August 2003

• 15:04   Query too slow Rhaoni Chiu Pereira
• 15:19   Re: Tests scott.marlowe
• 15:24   Re: Tests Bill Moran
• 15:28   Re: Tests Tomka Gergely
• 15:45   Re: Query too slow Stephan Szabo
• 16:33   Re: Query too slow Shridhar Daithankar
• 20:22   What is the fastest way to get a resultset Bupp Phillips

26 August 2003

• 05:49   Re: Replication Ideas Christopher Browne
• 05:57   Re: What is the fastest way to get a resultset Jeff
• 05:58   Re: What is the fastest way to get a resultset Magnus Naeslund(f)
• 06:46   Re: Query too slow Ang Chin Han
• 15:48   Re: Query too slow Stephan Szabo
• 16:02   Re: Query too slow Tom Lane
• 16:48   Best tweak for fast results.. ? JM
• 17:01   Sun vs a P2. Interesting results. Jeff
• 17:45   Re: Best tweak for fast results.. ? Richard Huxton
• 17:49   Re: Sun vs a P2. Interesting results. Darcy Buskermolen
• 17:53   Re: What is the fastest way to get a resultset Bupp Phillips
• 18:05   Re: Sun vs a P2. Interesting results. Darcy Buskermolen
• 18:29   Re: What is the fastest way to get a resultset Neil Conway
• 18:42   Re: Sun vs a P2. Interesting results. Jeff
• 19:03   Re: Sun vs a P2. Interesting results. Darcy Buskermolen
• 19:07   Re: Sun vs a P2. Interesting results. Jeff
• 19:43   Re: Sun vs a P2. Interesting results. Neil Conway

27 August 2003

• 01:39   Hardware recommendations to scale to silly load matt
• 04:09   8 way Intel Xeon system Castle, Lindsay
• 06:53   Re: Sun vs a P2. Interesting results. Shridhar Daithankar
• 06:59   Re: 8 way Intel Xeon system Shridhar Daithankar
• 07:12   Re: What is the fastest way to get a resultset Bupp Phillips
• 14:20   Re: Hardware recommendations to scale to silly load Bill Moran
• 15:35   Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4 Shridhar Daithankar
• 23:26   Queries sometimes take 1000 times the normal time Anders K. Pedersen
• 23:27   Re: Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4 Neil Conway
• 23:46   Simple queries take forever to run Michael Guerin

28 August 2003

• 01:03   Please scan your computer Dennis Gearon
• 01:11   Re: Hardware recommendations to scale to silly load matt
• 01:17   Re: Queries sometimes take 1000 times the normal time Rod Taylor
• 01:25   Re: Simple queries take forever to run Stephan Szabo
• 01:26   Re: Simple queries take forever to run Neil Conway
• 01:28   Re: Queries sometimes take 1000 times the normal time Tom Lane
• 01:28   Re: Sun vs a P2. Interesting results. Jeff
• 01:30   Re: Hardware recommendations to scale to silly load scott.marlowe
• 01:40   Re: Hardware recommendations to scale to silly load matt
• 01:44   Improving simple textsearch? Fabian Kreitner
• 01:56   Simple queries take forever to run Michael Guerin
• 01:57   Re: Hardware recommendations to scale to silly load Christopher Browne
• 02:01   Re: Simple queries take forever to run Christopher Kings-Lynne
• 02:03   Re: Hardware recommendations to scale to silly load matt
• 02:07   pgsql inserts problem Tarhon-Onu Victor
• 02:11   Re: Tests Tomka Gergely
• 02:11   Re: Sun vs a P2. Interesting results. Jeff
• 02:18   Re: Hardware recommendations to scale to silly load Andrew Sullivan
• 02:24   Re: Hardware recommendations to scale to silly load Christopher Browne
• 02:30   Re: Hardware recommendations to scale to silly load Bill Moran
• 02:44   Re: 8 way Intel Xeon system Tomka Gergely
• 02:50   Re: Hardware recommendations to scale to silly load Ron Johnson
• 02:53   Re: Hardware recommendations to scale to silly load Bill Moran
• 02:54   The results of my PostgreSQL/filesystem performance tests Bill Moran
• 03:05   Re: 8 way Intel Xeon system Christopher Browne
• 03:13   Re: Best tweak for fast results.. ? scott.marlowe
• 03:31   Re: pgsql inserts problem Bruno Wolff III
• 03:33   Re: Sun vs a P2. Interesting results. Tom Lane
• 03:59   Re: pgsql inserts problem Christopher Kings-Lynne
• 04:09   Re: Hardware recommendations to scale to silly load Ron Johnson
• 05:22   Re: The results of my PostgreSQL/filesystem performance tests Balazs Wellisch
• 05:25   Re: Tests Balazs Wellisch
• 06:29   Re: pgsql inserts problem Tarhon-Onu Victor
• 06:40   Re: Hardware recommendations to scale to silly load Tomka Gergely
• 06:45   Re: The results of my PostgreSQL/filesystem performance tests Shridhar Daithankar
• 06:47   Re: Queries sometimes take 1000 times the normal time Shridhar Daithankar
• 06:50   Re: pgsql inserts problem Shridhar Daithankar
• 06:52   Re: Hardware recommendations to scale to silly load Tomka Gergely
• 06:52   Re: Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4 Shridhar Daithankar
• 06:56   Re: 8 way Intel Xeon system Tomka Gergely
• 07:32   Re: pgsql inserts problem Christopher Kings-Lynne
• 08:11   Re: The results of my PostgreSQL/filesystem performance Dennis Björklund
• 08:17   Re: Hardware recommendations to scale to silly load matt
• 09:03   Re: Hardware recommendations to scale to silly load Ron Johnson
• 09:03   Re: Queries sometimes take 1000 times the normal time Russell Garrett
• 09:09   Re: Queries sometimes take 1000 times the normal time Shridhar Daithankar
• 09:19   Re: The results of my PostgreSQL/filesystem performance Ron Johnson
• 09:24   Re: The results of my PostgreSQL/filesystem performance Ron Johnson
• 09:29   Re: Queries sometimes take 1000 times the normal time Russell Garrett
• 12:05   Re: The results of my PostgreSQL/filesystem performance tests Ludek Finstrle
• 12:22   Re: The results of my PostgreSQL/filesystem performance tests Christopher Browne
• 12:25   Re: The results of my PostgreSQL/filesystem performance Jeff
• 12:58   Re: pgsql inserts problem Richard Huxton
• 13:44   Re: The results of my PostgreSQL/filesystem performance tests Rod Taylor
• 13:45   Re: The results of my PostgreSQL/filesystem performance Tomka Gergely
• 13:46   Re: The results of my PostgreSQL/filesystem performance Tomka Gergely
• 14:09   Re: Hardware recommendations to scale to silly load Chris Bowlby
• 14:22   Re: Hardware recommendations to scale to silly load Shridhar Daithankar
• 14:38   Re: Simple queries take forever to run Michael Guerin
• 14:40   Re: Hardware recommendations to scale to silly load Vivek Khera
• 14:48   Re: Simple queries take forever to run Shridhar Daithankar
• 14:55   Re: Hardware recommendations to scale to silly load Rod Taylor
• 15:31   Re: Simple queries take forever to run Stephan Szabo
• 15:35   Re: Hardware recommendations to scale to silly load scott.marlowe
• 16:20   Re: Hardware recommendations to scale to silly load Andrew Sullivan
• 16:31   Re: Hardware recommendations to scale to silly load Matt Clark
• 16:42   Re: Hardware recommendations to scale to silly load Matt Clark
• 17:22   performance of foreign key constraints teknokrat
• 17:26   Re: performance of foreign key constraints Andrew Sullivan
• 17:28   Re: performance of foreign key constraints Stephan Szabo
• 17:43   Re: Simple queries take forever to run Michael Guerin
• 18:00   Re: Queries sometimes take 1000 times the normal time Anders K. Pedersen
• 18:17   Re: Queries sometimes take 1000 times the normal time Anders K. Pedersen
• 18:17   Re: The results of my PostgreSQL/filesystem performance tests Al Hulaton
• 18:22   Re: performance of foreign key constraints teknokrat
• 18:23   Re: The results of my PostgreSQL/filesystem performance tests Sean Chittenden
• 18:24   Re: Queries sometimes take 1000 times the normal time Anders K. Pedersen
• 18:29   Re: Hardware recommendations to scale to silly load Rod Taylor
• 18:33   Re: Queries sometimes take 1000 times the normal time Rod Taylor
• 18:49   Re: Simple queries take forever to run Stephan Szabo
• 18:51   Re: performance of foreign key constraints Stephan Szabo
• 18:57   Re: Queries sometimes take 1000 times the normal time Anders K. Pedersen
• 18:58   Re: performance of foreign key constraints Rod Taylor
• 19:16   Re: The results of my PostgreSQL/filesystem performance Bill Moran
• 19:22   Re: performance of foreign key constraints teknokrat
• 19:31   Re: The results of my PostgreSQL/filesystem performance tests Sean Chittenden
• 21:17   opinion on RAID choice Vivek Khera
• 21:18   Re: The results of my PostgreSQL/filesystem performance tests Vivek Khera
• 21:27   Re: The results of my PostgreSQL/filesystem performance tests Vivek Khera
• 21:28   Re: opinion on RAID choice scott.marlowe
• 21:55   Re: The results of my PostgreSQL/filesystem performance scott.marlowe
• 22:03   Re: Simple queries take forever to run Michael Guerin
• 22:10   Re: Queries sometimes take 1000 times the normal time scott.marlowe
• 22:22   Re: The results of my PostgreSQL/filesystem performance tests Sean Chittenden

29 August 2003

• 00:11   bad estimates / non-scanning aggregates Ken Geis
• 00:50   Re: Queries sometimes take 1000 times the normal time Anders K. Pedersen
• 01:13   Taking another shot at the PostgreSQL/filesystem benchmarks Bill Moran
• 01:20   Re: The results of my PostgreSQL/filesystem performance Bill Moran
• 01:37   Re: The results of my PostgreSQL/filesystem performance Christopher Kings-Lynne
• 01:57   Re: The results of my PostgreSQL/filesystem performance tests Christopher Kings-Lynne
• 02:00   Re: opinion on RAID choice Vivek Khera
• 02:15   Re: The results of my PostgreSQL/filesystem performance Bill Moran
• 02:45   Re: bad estimates / non-scanning aggregates Bruno Wolff III
• 02:51   Re: bad estimates / non-scanning aggregates Ken Geis
• 02:56   Re: bad estimates / non-scanning aggregates Bruno Wolff III
• 03:01   Re: bad estimates / non-scanning aggregates Ken Geis
• 03:32   Re: bad estimates / non-scanning aggregates Bruno Wolff III
• 03:40   PostgreSQL HDD Grow capacity Eko Pranoto
• 03:46   Re: bad estimates Ken Geis
• 03:59   Re: bad estimates Bruno Wolff III
• 04:09   Re: bad estimates Ken Geis
• 04:19   Re: bad estimates Bruno Wolff III
• 04:24   Re: opinion on RAID choice scott.marlowe
• 06:50   Indexing question Alexander Priem
• 07:01   Re: bad estimates Ken Geis
• 07:03   Re: Indexing question Christopher Kings-Lynne
• 07:04   Re: Indexing question Tomasz Myrta
• 07:22   Re: Hardware recommendations to scale to silly load William Yu
• 07:27   Re: Hardware recommendations to scale to silly load Christopher Kings-Lynne
• 07:47   Re: Indexing question Alexander Priem
• 07:57   Re: bad estimates Ken Geis
• 07:59   Re: Indexing question Tomasz Myrta
• 08:10   Re: bad estimates Ken Geis
• 08:11   Re: Indexing question Christopher Kings-Lynne
• 08:11   Re: bad estimates Christopher Kings-Lynne
• 08:16   Re: Hardware recommendations to scale to silly load Shridhar Daithankar
• 08:17   Re: bad estimates Ken Geis
• 08:28   Re: Queries sometimes take 1000 times the normal time Shridhar Daithankar
• 08:39   Re: Indexing question Alexander Priem
• 08:57   Re: Indexing question Tomasz Myrta
• 09:07   Re: Indexing question Alexander Priem
• 12:05   Re: Hardware recommendations to scale to silly load Ron Johnson
• 12:50   Force table to be permanently in cache? Fabian Kreitner
• 12:53   Re: bad estimates Jeff
• 13:55   PL/pgSQL functions - text / varchar - havy performance issue?! Oliver Siegmar
• 14:00   Re: Indexing question Tom Lane
• 14:05   Re: Hardware recommendations to scale to silly load Andrew Sullivan
• 14:35   Re: Force table to be permanently in cache? Andrew Sullivan
• 14:47   Re: PL/pgSQL functions - text / varchar - havy performance Bill Moran
• 15:02   Re: PL/pgSQL functions - text / varchar - havy performance Andrew Sullivan
• 15:02   Re: PL/pgSQL functions - text / varchar - havy performance issue?! Oliver Siegmar
• 15:03   Re: bad estimates Stephan Szabo
• 15:12   Re: Indexing question Alexander Priem
• 15:35   Re: PL/pgSQL functions - text / varchar - havy performance Bill Moran
• 15:54   Re: PL/pgSQL functions - text / varchar - havy performance Andrew Sullivan
• 16:07   Re: bad estimates Ken Geis
• 16:18   Re: PL/pgSQL functions - text / varchar - havy performance Tom Lane
• 16:27   2.4 v/s 2.6 again. Shridhar Daithankar
• 16:37   Re: bad estimates Sean Chittenden
• 16:52   Re: Hardware recommendations to scale to silly load William Yu
• 16:59   Re: Indexing question Richard Ellis
• 17:00   Re: bad estimates Ken Geis
• 17:04   Re: bad estimates Sean Chittenden
• 17:20   sourcecode for newly release eRServer? george young
• 17:32   Re: Hardware recommendations to scale to silly load Ron Johnson
• 18:51   Re: sourcecode for newly release eRServer? Andrew Sullivan
• 21:00   SQL performance problems Rhaoni Chiu Pereira
• 22:04   Re: SQL performance problems Tom Lane

30 August 2003

• 00:40   Re: Indexing question Rudi Starcevic
• 02:33   Re: The results of my PostgreSQL/filesystem performance tests Bruce Momjian
• 02:35   Re: The results of my PostgreSQL/filesystem performance tests Bruce Momjian
• 02:45   Re: Hardware recommendations to scale to silly load Bruce Momjian
• 02:49   Re: bad estimates Bruno Wolff III
• 04:25   Re: Tests Bruce Momjian
• 04:51   Re: sourcecode for newly release eRServer? Christopher Kings-Lynne
• 05:05   Re: bad estimates Ken Geis
• 05:21   Re: Hardware recommendations to scale to silly load Ron Johnson
• 12:15   Selecting random rows efficiently Richard Jones
• 13:09   Re: Selecting random rows efficiently Jeff
• 13:32   Re: Selecting random rows efficiently Richard Jones
• 13:36   How to force Nested Loop plan? Rob Nagler
• 13:45   Re: bad estimates Ken Geis
• 13:58   Re: Hardware recommendations to scale to silly load Rod Taylor
• 14:02   Re: Selecting random rows efficiently Rod Taylor
• 14:04   Re: Selecting random rows efficiently Ron Johnson
• 14:36   Re: bad estimates Tom Lane
• 14:47   Re: Selecting random rows efficiently Tom Lane
• 15:02   Re: How to force Nested Loop plan? Tom Lane
• 15:14   Re: Selecting random rows efficiently Tom Lane
• 15:37   Re: Hardware recommendations to scale to silly load Matt Clark
• 15:37   Re: Hardware recommendations to scale to silly load Matt Clark
• 15:50   Re: How to force Nested Loop plan? Rob Nagler
• 16:19   Re: Selecting random rows efficiently Ron Johnson
• 16:20   Re: How to force Nested Loop plan? Tom Lane
• 16:34   Re: How to force Nested Loop plan? Ron Johnson
• 16:48   Re: PostgreSQL HDD Grow capacity Bruce Momjian
• 17:43   Re: Selecting random rows efficiently Russell Garrett
• 20:42   Re: How to force Nested Loop plan? Rob Nagler
• 21:28   Re: How to force Nested Loop plan? Ron Johnson
• 22:11   Re: How to force Nested Loop plan? Tom Lane

31 August 2003

• 00:09   Re: How to force Nested Loop plan? Rob Nagler
• 00:23   Re: How to force Nested Loop plan? Rob Nagler
• 22:16   Re: SQL performance problems Alberto Caso
• 23:13   Re: How to force Nested Loop plan? Tom Lane