Mailing lists [pgsql-performance]

1 August 2006

• 05:57   Are there any performance penalty for opposite edian platform combinations.... Guoping Zhang
• 06:19   Re: Performances with new Intel Core* processors Luke Lonergan
• 07:28   Re: Performances with new Intel Core* processors Florian Weimer
• 12:10   Re: Are there any performance penalty for opposite edian platform combinations.... Tom Lane
• 13:18   Query/database optimization Eugeny N Dzhurinsky
• 13:40   Re: Fwd: Savepoint performance Ernest Nishiseki
• 16:15   PITR performance overhead? George Pavlov
• 16:59   Re: PITR performance overhead? Bill Moran
• 17:26   Re: PostgreSQL scalability on Sun UltraSparc T1 Jim C. Nasby
• 17:49   Re: PostgreSQL scalability on Sun UltraSparc T1 Arjen van der Meijden
• 18:10   How to speed up this "translation" query? tlm
• 18:40   Re: How to speed up this "translation" query? Niklas Johansson
• 21:50   XFS filessystem for Datawarehousing Milen Kulev
• 22:19   FW: XFS filessystem for Datawarehousing -2 Milen Kulev
• 23:00   Re: XFS filessystem for Datawarehousing Milen Kulev
• 23:07   Re: sub select performance due to seq scans H Hale
• 23:47   Re: XFS filessystem for Datawarehousing J. Andrew Rogers

2 August 2006

• 00:42   Re: XFS filessystem for Datawarehousing Alvaro Herrera
• 01:17   Re: PITR performance overhead? Merlin Moncure
• 02:06   Re: XFS filessystem for Datawarehousing Mark Kirkwood
• 02:42   Re: XFS filessystem for Datawarehousing Luke Lonergan
• 02:44   Re: XFS filessystem for Datawarehousing -2 Luke Lonergan
• 03:15   Re: Query/database optimization Tom Lane
• 10:56   Re: Query/database optimization Eugeny N Dzhurinsky
• 12:17   Re: sub select performance due to seq scans H Hale
• 16:48   Re: sub select performance due to seq scans Scott Marlowe
• 21:00   Re: XFS filessystem for Datawarehousing Milen Kulev
• 21:26   Re: XFS filessystem for Datawarehousing Steve Poe
• 21:44   Re: XFS filessystem for Datawarehousing Milen Kulev
• 23:04   Re: XFS filessystem for Datawarehousing Chris Browne
• 23:34   Re: XFS filessystem for Datawarehousing Michael Stone

3 August 2006

• 04:05   Re: XFS filessystem for Datawarehousing Luke Lonergan
• 04:47   Re: RAID stripe size question Merlin Moncure
• 04:52   Re: RAID stripe size question Luke Lonergan
• 05:09   Re: Performances with new Intel Core* processors Denis Lussier
• 05:22   Re: PITR performance overhead? Denis Lussier
• 05:36   Re: XFS filessystem for Datawarehousing -2 Denis Lussier
• 07:11   Re: XFS filessystem for Datawarehousing Koth, Christian (DWBI)
• 07:17   Re: XFS filessystem for Datawarehousing Florian Weimer
• 09:41   Re: XFS filessystem for Datawarehousing Michael Stone
• 16:12   unsubscribe Wade Klaver
• 16:39   Re: Strange behaviour Tom Lane
• 19:14    Jim Nasby
• 19:19   Re: Steinar H. Gunderson
• 19:29   Re: Chris Hoover
• 19:44   Re: XFS filessystem for Datawarehousing Milen Kulev
• 19:49   Re: Ian Westmacott
• 19:56   Re: XFS filessystem for Datawarehousing -2 Milen Kulev
• 20:31   Re: Chris Hoover
• 20:36   Re: RAID stripe size question Merlin Moncure
• 20:57   Re: Ian Westmacott
• 21:04   Re: XFS filessystem for Datawarehousing -2 Chris Browne

4 August 2006

• 03:41   Re: XFS filessystem for Datawarehousing Luke Lonergan
• 07:37   Re: Partitioning / constrain exlusion not working with %-operator Martin Lesser
• 08:06   Re: RAID stripe size question Mikael Carneholm
• 20:13   Re: XFS filessystem for Datawarehousing -2 Denis Lussier
• 20:44   Re: XFS filessystem for Datawarehousing Jim C. Nasby
• 22:38   Query Plan - Bitmap Index Scan and Views Rusty Conover

5 August 2006

• 02:15   Re: Query Plan - Bitmap Index Scan and Views Tom Lane
• 02:57   Re: Query Plan - Bitmap Index Scan and Views Rusty Conover
• 03:27   Re: Query Plan - Bitmap Index Scan and Views Tom Lane

6 August 2006

• 16:54   7.3.2 pg_restore very slow Saranya Sivakumar

7 August 2006

