Mailing lists [pgsql-performance]

1 July 2003

• 03:22   excessive disk access during query Toby Sargeant
• 07:45   slower with the time Juraj Porada
• 07:49   Re: slower with the time Shridhar Daithankar
• 08:08   Re: slower with the time Juraj Porada
• 08:18   Re: slower with the time Shridhar Daithankar
• 12:10   Version 7 question Hilary Forbes
• 12:17   Re: Version 7 question Michael Mattox
• 12:53   Re: Version 7 question Robert Treat
• 13:02   Re: Version 7 question Michael Mattox
• 13:03   Re: Version 7 question scott.marlowe
• 13:13   FW: Version 7 question Howard Oblowitz
• 13:32   Re: FW: Version 7 question scott.marlowe
• 13:43   Re: excessive disk access during query Tom Lane
• 13:55   Re: Version 7 question Michael Mattox
• 13:57   Effective Cache Size Howard Oblowitz
• 19:16   Re: Version 7 question scott.marlowe
• 19:17   Re: Version 7 question scott.marlowe
• 19:18   Re: Effective Cache Size scott.marlowe
• 19:30   Re: Effective Cache Size Manfred Koizar
• 19:48   Re: Effective Cache Size Shridhar Daithankar
• 20:02   Re: Version 7 question Manfred Koizar

2 July 2003

• 01:25   Re: Version 7 question Christopher Kings-Lynne
• 10:24   Re: How to optimize monstrous query, sorts instead of Michael Mattox
• 10:28   Re: How to optimize monstrous query, sorts instead of Michael Mattox
• 12:45   Re: How to optimize monstrous query, sorts instead of Rod Taylor
• 12:51   Re: How to optimize monstrous query, sorts instead of Rod Taylor
• 13:46   Re: How to optimize monstrous query, sorts instead of Michael Mattox

3 July 2003

• 16:25   Re: raise or lower transaction timeout? Paul Thomas
• 16:52   Re: How to optimize monstrous query, sorts instead of Rod Taylor
• 19:48   Moving postgresql.conf tunables into 2003... Sean Chittenden
• 20:25   Re: Moving postgresql.conf tunables into 2003... Rod Taylor
• 20:26   Re: Moving postgresql.conf tunables into 2003... scott.marlowe
• 20:28   Re: Moving postgresql.conf tunables into 2003... Michael Mattox
• 20:32   Re: Moving postgresql.conf tunables into 2003... Ron
• 20:39   Re: Moving postgresql.conf tunables into 2003... Tom Lane
• 21:33   Re: Moving postgresql.conf tunables into 2003... Brian Hirt
• 23:24   Re: Moving postgresql.conf tunables into 2003... Sean Chittenden
• 23:25   Re: Moving postgresql.conf tunables into 2003... Sean Chittenden
• 23:32   Re: Moving postgresql.conf tunables into 2003... Sean Chittenden

4 July 2003

• 00:09   Re: Moving postgresql.conf tunables into 2003... Sean Chittenden
• 01:57   Re: Moving postgresql.conf tunables into 2003... Tom Lane
• 02:39   Re: Moving postgresql.conf tunables into 2003... Josh Berkus
• 03:14   Re: Moving postgresql.conf tunables into 2003... Tom Lane
• 03:52   Re: Moving postgresql.conf tunables into 2003... Tom Lane
• 10:43   PostgreSQL vs. MySQL Rafal Kedziorski
• 11:08   Re: PostgreSQL vs. MySQL Achilleus Mantzios
• 11:12   Re: PostgreSQL vs. MySQL Richard Huxton
• 12:28   Re: PostgreSQL vs. MySQL Brian Tarbox
• 12:29   Re: Moving postgresql.conf tunables into 2003... Rod Taylor
• 12:36   Re: PostgreSQL vs. MySQL Michael Mattox
• 12:41   Re: PostgreSQL vs. MySQL Brian Tarbox
• 12:46   Re: PostgreSQL vs. MySQL Michael Mattox
• 12:54   Re: PostgreSQL vs. MySQL Shridhar Daithankar
• 12:54   Re: PostgreSQL vs. MySQL Shridhar Daithankar
• 13:11   Re: PostgreSQL vs. MySQL Rod Taylor
• 13:21   Re: PostgreSQL vs. MySQL Shridhar Daithankar
• 13:26   Re: can multiple vacuums gain speed? Shridhar Daithankar
• 13:45   Re: PostgreSQL vs. MySQL Rod Taylor
• 13:50   Re: PostgreSQL vs. MySQL Christopher Kings-Lynne
• 13:59   Re: PostgreSQL vs. MySQL Tom Lane
• 14:09   Re: PostgreSQL vs. MySQL Brian Tarbox
• 14:22   Re: PostgreSQL vs. MySQL Shridhar Daithankar
• 14:23   Re: PostgreSQL vs. MySQL Tom Lane
• 14:27   Re: PostgreSQL vs. MySQL Andrew Sullivan
• 14:33   Re: PostgreSQL vs. MySQL Rod Taylor
• 14:35   Re: PostgreSQL vs. MySQL Michael Mattox
• 14:36   Re: PostgreSQL vs. MySQL Tom Lane
• 14:50   Re: PostgreSQL vs. MySQL Shridhar Daithankar
• 14:56   Re: PostgreSQL vs. MySQL Rafal Kedziorski
• 15:05   Re: PostgreSQL vs. MySQL Rod Taylor
• 15:19   Re: PostgreSQL vs. MySQL Shridhar Daithankar
• 15:26   Re: PostgreSQL vs. MySQL Andrew Sullivan
• 15:29   Re: PostgreSQL vs. MySQL Shridhar Daithankar
• 15:43   Re: PostgreSQL vs. MySQL Kevin Schroeder
• 16:08   Re: PostgreSQL vs. MySQL Brian Tarbox
• 16:23   Re: PostgreSQL vs. MySQL Bjoern Metzdorf
• 16:40   Re: PostgreSQL vs. MySQL Kevin Schroeder
• 17:00   Re: [pgsql-advocacy] About the default performance Josh Berkus
• 17:06   Re: PostgreSQL vs. MySQL Stephan Szabo
• 17:08   Re: PostgreSQL vs. MySQL Andrew Sullivan
• 17:16   Re: PostgreSQL vs. MySQL Josh Berkus
• 17:21   Strange result: UNIX vs. TCP/IP sockets Andrew Sullivan
• 17:36   Re: Moving postgresql.conf tunables into 2003... Tom Lane
• 17:37   Re: Strange result: UNIX vs. TCP/IP sockets The Hermit Hacker
• 17:55   Re: Strange result: UNIX vs. TCP/IP sockets Vincent van Leeuwen
• 18:07   Re: Strange result: UNIX vs. TCP/IP sockets Rod Taylor
• 18:07   Re: PostgreSQL vs. MySQL Arjen van der Meijden
• 18:15   Re: PostgreSQL vs. MySQL Arjen van der Meijden
• 18:28   Re: PostgreSQL vs. MySQL Andrew Sullivan
• 18:40   Re: PostgreSQL vs. MySQL Josh Berkus
• 19:19   Re: PostgreSQL vs. MySQL Tom Lane
• 19:22   Re: PostgreSQL vs. MySQL Josh Berkus
• 19:29   Re: PostgreSQL vs. MySQL Rod Taylor
• 21:11   Re: PostgreSQL vs. MySQL Brian Tarbox
• 21:20   Re: Strange result: UNIX vs. TCP/IP sockets Andrew Sullivan
• 21:47   Re: Strange result: UNIX vs. TCP/IP sockets Tom Lane
• 22:26   Re: PostgreSQL vs. MySQL Bjoern Metzdorf

5 July 2003

• 18:32   Re: PostgreSQL vs. MySQL Grega Bremec
• 20:58   Re: Strange result: UNIX vs. TCP/IP sockets Andrew Sullivan
• 21:05   Re: Moving postgresql.conf tunables into 2003... Sean Chittenden
• 21:13   Re: Moving postgresql.conf tunables into 2003... Sean Chittenden
• 22:59   Re: Moving postgresql.conf tunables into 2003... Josh Berkus
• 23:40   Re: PostgreSQL vs. MySQL Hilmar Lapp

6 July 2003

• 00:13   Re: PostgreSQL vs. MySQL Hannu Krosing
• 00:24   Re: Moving postgresql.conf tunables into 2003... Sean Chittenden
• 01:32   Re: Moving postgresql.conf tunables into 2003... Josh Berkus
• 04:55   Extreme high load averages Martin Foster
• 07:49   Re: Extreme high load averages Richard Huxton
• 09:45   Re: Extreme high load averages Shridhar Daithankar
• 10:27   Re: Extreme high load averages Martin Foster
• 10:32   Re: Extreme high load averages Martin Foster
• 10:36   Re: Extreme high load averages Shridhar Daithankar
• 14:12   Another POC initdb patch Shridhar Daithankar
• 15:20   Re: Extreme high load averages Tom Lane
• 15:26   Re: [PATCHES] Another POC initdb patch Tom Lane
• 20:16   Re: Extreme high load averages Martin Foster
• 20:29   Re: Extreme high load averages Martin Foster

7 July 2003