• 07:59   High Context-Switches on Linux 8.1.4 Server Donald C. Sumbry ][
• 09:56   Re: 7.3.2 pg_restore very slow Richard Huxton
• 11:51   Re: Disk writes Markus Schaber
• 12:07   Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Markus Schaber
• 12:52   Re: High Context-Switches on Linux 8.1.4 Server Tom Lane
• 13:18   Re: PostgreSQL scalability on Sun UltraSparc T1 Markus Schaber
• 13:32   Re: sub select performance due to seq scans Markus Schaber
• 13:45   Re: PostgreSQL scalability on Sun UltraSparc T1 Arjen van der Meijden
• 15:35   Re: 7.3.2 pg_restore very slow Saranya Sivakumar
• 15:47   Re: High Context-Switches on Linux 8.1.4 Server Donald C. Sumbry ][
• 16:08   Re: 7.3.2 pg_restore very slow Saranya Sivakumar
• 16:17   Re: [NOVICE] 7.3.2 pg_restore very slow Richard Broersma Jr
• 16:55   Re: XFS filessystem for Datawarehousing Alvaro Herrera
• 17:26   Slow transfer speeds hansell baran
• 17:28   Re: [NOVICE] 7.3.2 pg_restore very slow Saranya Sivakumar
• 18:05   Re: Slow transfer speeds Scott Marlowe
• 18:25   Re: [NOVICE] 7.3.2 pg_restore very slow Markus Schaber
• 18:34   Re: High Context-Switches on Linux 8.1.4 Server Tom Lane
• 19:19   Re: [NOVICE] 7.3.2 pg_restore very slow Richard Broersma Jr
• 19:24   Re: High Context-Switches on Linux 8.1.4 Server Donald C. Sumbry ][
• 20:03   Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Alex Turner
• 20:07   Re: [NOVICE] 7.3.2 pg_restore very slow Saranya Sivakumar
• 20:20   Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Steinar H. Gunderson
• 22:26   Hardware upgraded but performance still ain't good enough Alvaro Nunes Melo

8 August 2006

• 00:24   Postgresql Performance on an HP DL385 and SmartArray 642 Steve Poe
• 01:11   Re: Postgresql Performance on an HP DL385 and Luke Lonergan
• 01:46   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 02:19   Re: Postgresql Performance on an HP DL385 and Joshua D. Drake
• 02:28   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 04:13   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 06:33   Re: Hardware upgraded but performance still ain't good enough Alex Turner
• 06:40   Re: Postgresql Performance on an HP DL385 and Alex Turner
• 07:39   vacuuming Eugeny N Dzhurinsky
• 10:40   shared_buffer optimization Ruben Rubio
• 12:05   Re: Hardware upgraded but performance still ain't good enough Stephen Frost
• 12:14   Re: Hardware upgraded but performance still ain't good enough Stephen Frost
• 12:20   Re: Postgresql Performance on an HP DL385 and SmartArray 642 Jeff Trout
• 12:38   Re: shared_buffer optimization Christopher Browne
• 13:57   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 14:36   Re: Postgresql Performance on an HP DL385 and Luke Lonergan
• 15:01   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 16:23   Re: Postgresql Performance on an HP DL385 and Luke Lonergan
• 16:57   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 17:49   Optimizing queries Patrice Beliveau
• 18:40   Re: Optimizing queries Scott Marlowe
• 20:15   Re: Optimizing queries Patrice Beliveau
• 20:42   Re: Optimizing queries Tom Lane
• 21:04   most bang for buck with ~ $20,000 Kenji Morishige
• 21:49   Re: most bang for buck with ~ $20,000 Joshua D. Drake
• 21:59   Re: most bang for buck with ~ $20,000 Thomas F. O'Connell
• 22:08   Re: most bang for buck with ~ $20,000 Kenji Morishige
• 22:08   Re: most bang for buck with ~ $20,000 Scott Marlowe
• 22:15   Re: most bang for buck with ~ $20,000 Kenji Morishige
• 22:18   Re: most bang for buck with ~ $20,000 Steve Atkins
• 22:28   Re: most bang for buck with ~ $20,000 Joshua D. Drake
• 22:53   Re: most bang for buck with ~ $20,000 Thomas F. O'Connell
• 23:24   Re: most bang for buck with ~ $20,000 Joshua D. Drake

9 August 2006

• 00:17   Re: most bang for buck with ~ $20,000 Thomas F. O'Connell
• 01:56   Re: Postgresql Performance on an HP DL385 and Luke Lonergan
• 02:29   Re: Hardware upgraded but performance still ain't good David Lang
• 04:56   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 05:22   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 05:25   Re: Postgresql Performance on an HP DL385 and Luke Lonergan
• 05:27   Re: Postgresql Performance on an HP DL385 and Luke Lonergan
• 05:35   Re: most bang for buck with ~ $20,000 Arjen van der Meijden
• 05:45   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 06:30   Re: most bang for buck with ~ $20,000 Kenji Morishige
• 06:33   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 06:38   Re: Postgresql Performance on an HP DL385 and Luke Lonergan
• 06:47   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 06:52   Re: Postgresql Performance on an HP DL385 and Luke Lonergan
• 06:56   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 07:38   Re: most bang for buck with ~ $20,000 Arjen van der Meijden
• 09:25   unsubscribe Gourish Singbal
• 09:59   Unsubscribe Werner vd Merwe
• 10:30   Re: Hardware upgraded but performance still ain't good enough Stephen Frost
• 10:50   Re: shared_buffer optimization Ruben Rubio
• 12:05   Re: Optimizing queries Patrice Beliveau
• 12:20   Re: Optimizing queries Ruben Rubio
• 12:47   Re: Hardware upgraded but performance still ain't good Joshua D. Drake
• 12:51   Re: Hardware upgraded but performance still ain't good Joshua D. Drake
• 13:00   Re: unsubscribe Bill Moran
• 13:20   Re: Hardware upgraded but performance still ain't good enough Merlin Moncure
• 14:23   Re: Optimizing queries Patrice Beliveau
• 14:26   3-table query optimization Michal Taborsky - Internet Mall
• 14:39   Re: Optimizing queries Tom Lane
• 15:09   Re: 3-table query optimization Tom Lane
• 15:15   Re: most bang for buck with ~ $20,000 Scott Marlowe
• 16:20   Re: Hardware upgraded but performance still ain't good David Lang
• 16:21   Re: Hardware upgraded but performance still ain't good David Lang
• 16:23   Dell PowerEdge 2950 performance Bucky Jordan
• 16:26   Re: most bang for buck with ~ $20,000 Merlin Moncure
• 16:28   Re: Hardware upgraded but performance still ain't good Joshua D. Drake
• 16:37   Re: Hardware upgraded but performance still ain't good David Lang
• 16:45   Re: Hardware upgraded but performance still ain't good Scott Marlowe
• 16:52   Re: Hardware upgraded but performance still ain't good Steve Atkins
• 16:54   Re: Hardware upgraded but performance still ain't good Joshua D. Drake
• 21:06   Re: Postgresql Performance on an HP DL385 and Jim C. Nasby
• 21:09   Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Jim C. Nasby
• 21:12   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 21:20   Re: vacuuming Jim C. Nasby
• 21:28   Re: shared_buffer optimization Jim C. Nasby
• 21:36   Re: most bang for buck with ~ $20,000 Jim C. Nasby
• 21:37   Re: Postgresql Performance on an HP DL385 and Scott Marlowe
• 21:50   Re: most bang for buck with ~ $20,000 Scott Marlowe
• 22:00   Re: most bang for buck with ~ $20,000 Jim C. Nasby
• 22:26   Re: [BUGS] BUG #2567: High IOWAIT Jim C. Nasby
• 22:37   Re: shared_buffer optimization Tom Lane
• 23:47   Re: Postgresql Performance on an HP DL385 and Steve Poe

10 August 2006

• 01:24   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 03:29   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 04:00   Beginner optimization questions, esp. regarding Tsearch2 configuration Carl Youngblood
• 07:30   Re: 3-table query optimization Michal Taborsky - Internet Mall
• 08:05   setting up foreign keys Sue Fitt
• 08:15   Re: setting up foreign keys Chris
• 09:05   Re: setting up foreign keys Sue Fitt
• 09:13   Re: setting up foreign keys Chris
• 09:21   Re: setting up foreign keys Sue Fitt
• 09:25   Re: Beginner optimization questions, esp. regarding Tsearch2 Richard Huxton
• 11:07   Re: Beginner optimization questions, esp. regarding Tsearch2 Markus Schaber
• 11:10   Re: Postgresql Performance on an HP DL385 and Michael Stone
• 13:16   Re: most bang for buck with ~ $20,000 Jeff Trout
• 13:33   Re: setting up foreign keys Merlin Moncure
• 15:16   Re: Postgresql Performance on an HP DL385 and Luke Lonergan
• 15:35   Re: Postgresql Performance on an HP DL385 and Scott Marlowe
• 15:47   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 15:50   Re: 3-table query optimization Alvaro Herrera
• 16:54   Re: [BUGS] BUG #2567: High IOWAIT Jim Nasby
• 18:32   Re: setting up foreign keys Stephan Szabo
• 18:52   Migrating data from DB2 to SQL Server contact1981
• 18:52   slow transfer speeds with PostgreSQL hansell baran
• 18:52   Re: Migrating data from DB2 to SQL Server Pit M.
• 18:52   Slow access to PostgreSQL server Phil Cairns
• 19:02   Re: slow transfer speeds with PostgreSQL AgentM
• 20:51   Re: slow transfer speeds with PostgreSQL Merlin Moncure
• 20:56   Re: Slow access to PostgreSQL server Merlin Moncure
• 22:36   Re: setting up foreign keys Chris

11 August 2006

• 04:19   Re: Beginner optimization questions, esp. regarding Tsearch2 Carl Youngblood
• 08:48   Re: [BUGS] BUG #2567: High IOWAIT Markus Schaber
• 08:53   Re: Migrating data from DB2 to SQL Server Markus Schaber
• 09:02   Re: slow transfer speeds with PostgreSQL Markus Schaber
• 09:15   Re: Slow access to PostgreSQL server Markus Schaber
• 09:34   Re: Slow access to PostgreSQL server Thomas Pundt
• 11:48   Re: setting up foreign keys Sue Fitt
• 19:05   Re: setting up foreign keys Spiegelberg, Greg

12 August 2006

• 14:20   Re: most bang for buck with ~ $20,000 Roman Neuhauser

14 August 2006

• 02:14   Re: setting up foreign keys Chris
• 15:38   Re: Postgresql Performance on an HP DL385 and Jim C. Nasby
• 15:51   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 17:04   Re: Postgresql Performance on an HP DL385 and Michael Stone
• 17:05   Re: Postgresql Performance on an HP DL385 and Jim C. Nasby
• 17:09   Re: Postgresql Performance on an HP DL385 and Michael Stone
• 18:28   Re: Dell PowerEdge 2950 performance Vivek Khera
• 19:57   Re: Dell PowerEdge 2950 performance Bucky Jordan
• 21:24   Re: Dell PowerEdge 2950 performance Vivek Khera
• 23:38   Re: Dell PowerEdge 2950 performance Bucky Jordan

15 August 2006

• 05:29   Re: Dell PowerEdge 2950 performance Luke Lonergan
• 13:56   Re: Dell PowerEdge 2950 performance Bucky Jordan
• 14:45   Inner Join of the same table Sebastián Baioni
• 15:05   Re: Beginner optimization questions, esp. regarding Tsearch2 Jim C. Nasby
• 15:08   Re: 3-table query optimization Jim C. Nasby
• 15:10   Re: Inner Join of the same table Mark Lewis
• 15:43   Re: Inner Join of the same table Sebastián Baioni
• 16:01   Re: setting up foreign keys Jim C. Nasby
• 16:25   Re: Postgresql Performance on an HP DL385 and Jim C. Nasby
• 16:29   Re: Postgresql Performance on an HP DL385 and Jim C. Nasby
• 16:56   Re: Inner Join of the same table Jim C. Nasby
• 17:25   Re: Postgresql Performance on an HP DL385 and Michael Stone
• 17:27   Re: Postgresql Performance on an HP DL385 and Michael Stone
• 18:32   Re: Postgresql Performance on an HP DL385 and mark@mark.mielke.cc
• 18:33   Re: Postgresql Performance on an HP DL385 and mark@mark.mielke.cc
• 18:48   Re: Beginner optimization questions, esp. regarding Tsearch2 Carl Youngblood
• 18:49   Re: Beginner optimization questions, esp. regarding Tsearch2 Carl Youngblood
• 18:51   Re: Dell PowerEdge 2950 performance Luke Lonergan
• 18:53   Re: Inner Join of the same table Sebastián Baioni
• 19:03   Re: Postgresql Performance on an HP DL385 and Michael Stone
• 19:15   Re: Postgresql Performance on an HP DL385 and Jim C. Nasby
• 19:17   Re: Dell PowerEdge 2950 performance Vivek Khera
• 19:21   Re: Beginner optimization questions, esp. regarding Tsearch2 Jim C. Nasby
• 19:36   Re: Beginner optimization questions, esp. regarding Frank Wiles
• 19:40   Re: Postgresql Performance on an HP DL385 and mark@mark.mielke.cc
• 19:43   Re: Postgresql Performance on an HP DL385 and mark@mark.mielke.cc
• 20:05   Re: Postgresql Performance on an HP DL385 and Tom Lane
• 20:22   Re: Dell PowerEdge 2950 performance Bucky Jordan
• 20:29   Re: Postgresql Performance on an HP DL385 and mark@mark.mielke.cc
• 20:40   Re: Postgresql Performance on an HP DL385 and Tom Lane
• 20:42   Re: Dell PowerEdge 2950 performance Vivek Khera
• 20:53   Re: Postgresql Performance on an HP DL385 and Michael Stone
• 20:57   Re: Inner Join of the same table Jim Nasby
• 20:59   Re: Postgresql Performance on an HP DL385 and Michael Stone
• 21:13   Re: Inner Join of the same table Tom Lane
• 21:38   Re: Postgresql Performance on an HP DL385 and mark@mark.mielke.cc
• 22:20   Re: Postgresql Performance on an HP DL385 and Jim C. Nasby
• 22:23   Re: Postgresql Performance on an HP DL385 and Steinar H. Gunderson

16 August 2006

• 00:07   Re: Postgresql Performance on an HP DL385 and David Lang
• 01:10   Big diference in response time (query plan question) Luiz K. Matsumura
• 03:02   Re: Postgresql Performance on an HP DL385 and Tom Lane
• 06:18   Re: Dell PowerEdge 2950 performance Luke Lonergan
• 08:33   Re: Postgresql Performance on an HP DL385 and Markus Schaber
• 09:13   Re: Postgresql Performance on an HP DL385 and Guillaume Cottenceau
• 14:24   Re: Big diference in response time (query plan question) Luiz K. Matsumura
• 14:35   Re: Big diference in response time (query plan question) Dave Dutcher
• 14:45   Re: Dell PowerEdge 2950 performance Bucky Jordan
• 14:51   Re: Big diference in response time (query plan question) Dave Dutcher
• 17:14   Re: Beginner optimization questions, esp. regarding Tsearch2 Carl Youngblood
• 17:50   PostgreSQL runs a query much slower than BDE and MySQL Peter Hardman
• 18:02   Re: PostgreSQL runs a query much slower than BDE and MySQL Arjen van der Meijden
• 18:02   Re: PostgreSQL runs a query much slower than BDE and MySQL Rodrigo De León
• 18:27   Re: Inner Join of the same table Sebastián Baioni
• 19:44   Re: PostgreSQL runs a query much slower than BDE and MySQL Peter Hardman
• 22:52   Re: PostgreSQL runs a query much slower than BDE and MySQL Tom Lane

17 August 2006

• 02:10   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 04:57   Re: Beginner optimization questions, esp. regarding Tsearch2 Jim C. Nasby
• 09:08   Re: PostgreSQL runs a query much slower than BDE and MySQL Peter Hardman
• 09:21   Re: PostgreSQL runs a query much slower than BDE and MySQL Peter Hardman
• 10:11   Re: PostgreSQL runs a query much slower than BDE and MySQL Markus Schaber
• 10:28   Re: PostgreSQL runs a query much slower than BDE and MySQL Peter Hardman
• 11:01   Re: PostgreSQL runs a query much slower than BDE and MySQL Markus Schaber
• 13:11   Re: PostgreSQL runs a query much slower than BDE and MySQL Tom Lane
• 13:54   Re: PostgreSQL runs a query much slower than BDE and Mark Lewis
• 16:31   Re: PostgreSQL runs a query much slower than BDE and Magnus Hagander
• 18:33   Re: PostgreSQL runs a query much slower than BDE and MySQL Tom Lane
• 19:21   Re: PostgreSQL runs a query much slower than BDE and MySQL Scott Lamb
• 19:32   Re: PostgreSQL runs a query much slower than BDE and MySQL Scott Lamb
• 20:00   Re: PostgreSQL runs a query much slower than BDE and MySQL Peter Hardman
• 20:13   Re: PostgreSQL runs a query much slower than BDE and MySQL Peter Hardman
• 20:25   Re: PostgreSQL runs a query much slower than BDE and MySQL Peter Hardman
• 22:01   Re: PostgreSQL runs a query much slower than BDE and MySQL Scott Lamb

18 August 2006

• 00:31   Re: PostgreSQL runs a query much slower than BDE and MySQL Tom Lane
• 00:33   Q: Performance of join vs embedded query for simple queries? mark@mark.mielke.cc
• 01:21   Re: Q: Performance of join vs embedded query for simple queries? Tom Lane
• 02:21   Re: Q: Performance of join vs embedded query for simple queries? mark@mark.mielke.cc
• 02:30   Re: Q: Performance of join vs embedded query for simple queries? mark@mark.mielke.cc
• 02:37   Re: Q: Performance of join vs embedded query for simple queries? Tom Lane
• 06:46   Re: Dell PowerEdge 2950 performance alvis
• 10:49   Re: Hardware upgraded but performance still ain't good Magnus Hagander
• 10:50   Re: Postgresql Performance on an HP DL385 and Magnus Hagander
• 13:14   Re: Hardware upgraded but performance still ain't good Merlin Moncure
• 14:38   Re: Postgresql Performance on an HP DL385 and Luke Lonergan
• 15:26   Re: Postgresql Performance on an HP DL385 and Bucky Jordan
• 17:42   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 18:03   Re: most bang for buck with ~ $20,000 Kenji Morishige
• 18:14   Re: Postgresql Performance on an HP DL385 and Luke Lonergan
• 19:06   Re: Postgresql Performance on an HP DL385 and Steve Poe
• 19:12   Re: most bang for buck with ~ $20,000 Kenji Morishige
• 19:49   Re: most bang for buck with ~ $20,000 Arjen van der Meijden
• 19:55   Re: most bang for buck with ~ $20,000 Kenji Morishige
• 20:20   Re: most bang for buck with ~ $20,000 Bucky Jordan
• 21:34   Re: Postgresql Performance on an HP DL385 and Luke Lonergan
• 22:22   Re: most bang for buck with ~ $20,000 Arjen van der Meijden
• 22:23   Re: Postgresql Performance on an HP DL385 and Steve Poe

21 August 2006

• 17:52   Index usage Scott Matseas
• 18:29   Re: Index usage Tom Lane
• 19:14   Vacuum not identifying rows for removal.. Eamonn Kent
• 19:25   Re: Vacuum not identifying rows for removal.. Brad Nicholson
• 20:25   Re: Index usage Scott Matseas
• 21:06   Re: Vacuum not identifying rows for removal.. Tom Lane
• 21:09   How to get higher tps Marty Jia
• 21:43   Re: How to get higher tps Jeff Davis
• 21:50   Re: How to get higher tps Mark Lewis
• 21:52   Storage Options Jeff Davis
• 21:56   Re: How to get higher tps Marty Jia
• 22:08   Re: How to get higher tps Joshua D. Drake
• 23:43   Re: How to get higher tps Scott Marlowe

22 August 2006

• 01:28   Re: Vacuum not identifying rows for removal.. Eamonn Kent
• 01:56   Re: Vacuum not identifying rows for removal.. Joshua D. Drake
• 03:55   Re: Effects of cascading references in foreign keys Bruce Momjian
• 09:23   Forcing index usage without 'enable_hashjoin = FALSE' Dan Langille
• 10:03   Re: Storage Options Michael Stone
• 13:00   Postgre SQL 7.1 cygwin performance issue. Ravindran G - TLS, Chennai.
• 13:14   Re: How to get higher tps Marty Jia
• 13:15   Re: Postgre SQL 7.1 cygwin performance issue. Chris Hoover
• 13:17   Re: Postgre SQL 7.1 cygwin performance issue. Tom Lane
• 13:17   Re: How to get higher tps Marty Jia
• 14:32   Re: How to get higher tps Mark Lewis
• 15:25   Re: Vacuum not identifying rows for removal.. Eamonn Kent
• 15:26   Re: How to get higher tps Scott Marlowe
• 15:27   Re: How to get higher tps Alex Turner
• 15:27   Re: How to get higher tps Alex Turner
• 15:30   Re: How to get higher tps Marty Jia
• 15:42   Re: How to get higher tps Marty Jia
• 15:44   Re: How to get higher tps Marty Jia
• 15:47   Re: How to get higher tps Ron
• 15:55   Re: How to get higher tps Marty Jia
• 16:16   Re: How to get higher tps Joshua D. Drake
• 17:23   query planner: automatic rescribe of LIKE to BETWEEN ? Ulrich Habel
• 17:46   Re: query planner: automatic rescribe of LIKE to BETWEEN ? Alvaro Herrera
• 18:21   Re: query planner: automatic rescribe of LIKE to BETWEEN ? Thomas Samson
• 18:33   VACUUM FULL needed sometimes to prevent transaction ID wraparound? Marinos Yannikos
• 18:50   Re: query planner: automatic rescribe of LIKE to BETWEEN ? Alvaro Herrera
• 19:20   Re: VACUUM FULL needed sometimes to prevent transaction ID wraparound? Alvaro Herrera
• 19:23   Re: How to get higher tps Bucky Jordan
• 19:28   Re: VACUUM FULL needed sometimes to prevent transaction ID wraparound? Dave Dutcher
• 19:36   Re: How to get higher tps Marty Jia
• 19:39   Re: How to get higher tps Joshua D. Drake
• 19:49   Re: How to get higher tps Bucky Jordan
• 20:33   Re: How to get higher tps Marty Jia
• 20:59   Benchmarks Charles Sprickman
• 21:12   Re: query planner: automatic rescribe of LIKE to BETWEEN ? Tom Lane
• 21:34   PowerEdge 2950 questions Jeff Davis
• 21:56   Re: PowerEdge 2950 questions Bucky Jordan
• 22:00   Re: VACUUM FULL needed sometimes to prevent transaction Jeff Davis
• 22:23   Re: PowerEdge 2950 questions Jeff Davis

23 August 2006

• 01:13   Query tuning Subbiah, Stalin
• 01:17   Moving a tablespace Craig A. James
• 01:36   Re: Moving a tablespace Michael Fuhr
• 01:37   Re: Query tuning Chris
• 02:35   Re: Moving a tablespace Tom Lane
• 02:53   Re: Query tuning Subbiah, Stalin
• 03:05   Re: Query tuning Chris
• 03:32   Re: Forcing index usage without 'enable_hashjoin = FALSE' Chris
• 12:50   Re: VACUUM FULL needed sometimes to prevent transaction Markus Schaber
• 13:24   Re: VACUUM FULL needed sometimes to prevent transaction Heikki Linnakangas
• 18:02   Re: Query tuning Subbiah, Stalin
• 22:23   Which benchmark to use for testing FS? Jeff Davis
• 23:20   Re: Query tuning Dave Dutcher

24 August 2006

• 01:51   Re: Which benchmark to use for testing FS? Michael Stone
• 02:11   Re: Forcing index usage without 'enable_hashjoin = FALSE' Dan Langille
• 02:30   Re: Forcing index usage without 'enable_hashjoin = FALSE' Tom Lane
• 02:43   Re: Forcing index usage without 'enable_hashjoin = FALSE' Dan Langille
• 04:44   Re: Query tuning Subbiah, Stalin
• 09:26   Is this way of testing a bad idea? Fredrik Israelsson
• 12:51   Re: Is this way of testing a bad idea? Tom Lane
• 13:21   Re: PowerEdge 2950 questions Merlin Moncure
• 13:40   Re: Is this way of testing a bad idea? Mark Lewis
• 14:39   Re: Is this way of testing a bad idea? Bucky Jordan
• 16:05   Re: Which benchmark to use for testing FS? Jeff Davis
• 16:25   Re: PowerEdge 2950 questions Jeff Davis
• 18:57   Re: PowerEdge 2950 questions Merlin Moncure
• 19:27   Re: PowerEdge 2950 questions Claus Guttesen
• 19:28   Re: PowerEdge 2950 questions Mark Lewis
• 19:38   Re: PowerEdge 2950 questions Scott Marlowe
• 19:51   Re: PowerEdge 2950 questions Bucky Jordan
• 20:04   Re: PowerEdge 2950 questions Merlin Moncure
• 20:22   Re: PowerEdge 2950 questions Scott Marlowe
• 20:29   Re: PowerEdge 2950 questions Merlin Moncure
• 20:48   adtx Merlin Moncure
• 23:44   select max(column) from parent table very slow Sriram Dandapani

25 August 2006

• 01:09   Re: select max(column) from parent table very slow Joshua D. Drake
• 04:33   Re: select max(column) from parent table very slow Tom Lane
• 05:17   Re: select max(column) from parent table very slow Joshua D. Drake
• 14:46   Re: select max(column) from parent table very slow Alvaro Herrera
• 15:23   Re: select max(column) from parent table very slow Joshua D. Drake
• 15:53   Related to Inserting into the database from XML file soni de
• 16:19   Re: Related to Inserting into the database from XML file Jeff Davis
• 16:55   Changing max_connections without restart ? Jean Arnaud
• 17:55   Re: Changing max_connections without restart ? Tom Lane

26 August 2006

• 17:13   stats reset during pg_restore? George Pavlov
• 20:12   [8.1.4] Help optimizing query Hayes

27 August 2006

• 02:46   Re: stats reset during pg_restore? Alvaro Herrera
• 14:18   Re: Related to Inserting into the database from XML file George Pavlov
• 14:24   Re: stats reset during pg_restore? George Pavlov
• 14:38   Re: stats reset during pg_restore? Alvaro Herrera
• 16:41   Re: [8.1.4] Help optimizing query George Pavlov

28 August 2006

• 02:26   Re: Benchmarks Merlin Moncure
• 05:31   Re: Related to Inserting into the database from XML file soni de
• 07:51   Re: Postgre SQL 7.1 cygwin performance issue. Ravindran G - TLS, Chennai.
• 08:15   perf pb solved only after pg_dump and restore Guillaume Cottenceau
• 09:28   Re: perf pb solved only after pg_dump and restore Markus Schaber
• 09:43   Re: perf pb solved only after pg_dump and restore Guillaume Cottenceau
• 10:17   Re: perf pb solved only after pg_dump and restore Guillaume Smet
• 10:34   Re: perf pb solved only after pg_dump and restore Markus Schaber
• 12:32   Re: perf pb solved only after pg_dump and restore Guillaume Cottenceau
• 13:07   Re: perf pb solved only after pg_dump and restore Guillaume Cottenceau
• 13:13   Re: perf pb solved only after pg_dump and restore Markus Schaber
• 13:32   Re: Postgre SQL 7.1 cygwin performance issue. Alvaro Herrera
• 13:43   Re: perf pb solved only after pg_dump and restore Markus Schaber
• 13:48   Re: perf pb solved only after pg_dump and restore Guillaume Cottenceau
• 14:01   Re: Postgre SQL 7.1 cygwin performance issue. Ravindran G - TLS, Chennai.
• 14:17   Re: Postgre SQL 7.1 cygwin performance issue. Christopher Browne
• 14:18   Re: Postgre SQL 7.1 cygwin performance issue. A. Kretschmer
• 14:20   Re: Postgre SQL 7.1 cygwin performance issue. Alvaro Herrera
• 14:28   Re: Postgre SQL 7.1 cygwin performance issue. Christopher Browne
• 14:40   Identifying bloated tables Michal Taborsky - Internet Mall
• 14:48   Re: Identifying bloated tables Brad Nicholson
• 14:57   Re: Postgre SQL 7.1 cygwin performance issue. Scott Marlowe
• 15:09   Re: Postgre SQL 7.1 cygwin performance issue. Joshua D. Drake
• 15:14   Re: Postgre SQL 7.1 cygwin performance issue. Tom Lane
• 15:28   Re: Identifying bloated tables Michal Taborsky - Internet Mall
• 15:32   Re: Identifying bloated tables Alvaro Herrera
• 15:49   Re: Identifying bloated tables Markus Schaber
• 15:56   Re: Identifying bloated tables Michal Taborsky - Internet Mall
• 16:03   Re: Benchmarks Scott Marlowe
• 16:20   Re: Postgre SQL 7.1 cygwin performance issue. Christopher Browne
• 16:25   Re: perf pb solved only after pg_dump and restore Scott Marlowe
• 19:47   Re: Postgre SQL 7.1 cygwin performance issue. Merlin Moncure
• 23:06   slow i/o Junaili Lie

29 August 2006

• 06:35   Re: Identifying bloated tables Peter Childs
• 07:21   Internal Operations on LIMIT & OFFSET clause Vanitha Jaya
• 07:38   Re: Internal Operations on LIMIT & OFFSET clause A. Kretschmer
• 14:10   PostgreSQL performance issues Willo van der Merwe
• 14:46   Re: PostgreSQL performance issues A. Kretschmer
• 14:52   Re: PostgreSQL performance issues Joshua D. Drake
• 15:04   Re: slow i/o Jignesh K. Shah
• 15:06   Re: PostgreSQL performance issues Willo van der Merwe
• 15:11   Re: slow i/o Jignesh K. Shah
• 15:13   Re: PostgreSQL performance issues PFC
• 15:16   Re: PostgreSQL performance issues A. Kretschmer
• 21:36   Re: slow i/o Junaili Lie
• 23:12   Re: PostgreSQL performance issues Rusty Conover
• 23:34   Re: PostgreSQL performance issues Codelogic
• 23:58   Re: PostgreSQL performance issues Merlin Moncure

30 August 2006

• 10:21   Re: PostgreSQL performance issues Willo van der Merwe
• 10:30   performance problems. Matthew Sullivan
• 10:32   Re: PostgreSQL performance issues Luke Lonergan
• 10:48   Re: PostgreSQL performance issues Willo van der Merwe
• 11:37   Re: PostgreSQL performance issues Willo van der Merwe
• 11:44   Re: PostgreSQL performance issues Luke Lonergan
• 11:52   Re: PostgreSQL performance issues Alex Hayward
• 11:58   Re: PostgreSQL performance issues Willo van der Merwe
• 12:04   Re: PostgreSQL performance issues Willo van der Merwe
• 12:45   Re: PostgreSQL performance issues Dave Cramer
• 13:13   Re: PostgreSQL performance issues Willo van der Merwe
• 14:03   Re: PostgreSQL performance issues Dave Dutcher
• 14:11   Re: performance problems. Vivek Khera
• 14:49   Re: PostgreSQL performance issues Willo van der Merwe
• 15:08   Re: PostgreSQL performance issues Merlin Moncure
• 16:27   Re: performance problems. Jim C. Nasby
• 16:45   Re: PostgreSQL performance issues Alan Hodgson
• 18:20   Re: slow i/o Jignesh K. Shah
• 18:22   Re: performance problems. Alex Hayward
• 18:53   Re: slow i/o Junaili Lie
• 22:56   Re: performance problems. Matthew Sullivan
• 23:38   Re: performance problems. Mark Kirkwood

31 August 2006

• 00:08   Re: performance problems. Dave Cramer
• 16:38   High concurrency OLTP database performance tuning Cosimo Streppone
• 17:06   Re: High concurrency OLTP database performance tuning Guillaume Smet
• 17:22   Postgress memory leak with JBoss3.2.6 and large DB Indika Maligaspe
• 17:32   Re: High concurrency OLTP database performance tuning Michael Loftis
• 17:46   Re: High concurrency OLTP database performance tuning Merlin Moncure
• 17:54   Re: Postgress memory leak with JBoss3.2.6 and large DB Tom Lane
• 18:11   Re: performance problems. Vivek Khera
• 18:11   Re: Postgress memory leak with JBoss3.2.6 and large DB Dave Cramer
• 18:13   Re: High concurrency OLTP database performance tuning Dave Cramer
• 18:15   Re: performance problems. Vivek Khera
• 18:23   Re: High concurrency OLTP database performance tuning Casey Duncan
• 18:28   Re: performance problems. Dave Cramer
• 19:08   Re: performance problems. Tom Lane
• 19:49   Re: performance problems. Vivek Khera