• 02:11   Re: Moving postgresql.conf tunables into 2003... Matthew Nuzum
• 02:33   Re: Moving postgresql.conf tunables into 2003... Matthew Nuzum
• 03:19   Re: Moving postgresql.conf tunables into 2003... Michael Pohl
• 03:55   Re: Moving postgresql.conf tunables into 2003... Martin Foster
• 04:24   Re: Extreme high load averages Martin Foster
• 07:20   Re: Moving postgresql.conf tunables into 2003... Matthew Hixson
• 09:09   Re: Extreme high load averages Dennis Björklund
• 09:23   Re: Moving postgresql.conf tunables into 2003... Andrew Sullivan
• 13:13   Re: Moving postgresql.conf tunables into 2003... Matthew Nuzum
• 13:23   Re: Moving postgresql.conf tunables into 2003... Michael Mattox
• 13:31   Re: Moving postgresql.conf tunables into 2003... Tom Lane
• 14:18   Optimizer differences between 7.2 and 7.3 Jeff Boes
• 14:40   Re: Optimizer differences between 7.2 and 7.3 Richard Huxton
• 20:58   optimizer picks smaller table to drive nested loops? Greg Stark
• 21:00   Re: Extreme high load averages scott.marlowe
• 21:03   Re: PostgreSQL vs. MySQL scott.marlowe
• 21:20   Re: optimizer picks smaller table to drive nested loops? Randy Neumann
• 21:20   Re: PostgreSQL vs. MySQL scott.marlowe
• 21:31   Re: Moving postgresql.conf tunables into 2003... Chris Travers
• 21:31   Re: [pgsql-advocacy] About the default performance scott.marlowe
• 21:33   Re: PostgreSQL vs. MySQL Brian Tarbox
• 21:41   Re: Moving postgresql.conf tunables into 2003... Jim C. Nasby
• 23:30   Re: Extreme high load averages Martin Foster

8 July 2003

• 00:47   Re: Extreme high load averages Matthew Nuzum
• 15:33   Re: Extreme high load averages scott.marlowe
• 19:46   Config file problem Hilary Forbes
• 20:55   Re: Strange result: UNIX vs. TCP/IP sockets Andrew Sullivan

9 July 2003

• 00:28   Efficiency of timestamps Martin Foster
• 00:58   Re: Efficiency of timestamps Stephan Szabo
• 01:12   Re: Config file problem Christopher Kings-Lynne
• 01:37   Re: Efficiency of timestamps Martin Foster
• 02:49   Re: Efficiency of timestamps Stephan Szabo
• 04:23   Re: Efficiency of timestamps Martin Foster
• 05:01   Re: Efficiency of timestamps Stephan Szabo
• 06:51   Re: Efficiency of timestamps Martin Foster
• 17:30   Some very weird behaviour.... Chris Bowlby
• 17:43   Re: Some very weird behaviour.... Rod Taylor
• 18:29   Re: Moving postgresql.conf tunables into 2003... Kaarel
• 19:49   Re: Moving postgresql.conf tunables into 2003... scott.marlowe
• 21:46   Re: Moving postgresql.conf tunables into 2003... Martin Foster
• 23:31   Re: Moving postgresql.conf tunables into 2003... Sean Chittenden

10 July 2003

• 00:25   Re: Moving postgresql.conf tunables into 2003... Martin Foster
• 01:46   Can you help me? Chris_Wu
• 01:47   plpgsql vs. SQL performance (again) Michael Pohl
• 05:38   Re: [NOVICE] Extreme high load averages Martin Foster
• 06:29   Re: [NOVICE] Extreme high load averages Shridhar Daithankar
• 06:55   Re: [NOVICE] Extreme high load averages Martin Foster
• 07:10   Re: [NOVICE] Extreme high load averages Shridhar Daithankar
• 10:10   Re: Can you help me? Oliver Scheit
• 23:54   Re: [NOVICE] Extreme high load averages Sean Chittenden

11 July 2003

• 00:44   Dual Xeon + HW RAID question alexandre arruda paes :: aldeia digital
• 03:14   Re: [NOVICE] Extreme high load averages Martin Foster
• 05:56   Re: Some very weird behaviour.... Chris Bowlby
• 06:28   pre-Vacuum statistics Rich Cullingford
• 07:10   force the use of a particular index Scott Cain
• 16:57   Postgresql General Bits issue Shridhar Daithankar
• 16:58   Re: force the use of a particular index Rod Taylor
• 17:14   Re: force the use of a particular index Rod Taylor
• 17:27   Re: force the use of a particular index Scott Cain
• 17:57   Re: Dual Xeon + HW RAID question Rod Taylor
• 18:05   Re: pre-Vacuum statistics Rod Taylor
• 18:35   Re: force the use of a particular index Rod Taylor
• 19:44   Re: [NOVICE] Extreme high load averages Martin Foster
• 19:45   Re: force the use of a particular index Tom Lane
• 19:48   Re: force the use of a particular index Scott Cain
• 21:39   Re: force the use of a particular index Scott Cain

12 July 2003

• 03:07   Re: force the use of a particular index Scott Cain
• 03:28   Re: force the use of a particular index Rod Taylor
• 03:53   Re: force the use of a particular index Scott Cain
• 05:30   Re: force the use of a particular index Tom Lane
• 18:25   Re: Dual Xeon + HW RAID question Nikolaus Dilger
• 21:09   [OT] Such incredible h/w (was Re: Dual Xeon + HW RAID question) Ron Johnson

13 July 2003

• 00:18   Re: [NOVICE] Optimizer Parameters Martin Foster
• 02:14   Re: [NOVICE] Optimizer Parameters Tom Lane
• 06:36   Pgsql - Red Hat Linux - VS MySQL VS MSSQL Balazs Wellisch
• 10:09   Re: Tuning PostgreSQL Shridhar Daithankar
• 10:20   Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Shridhar Daithankar
• 12:18   Help disk-pages lax@interfree.it ()
• 17:37   Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Joe Conway
• 18:04   Improving a simple query? Steve Wampler
• 19:09   Re: Improving a simple query? Richard Huxton
• 19:39   Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Balazs Wellisch
• 19:42   Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Balazs Wellisch
• 19:53   Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Balazs Wellisch
• 19:54   Re: Improving a simple query? nolan@celery.tssi.com
• 20:04   Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Balazs Wellisch
• 20:31   Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Joe Conway
• 20:45   Re: Improving a simple query? Steve Wampler
• 22:31   Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Jim C. Nasby

14 July 2003

• 00:02   Re: Improving a simple query? Hannu Krosing
• 01:23   Re: Improving a simple query? nolan@celery.tssi.com
• 02:31   Re: Improving a simple query? Chris Bowlby
• 02:33   Re: Improving a simple query? Chris Bowlby
• 03:19   How to configure the postgresql.conf files Chris_Wu
• 03:34   Re: How to configure the postgresql.conf files Rudi Starcevic
• 03:45   Re: How to configure the postgresql.conf files Rudi Starcevic
• 06:36   Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Shridhar Daithankar
• 11:18   Re: Dual Xeon + HW RAID question Andrew Sullivan
• 11:43   Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Andrew Sullivan
• 11:44   Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Andrew Sullivan
• 13:38   Re: [SQL] Replacing a simple nested query? Steve Wampler
• 14:07   Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL Paul Thomas
• 14:27   Tunning FreeeBSD and PostgreSQL Stephen Howie
• 16:02   Re: Tunning FreeeBSD and PostgreSQL Richard Huxton
• 16:52   Java Out-of-memory errors on attempts to read tables with millions of rows Rich Cullingford
• 17:07   Re: Java Out-of-memory errors on attempts to read tables with millions of rows Evil Azrael
• 17:19   Re: Tunning FreeeBSD and PostgreSQL Stephen Howie
• 17:52   Sanity check requested Nick Fankhauser
• 18:00   Re: Tunning FreeeBSD and PostgreSQL Nick Fankhauser
• 18:04   Re: optimizer picks smaller table to drive nested loops? Tom Lane
• 18:40   Re: optimizer picks smaller table to drive nested loops? Greg Stark
• 20:58   Re: optimizer picks smaller table to drive nested loops? Tom Lane
• 22:44   Re: optimizer picks smaller table to drive nested loops? Tom Lane

15 July 2003

• 05:41   Re: Sanity check requested Shridhar Daithankar
• 16:09   Re: [GENERAL] Query Optimisation Stephan Szabo
• 16:44   Re: Tunning FreeeBSD and PostgreSQL Vivek Khera
• 17:10   Re: Tunning FreeeBSD and PostgreSQL Stephen Howie
• 18:04   Re: Tunning FreeeBSD and PostgreSQL Vivek Khera
• 22:10   Re: max_fsm_pages question Josh Berkus

16 July 2003

• 14:20   Bad performance using ODBC Albert Cervera Areny
• 14:39   Re: Bad performance using ODBC Tom Lane

17 July 2003

• 02:57   Hardware performance Balazs Wellisch
• 04:25   Re: Hardware performance Roman Fail
• 04:53   Re: Hardware performance Joe Conway
• 07:58   Re: Hardware performance Hannu Krosing
• 08:58   index / sequential scan problem Fabian Kreitner
• 09:15   Re: index / sequential scan problem Shridhar Daithankar
• 10:12   Re: index / sequential scan problem Paul Thomas
• 10:14   Re: Hardware performance Vincent van Leeuwen
• 11:10   Re: index / sequential scan problem Fabian Kreitner
• 11:11   Re: index / sequential scan problem Fabian Kreitner
• 11:16   Re: index / sequential scan problem Shridhar Daithankar
• 12:34   Re: index / sequential scan problem Paul Thomas
• 12:48   Re: index / sequential scan problem Fabian Kreitner
• 12:52   Re: index / sequential scan problem Shridhar Daithankar
• 14:10   Re: index / sequential scan problem Jord Tanner
• 14:38   Re: index / sequential scan problem Paul Thomas
• 14:45   Relation of indices to ANALYZE Bill Moran
• 14:59   Re: Hardware performance Joe Conway
• 15:05   Re: Hardware performance Adam Witney
• 15:10   Re: Hardware performance Joe Conway
• 15:22   Re: Hardware performance Adam Witney
• 15:42   Re: Sanity check requested Nick Fankhauser
• 15:57   Re: Sanity check requested Josh Berkus
• 16:11   Re: Hardware performance Jean-Luc Lachance
• 16:12   Re: Sanity check requested Nick Fankhauser
• 16:13   Re: Relation of indices to ANALYZE Richard Huxton
• 16:14   Re: [ODBC] Bad performance using ODBC Albert Cervera Areny
• 16:23   Re: Hardware performance Joe Conway
• 16:30   Re: Hardware performance Joe Conway
• 16:41   Re: Sanity check requested Joe Conway
• 16:42   Re: Hardware performance Jean-Luc Lachance
• 16:54   Re: Hardware performance Jord Tanner
• 18:02   Re: index / sequential scan problem Tom Lane
• 18:12   Re: index / sequential scan problem Tom Lane
• 18:26   Re: Relation of indices to ANALYZE Tom Lane
• 18:41   Re: Hardware performance Andrew Sullivan
• 18:50   Re: Relation of indices to ANALYZE Bill Moran
• 18:55   Re: Hardware performance Magnus Hagander
• 19:11   Table clustering -- useful, or not? Josh Berkus

18 July 2003

• 03:23   Re: Hardware performance Robert Creager
• 04:45   Re: index / sequential scan problem Fabian Kreitner
• 05:16   Re: index / sequential scan problem Fabian Kreitner
• 05:27   Re: index / sequential scan problem Dennis Björklund
• 06:37   Re: Sanity check requested Shridhar Daithankar
• 06:55   Clearing rows periodically Martin Foster
• 07:03   Re: Sanity check requested Ang Chin Han
• 07:41   Re: Clearing rows periodically Paul Thomas
• 10:14   Re: Hardware performance Ron Johnson
• 10:18   Re: Hardware performance Ron Johnson
• 11:33   Re: Clearing rows periodically Andrew Sullivan
• 12:51   Yet another slow join query.. Rajesh Kumar Mallah
• 13:24   Re: index / sequential scan problem Tom Lane
• 13:25   Re: Hardware performance Magnus Hagander
• 13:30   Re: Clearing rows periodically Tom Lane
• 14:20   Re: index / sequential scan problem scott.marlowe
• 14:32   File systems (RE: Sanity check requested) Nick Fankhauser
• 15:51   Re: Sanity check requested scott.marlowe
• 16:00   Re: Sanity check requested Vincent van Leeuwen
• 16:09   Re: Yet another slow join query.. Stephan Szabo
• 16:18   Re: Sanity check requested Oliver Scheit
• 16:28   Re: Sanity check requested Vincent van Leeuwen
• 16:40   Re: Sanity check requested Oliver Scheit
• 17:40   Re: Yet another slow join query.. [ SOLVED ] 
• 18:43   Re: index / sequential scan problem Dennis Björklund
• 19:03   Re: Sanity check requested Nick Fankhauser
• 19:07   Re: Sanity check requested Josh Berkus
• 19:11   Re: Sanity check requested Rod Taylor
• 21:48   Re: File systems (RE: Sanity check requested) Tom Lane

19 July 2003

• 21:21   storing files in Postgres Matthew Hixson
• 21:23   Poor delete performance AFTER vacuum analyze Jeremy M. Guthrie

20 July 2003

• 06:17   Re: Poor delete performance AFTER vacuum analyze Tom Lane
• 06:34   Re: Poor delete performance AFTER vacuum analyze Dennis Björklund
• 19:20   Re: Moving postgresql.conf tunables into 2003... Bruce Momjian
• 19:21   Re: Moving postgresql.conf tunables into 2003... Bruce Momjian
• 23:23   Re: PostgreSQL vs. MySQL Bruce Momjian
• 23:24   Re: PostgreSQL vs. MySQL Bruce Momjian
• 23:51   Re: Poor delete performance AFTER vacuum analyze Jeremy M. Guthrie

21 July 2003

• 02:49   Re: [pgsql-advocacy] About the default performance Bruce Momjian
• 05:09   Re: Poor delete performance AFTER vacuum analyze Tom Lane
• 05:30   Re: Dual Xeon + HW RAID question SZUCS Gábor
• 05:59   Re: ugly query slower in 7.3, even slower after vacuum full analyze SZŰCS Gábor
• 08:29   Re: Optimizer differences between 7.2 and 7.3 SZUCS Gábor
• 08:30   Tuning PostgreSQL Alexander Priem
• 08:51   Re: Tuning PostgreSQL Shridhar Daithankar
• 09:32   Re: Tuning PostgreSQL Shridhar Daithankar
• 09:40   Re: Tuning PostgreSQL Alexander Priem
• 10:16   Re: Tuning PostgreSQL Ang Chin Han
• 10:32   Re: Tuning PostgreSQL Shridhar Daithankar
• 11:24   Re: Tuning PostgreSQL Ang Chin Han
• 11:43   Re: Tuning PostgreSQL Shridhar Daithankar
• 12:11   Re: Tuning PostgreSQL Alexander Priem
• 12:23   Re: Tuning PostgreSQL Shridhar Daithankar
• 12:52   Re: Tuning PostgreSQL Alexander Priem
• 13:42   Re: Optimizer differences between 7.2 and 7.3 Tom Lane
• 13:45   Re: Tuning PostgreSQL Roman Fail
• 13:59   Re: Tuning PostgreSQL Alexander Priem
• 16:08   Re: Tuning PostgreSQL Josh Berkus
• 16:32   Re: Tuning PostgreSQL Vincent van Leeuwen
• 18:06   Re: Dual Xeon + HW RAID question alexandre paes :: aldeia digital
• 19:07   Re: Dual Xeon + HW RAID question Bruce Momjian
• 19:47   Re: Help disk-pages Bruce Momjian
• 19:52   Commenting postgresql.conf Josh Berkus
• 20:05   Mass file imports Greg Spiegelberg
• 20:27   Re: Commenting postgresql.conf scott.marlowe
• 20:41   Re: Tunning FreeeBSD and PostgreSQL Bruce Momjian
• 20:50   PGAvd Josh Berkus
• 20:54   Re: PGAvd Bruce Momjian
• 21:58   Re: PGAvd Christopher Browne

22 July 2003

• 07:03   Re: Tuning PostgreSQL Alexander Priem
• 07:23   Re: Dual Xeon + HW RAID question Mindaugas Riauba
• 09:44   Re: Tuning PostgreSQL Vincent van Leeuwen
• 10:12   Re: Tuning PostgreSQL Ron Johnson
• 13:54   Re: Tuning PostgreSQL Alexander Priem
• 14:05   Re: Tuning PostgreSQL Alexander Priem
• 14:12   Re: Tuning PostgreSQL Andrew Sullivan
• 14:25   Re: Tunning FreeeBSD and PostgreSQL Vivek Khera
• 14:38   Re: Tuning PostgreSQL Ron Johnson
• 14:41   Re: Tuning PostgreSQL Jim C. Nasby
• 15:00   Re: Tuning PostgreSQL Alexander Priem
• 15:36   Re: Tuning PostgreSQL Ron Johnson
• 16:13   Re: Tuning PostgreSQL Vivek Khera
• 16:26   Re: Dual Xeon + HW RAID question Bruce Momjian
• 17:07   Re: Tuning PostgreSQL Bruno Wolff III
• 17:10   Wrong plan or what ? Mendola Gaetano
• 17:11   Re: Dual Xeon + HW RAID question SZUCS Gábor
• 17:29   Re: Tunning FreeeBSD and PostgreSQL Bruce Momjian
• 17:32   Re: Tuning PostgreSQL scott.marlowe
• 17:35   Re: Dual Xeon + HW RAID question Jord Tanner
• 17:38   Re: Dual Xeon + HW RAID question Bruce Momjian
• 17:39   Re: Dual Xeon + HW RAID question Bruce Momjian
• 17:41   Re: Wrong plan or what ? Josh Berkus
• 17:48   Re: Wrong plan or what ? Mendola Gaetano
• 17:54   Re: Dual Xeon + HW RAID question Jord Tanner
• 17:56   Re: Wrong plan or what ? Mendola Gaetano
• 17:58   Re: Wrong plan or what ? Josh Berkus
• 18:18   Re: Tunning FreeeBSD and PostgreSQL Vivek Khera
• 18:35   Re: Wrong plan or what ? Mendola Gaetano
• 18:51   Re: Dual Xeon + HW RAID question Bruce Momjian
• 19:18   Re: Dual Xeon + HW RAID question Jord Tanner

23 July 2003

• 00:38   One table or many tables for data set Castle, Lindsay
• 00:48   slow table updates Reece Hart
• 00:53   Re: One table or many tables for data set Rod Taylor
• 01:04   Re: One table or many tables for data set Joe Conway
• 01:25   Re: One table or many tables for data set Castle, Lindsay
• 01:38   Re: One table or many tables for data set Joe Conway
• 01:49   Re: One table or many tables for data set Rod Taylor
• 01:53   Re: One table or many tables for data set Castle, Lindsay
• 02:10   Re: One table or many tables for data set Rod Taylor
• 02:14   Re: One table or many tables for data set Castle, Lindsay
• 09:17   Re: slow table updates Richard Huxton
• 10:29   factoring problem with view in 7.3.3 Rajesh Kumar Mallah
• 10:43   Re: [GENERAL] Performance hit of foreign key constraints? Shridhar Daithankar
• 14:13   Re: factoring problem with view in 7.3.3 Richard Huxton
• 14:29   different query plan for same select Jörg Schulz
• 15:21   Re: different query plan for same select Tom Lane
• 15:43   Re: factoring problem with view in 7.3.3 Tom Lane
• 16:36   Re: factoring problem with view in 7.3.3 [ PARTIALLY SOLVED ] 
• 16:47   Re: factoring problem with view in 7.3.3 [ PARTIALLY SOLVED ] Tom Lane
• 17:20   Re: factoring problem with view in 7.3.3 [ SOLVED ] 
• 17:44   Re: slow table updates Reece Hart
• 18:07   Re: slow table updates Reece Hart
• 18:38   Re: slow table updates Guthrie, Jeremy

24 July 2003

• 06:10   Re: different query plan for same select Jörg Schulz
• 12:43   hardware performance and some more Kasim Oztoprak
• 13:52   Re: hardware performance and some more Shridhar Daithankar
• 15:22   Re: hardware performance and some more Kasim Oztoprak
• 15:29   Re: hardware performance and some more Roman Fail
• 15:51   Re: hardware performance and some more Kasim Oztoprak
• 16:43   Re: hardware performance and some more William Yu
• 18:36   Re: Tuning PostgreSQL Greg Stark
• 20:09   Re: hardware performance and some more Ron Johnson
• 20:17   Re: Tuning PostgreSQL Ron Johnson

25 July 2003

• 13:34   Re: hardware performance and some more Kasim Oztoprak
• 13:57   Re: hardware performance and some more Shridhar Daithankar
• 14:01   Re: hardware performance and some more Shridhar Daithankar
• 14:19   Re: hardware performance and some more Ron Johnson
• 15:27   Re: hardware performance and some more Kasim Oztoprak
• 15:30   Re: hardware performance and some more Shridhar Daithankar
• 16:14   Re: hardware performance and some more Josh Berkus
• 16:49   index questions Franco Bruno Borghesi
• 17:13   Re: hardware performance and some more Ron Johnson
• 17:21   Re: index questions Ron Johnson
• 17:29   Re: index questions Josh Berkus
• 18:30   Re: index questions Franco Bruno Borghesi

26 July 2003

• 00:45   Wrong rows number expected Mendola Gaetano
• 08:38   Re: Tuning PostgreSQL Andrew McMillan
• 09:52   SUBSCRIBE Rauf Kuliyev
• 10:18   Re: Tuning PostgreSQL Arjen van der Meijden
• 14:12   Re: Tuning PostgreSQL Tom Lane
• 21:08   Re: Tuning PostgreSQL Balazs Wellisch

27 July 2003

• 08:39   Mapping Database completly into memory Daniel Migowski
• 08:47   Mapping a database completly into Memory Daniel Migowski
• 12:59   Query problem pginfo
• 13:25   RE : Query problem Bruno BAGUETTE
• 13:32   Re: RE : Query problem pginfo
• 14:25   Re: Query problem Rod Taylor
• 16:20   Re: Mapping a database completly into Memory Tom Lane

28 July 2003

• 04:15   Re: Mapping a database completly into Memory Josh Berkus
• 15:56   Re: Mapping a database completly into Memory Franco Bruno Borghesi
• 17:31   Re: Mapping a database completly into Memory Josh Berkus
• 17:42   Re: Mapping a database completly into Memory Tom Lane
• 17:57   Optimization Justin Long
• 18:32   Re: Optimization Nick Fankhauser
• 18:44   Re: Optimization Nick Fankhauser - Doxpop
• 19:27   Re: Optimization Nick Fankhauser
• 19:31   Re: Mapping a database completly into Memory Andrew Sullivan
• 19:33   Re: Mapping Database completly into memory scott.marlowe
• 19:34   Re: Optimization Josh Berkus
• 19:46   Re: Mapping a database completly into Memory Franco Bruno Borghesi
• 20:03   Re: Tuning PostgreSQL Josh Berkus
• 20:05   Re: Mapping a database completly into Memory Tom Lane
• 20:47   Re: Optimization Josh Berkus
• 21:29   Rebuild indexes Shankar K

29 July 2003

• 00:20   Re: Rebuild indexes Josh Berkus
• 02:30   Re: [ADMIN] Rebuild indexes Tom Lane
• 03:03   Re: [ADMIN] Rebuild indexes Shankar K
• 05:44   Why performance improvement on converting subselect to a function ? Rajesh Kumar Mallah
• 06:50   Re: Optimization Shridhar Daithankar
• 07:14   Re: Optimization Peter Childs
• 07:19   Re: Optimization Shridhar Daithankar
• 11:57   autovacuum Christopher Browne
• 12:03   Autovacuum Christopher Browne
• 12:29   Re: Autovacuum Shridhar Daithankar
• 14:09   Re: Why performance improvement on converting subselect to a function ? Tom Lane
• 15:23   Re: Mapping a database completly into Memory Vivek Khera
• 15:28   Re: Tuning PostgreSQL Vivek Khera
• 15:46   Re: Tuning PostgreSQL Ron Johnson
• 16:31   Re: Tuning PostgreSQL Will LaShell
• 16:35   Re: Tuning PostgreSQL scott.marlowe
• 16:47   Re: Why performance improvement on converting subselect Rajesh Kumar Mallah
• 18:08   Re: Tuning PostgreSQL Ron Johnson
• 19:35   Re: Tuning PostgreSQL scott.marlowe
• 19:52   Re: Tuning PostgreSQL Ron Johnson
• 20:24   Re: Tuning PostgreSQL scott.marlowe
• 20:38   Re: Tuning PostgreSQL Ron Johnson
• 21:32   Re: Why performance improvement on converting subselect to a function ? Tom Lane

30 July 2003

• 07:25   Re: Why performance improvement on converting subselect to a function ? Rajesh Kumar Mallah
• 13:53   Re: Why performance improvement on converting subselect to a function ? Tom Lane
• 13:57   Re: Why performance improvement on converting subselect to a function ? Shridhar Daithankar
• 14:45   Re: Tuning PostgreSQL, pt 2 Ron Johnson
• 16:02   Getting Started Guide? Josh Berkus
• 17:12   postgresql.conf scott.marlowe
• 17:34   Re: [SQL] function returning setof performance question Josh Berkus
• 17:37   Re: postgresql.conf Josh Berkus
• 18:33   Re: postgresql.conf Ron Johnson
• 18:34   Re: postgresql.conf Robert Treat
• 18:44   Re: postgresql.conf Josh Berkus
• 19:00   Re: postgresql.conf Ron
• 19:13   Re: postgresql.conf Josh Berkus
• 19:39   Re: Why performance improvement on converting subselect Rajesh Kumar Mallah
• 20:22   Re: postgresql.conf scott.marlowe
• 20:44   Re: postgresql.conf Josh Berkus
• 22:10   Re: Mapping a database completly into Memory Bruce Momjian
• 22:12   Re: Mapping a database completly into Memory Bruce Momjian

31 July 2003

• 03:21   Re: Why performance improvement on converting subselect Tom Lane
• 05:39   Possible problem with DOMAIN evaluation? Christopher Browne
• 05:45   Targeted CPU compilations Ron Johnson
• 12:12   Re: Possible problem with DOMAIN evaluation? Rod Taylor
• 14:30   Re: Mapping a database completly into Memory Vivek Khera
• 18:11   Help on my database performance Jianshuo Niu
• 18:44   Re: postgresql.conf cafweb
• 19:29   EXTERNAL storage and substring on long strings Scott Cain
• 19:35   Re: Help on my database performance Manfred Koizar
• 19:57   Re: Tuning PostgreSQL Vivek Khera
• 20:15   Re: Moving postgresql.conf tunables into 2003... Manfred Koizar
• 20:28   Re: EXTERNAL storage and substring on long strings Scott Cain
• 20:34   Re: Help on my database performance Jianshuo Niu
• 20:46   Re: EXTERNAL storage and substring on long strings Scott Cain
• 20:46   Re: EXTERNAL storage and substring on long strings Joe Conway
• 20:53   Re: EXTERNAL storage and substring on long strings Tom Lane
• 20:53   Odd performance results Medora Schauer
• 20:53   Odd explain estimate Jim C. Nasby
• 20:54   Re: EXTERNAL storage and substring on long strings Tom Lane
• 20:56   Re: EXTERNAL storage and substring on long strings Joe Conway
• 20:58   Re: EXTERNAL storage and substring on long strings Tom Lane
• 20:59   Re: Odd explain estimate Andrew Sullivan
• 21:06   Re: EXTERNAL storage and substring on long strings Joe Conway
• 21:10   Re: Odd performance results Tom Lane
• 21:11   Re: EXTERNAL storage and substring on long strings Scott Cain
• 21:21   Re: EXTERNAL storage and substring on long strings Ron Johnson
• 21:32   Re: Help on my database performance Manfred Koizar
• 21:32   Re: Odd performance results Medora Schauer
• 22:24   Views With Unions Christopher Browne
• 22:34   Re: Views With Unions Stephan Szabo
• 23:00   Re: Odd explain estimate Jim C. Nasby
• 23:52   Re: EXTERNAL storage and substring on long strings Scott Cain