Mailing lists [pgsql-performance]

1 December 2004

• 03:28   Re: Hardware purchase question Josh Berkus
• 04:49   Re: FW: Index usage BBI Edwin Punzalan
• 05:05   Re: FW: Index usage gnari
• 05:32   Re: FW: Index usage BBI Edwin Punzalan
• 06:59   Re: FW: Index usage Iain
• 07:05   Re: FW: Index usage BBI Edwin Punzalan
• 07:10   Using "LIMIT" is much faster even though, searching with PK. 장현성
• 07:17   Re: FW: Index usage Iain
• 07:26   Re: Using "LIMIT" is much faster even though, searching with PK. Tom Lane
• 07:42   Re: Using "LIMIT" is much faster even though, searching Hyun-Sung, Jang
• 08:06   Re: Using "LIMIT" is much faster even though, searching Josh Berkus
• 09:03   Re: Using "LIMIT" is much faster even though, searching Hyun-Sung, Jang
• 11:22   Re: FW: Index usage gnari
• 11:23   Re: Using "LIMIT" is much faster even though, searching Andrew McMillan
• 15:45   pg_restore taking 4 hours! Rodrigo Carvalhaes
• 16:30   Re: Query Performance and IOWait George Woodring
• 17:27   Re: pg_restore taking 4 hours! Shridhar Daithankar
• 18:39   Re: [GENERAL] pg_restore taking 4 hours! Tom Lane
• 19:46   query with timestamp not using index Brian Hirt
• 20:38   Re: query with timestamp not using index Richard Huxton

2 December 2004

• 01:09   Re: query with timestamp not using index Brian Hirt
• 01:17   Re: query with timestamp not using index Tom Lane
• 01:21   Alternatives to Dell? Josh Berkus
• 02:32   Re: Off-list Re: Alternatives to Dell? Josh Berkus
• 03:01   Re: [GENERAL] pg_restore taking 4 hours! Riccardo G. Facchini
• 03:17   Re: Alternatives to Dell? Steven Rosenstein
• 03:21   Recommended Specs Hasnul Fadhly bin Hasan
• 04:35   Re: Alternatives to Dell? Matthew Marlowe
• 04:58   Re: Alternatives to Dell? Geoffrey
• 05:09   Re: Alternatives to Dell? Iain
• 05:15   Re: query with timestamp not using index Tom Lane
• 05:15   Re: Alternatives to Dell? Joshua D. Drake
• 05:18   Re: Alternatives to Dell? Joshua D. Drake
• 05:21   Re: Alternatives to Dell? Geoffrey
• 05:23   Re: Off-list Re: Alternatives to Dell? Sven Willenberger
• 05:31   Re: Using "LIMIT" is much faster even though, searching Josh Berkus
• 05:49   Re: pg_restore taking 4 hours! Josh Berkus
• 06:02   Re: Alternatives to Dell? Mike Rylander
• 06:04   Re: Alternatives to Dell? Geoffrey
• 06:05   Re: Alternatives to Dell? Merlin Moncure
• 06:12   Re: Alternatives to Dell? Frank Wiles
• 06:17   Re: Alternatives to Dell? Bruce Momjian
• 06:48   Re: Alternatives to Dell? Anjan Dave
• 06:56   Re: Alternatives to Dell? Geoffrey
• 09:18   Re: Recommended Specs Josh Berkus
• 17:38   pg replication tools? sarlav kumar
• 17:42   Re: Alternatives to Dell? Joe Conway
• 19:20   Re: VACUUM ANALYZE downgrades performance Dmitry Karasik
• 19:27   Re: Alternatives to Dell? Geoffrey
• 19:31   Re: VACUUM ANALYZE downgrades performance Rod Taylor
• 19:33   Re: VACUUM ANALYZE downgrades performance Steinar H. Gunderson
• 19:38   Re: VACUUM ANALYZE downgrades performance Shridhar Daithankar
• 19:43   Re: Alternatives to Dell? Steinar H. Gunderson
• 19:45   Re: Alternatives to Dell? Steinar H. Gunderson
• 19:50   Re: Alternatives to Dell? Thomas F.O'Connell
• 19:52   Re: pg replication tools? Joshua D. Drake
• 20:01   Re: pg replication tools? Darcy Buskermolen
• 20:06   Normalization or Performance Alvaro Nunes Melo
• 20:18   Different location or different instance Gabriele Bartolini
• 20:58   Re: pg_restore taking 4 hours! Andrew McMillan
• 21:35   Re: Normalization or Performance Richard Huxton
• 21:38   Re: Alternatives to Dell? Dave Cramer
• 21:40   Re: Alternatives to Dell? Merlin Moncure
• 22:12   Poor Performance on a table Pallav Kalva
• 22:19   Re: Poor Performance on a table Frank Wiles
• 22:22   Re: [pgsql-hackers-win32] scalability issues on win32 Merlin Moncure
• 22:29   Re: [pgsql-hackers-win32] scalability issues on win32 Bruce Momjian
• 22:33   Re: Poor Performance on a table Pallav Kalva
• 22:37   Re: Poor Performance on a table Tom Lane
• 22:37   Re: Poor Performance on a table Frank Wiles
• 22:42   Re: [pgsql-hackers-win32] scalability issues on win32 Tom Lane
• 22:54   Re: Poor Performance on a table Pallav Kalva
• 23:11   Re: Poor Performance on a table Tom Lane
• 23:18   Re: Alternatives to Dell? Robin Ericsson

3 December 2004

• 02:04   Re: Normalization or Performance Jim C. Nasby
• 04:43   Re: Normalization or Performance Iain
• 05:50   Re: pg replication tools? Christopher Browne
• 08:16   Re: pg replication tools? Vishal Kashyap @ [SaiHertz]
• 08:59   Re: Poor Performance on a table Josh Berkus
• 17:20   Re: Alternatives to Dell? Cott Lang
• 17:31   Re: Alternatives to Dell? Joshua D. Drake
• 17:34   Re: Alternatives to Dell? Cott Lang
• 17:39   Re: Alternatives to Dell? Joshua D. Drake
• 20:00   Re: Alternatives to Dell? Cott Lang
• 23:38   Re: VACUUM ANALYZE downgrades performance Dmitry Karasik
• 23:39   DB2 feature Pailloncy Jean-Gérard
• 23:59   Re: DB2 feature Josh Berkus

4 December 2004

• 01:31   Performance difference in similar queries Kiran Mukhyala
• 01:48   Re: DB2 feature Pailloncy Jean-Gérard
• 01:50   Re: DB2 feature Christopher Browne
• 04:53   Re: Alternatives to Dell? Mike Rylander
• 06:47   Overhead of dynamic query in trigger Sven Willenberger
• 07:59   Performance difference in similar queries Kiran Mukhyala
• 16:37   Improve BULK insertion Grupos
• 17:50   Re: Improve BULK insertion Christopher Browne
• 18:01   Re: Improve BULK insertion Patrick Hatcher
• 19:56   lock problem sarlav kumar
• 20:22   Re: Alternatives to Dell? Cott Lang
• 20:35   Re: lock problem Stephan Szabo
• 22:17   Re: Improve BULK insertion Josh Berkus

5 December 2004

• 05:45   Partitioned table performance Stacy White
• 22:44   Re: pg_restore taking 4 hours! Rodrigo Carvalhaes
• 22:53   Re: Improve BULK insertion Rodrigo Carvalhaes

6 December 2004

• 01:48   Re: Improve BULK insertion Gregory S. Williamson
• 02:10   Re: Partitioned table performance Josh Berkus
• 02:23   Re: Improve BULK insertion Josh Berkus
• 12:28   8.0 vs. 7.4 benchmarks Postgres Learner
• 17:43   Config Check Bryan
• 18:15   Re: Config Check Pierre-Frédéric Caillaud
• 18:28   Poor Query Pallav Kalva
• 18:45   Re: Poor Query Pierre-Frédéric Caillaud
• 18:52   Re: Poor Query Pallav Kalva
• 18:56   Re: Config Check Tom Lane
• 19:13   Re: Poor Query Pierre-Frédéric Caillaud
• 19:38   Re: Poor Query Pallav Kalva
• 20:29   Processor optimization compile options? Josh Berkus
• 20:31   Re: Poor Query Pierre-Frédéric Caillaud
• 21:00   Re: Poor Query Pallav Kalva
• 21:58   Re: Alternatives to Dell? Andrew Sullivan
• 23:15   Re: Poor Query Pierre-Frédéric Caillaud
• 23:44   Re: Poor Query Pallav Kalva

7 December 2004

• 03:51   Re: TableSpace Design issues on Postgres 8.0 beta 5 Rosny
• 03:52   Config review Bryan Vest
• 03:52   scaling beyond 4 processors vogler@cipsoft.com
• 03:53   TableSpace Design issues on Postgres 8.0 beta 5 Rosny
• 05:41   Re: Config Check Hasnul Fadhly bin Hasan
• 05:51   Re: scaling beyond 4 processors Jeff
• 07:18   Re: scaling beyond 4 processors Christopher Browne
• 07:18   Re: scaling beyond 4 processors Christopher Browne
• 07:44   Re: TableSpace Design issues on Postgres 8.0 beta 5 Tom Lane
• 08:04   Re: Config Check Tom Lane
• 11:03   Re: Config review Greg Stark
• 14:09   Re: pg_restore taking 4 hours! Hannu Krosing
• 18:08   Re: Config review Tom Lane
• 18:19   Re: Config review Andrew Sullivan

11 December 2004

• 04:30   Re: Partitioned table performance Stacy White
• 04:30   Slow insert Christopher Kings-Lynne
• 04:52   LIMIT causes SEQSCAN in subselect Mike Rylander
• 05:07   Re: scaling beyond 4 processors Josh Berkus
• 06:40   Re: [GENERAL] Query is not using index when it should Stephan Szabo
• 10:00   Re: Partitioned table performance Josh Berkus
• 10:03   Re: LIMIT causes SEQSCAN in subselect Josh Berkus
• 10:31   Re: Slow insert Steinar H. Gunderson
• 17:17   Re: [GENERAL] Query is not using index when it should tomas@nocrew.org (Tomas Skäre)
• 17:32   Re: [GENERAL] Query is not using index when it should Steinar H. Gunderson
• 17:38   Re: LIMIT causes SEQSCAN in subselect Mike Rylander
• 19:25   Re: [GENERAL] Query is not using index when it should Michael Fuhr
• 20:01   Very different index usage on similar tables Alvaro Nunes Melo
• 21:09   Re: LIMIT causes SEQSCAN in subselect Tom Lane

12 December 2004

• 11:32   Re: [GENERAL] Query is not using index when it should tomas@nocrew.org (Tomas Skäre)

13 December 2004

• 04:05   Re: TableSpace Design issues on Postgres 8.0 beta 5 Rosny
• 04:12   Query is not using index when it should tomas@nocrew.org (Tomas Skäre)
• 04:16   Re: Config Check John A Meinel
• 05:49   Re: Query is not using index when it should Josh Berkus
• 09:13   Using LIMIT changes index used by planner Sven Willenberger
• 12:56   Re: Using LIMIT changes index used by planner Andrew McMillan
• 19:29   INSERT question sarlav kumar
• 19:34   Re: Hardware purchase question Vivek Khera
• 19:37   Re: INSERT question Bruno Wolff III
• 19:37   Re: pg_restore taking 4 hours! Vivek Khera
• 19:47   Re: Alternatives to Dell? Vivek Khera
• 20:19   Re: Off-list Re: Alternatives to Dell? Vivek Khera
• 20:23   Re: Hardware purchase question Joshua D. Drake
• 21:23   Re: Alternatives to Dell? Bruce Momjian
• 21:26   Re: pg_restore taking 4 hours! Josh Berkus
• 21:32   Re: Hardware purchase question Josh Berkus
• 21:33   Re: INSERT question sarlav kumar
• 21:44   Re: pg_restore taking 4 hours! Josh Berkus
• 22:21   Re: pg_restore taking 4 hours! Tom Lane
• 22:32   Re: Similar tables, different indexes performance Alvaro Nunes Melo

14 December 2004

• 01:08   Re: Using LIMIT changes index used by planner Sven Willenberger
• 01:44   Re: Using LIMIT changes index used by planner Tom Lane
• 04:46   Trying to create multi db query in one large queries Hasnul Fadhly bin Hasan
• 04:53   Re: pg_restore taking 4 hours! Iain
• 08:12   Re: Similar tables, different indexes performance Bruno Wolff III
• 09:19   Re: Trying to create multi db query in one large querie Spiegelberg, Greg
• 09:59   Re: Trying to create multi db query in one large querie Joe Conway
• 10:19   Re: Trying to create multi db query in one large queries Josh Berkus
• 12:34   Re: Hardware purchase question Andrew Hood
• 20:36   Speeding up pg_dump Rod Taylor
• 21:20   Re: Anything to be gained from a 'Postgres Filesystem'? Markus Schaber
• 21:27   Re: Using LIMIT changes index used by planner Sven Willenberger
• 22:35   Re: Using LIMIT changes index used by planner Tom Lane

15 December 2004

• 00:38   Query Optimization sarlav kumar
• 02:15   Re: Speeding up pg_dump Simon Riggs
• 09:08   Re: Partitioned table performance Stacy White
• 17:38   \d output to a file sarlav kumar
• 18:12   Re: \d output to a file Gary Cowell
• 18:17   Re: [NOVICE] \d output to a file Geoffrey
• 18:36   Re: \d output to a file Grega Bremec
• 19:51   Re: [NOVICE] \d output to a file Tom Lane
• 21:00   Re: Query Optimization Andrew Lazarus
• 21:23   Re: Partitioned table performance Josh Berkus
• 21:32   Re: [NOVICE] \d output to a file Ragnar Hafstað
• 22:37   Re: Partitioned table performance Greg Stark
• 22:57   Re: Partitioned table performance Josh Berkus

16 December 2004

• 01:54   Re: Partitioned table performance Greg Stark
• 02:53   indentifying the database in a Postgres log file. Theo Galanakis
• 03:09   Re: indentifying the database in a Postgres log file. Bruce Momjian
• 04:30   Re: Partitioned table performance Tom Lane
• 07:50   Re: Trying to create multi db query in one large queries Christopher Browne
• 19:11   Improve performance of query Richard Rowell
• 20:05   Re: Improve performance of query Stephen Frost
• 20:08   Seqscan rather than Index Jon Anderson
• 20:15   Re: Improve performance of query Richard Huxton
• 20:19   Re: Improve performance of query Tom Lane
• 20:24   Re: Improve performance of query John A Meinel
• 20:32   Re: Seqscan rather than Index Tom Lane
• 23:07   UNION ALL vs INHERITANCE Adi Alurkar

17 December 2004

• 01:13   Re: UNION ALL vs INHERITANCE Tom Lane
• 04:19   Re: Seqscan rather than Index David Brown
• 16:04   Re: Seqscan rather than Index Richard Huxton
• 18:48   Re: Seqscan rather than Index Greg Stark
• 20:45   Re: Seqscan rather than Index Tom Lane
• 20:58   Error in VACUUM FULL VERBOSE ANALYZE (not enough memory) Pailloncy Jean-Gerard
• 21:12   Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory) Josh Berkus
• 21:25   Re: Seqscan rather than Index Greg Stark
• 21:25   Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory) Pailloncy Jean-Gerard
• 21:34   Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory) Pailloncy Jean-Gerard
• 21:37   Re: Seqscan rather than Index Tom Lane
• 21:44   Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory) Josh Berkus
• 21:52   Which is more efficient? Mike G.
• 22:47   Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory) Tom Lane
• 22:49   Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory) Josh Berkus
• 22:59   Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory) Tom Lane

18 December 2004

• 00:11   Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory) Bruno Wolff III
• 00:14   Monitor CPU time per transaction? Stan Y
• 00:21   Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory) Tom Lane
• 00:57   Re: Seqscan rather than Index Steinar H. Gunderson
• 01:02   Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory) Pailloncy Jean-Gerard
• 01:09   Re: Seqscan rather than Index Steinar H. Gunderson
• 01:21   Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory) Tom Lane
• 02:02   Re: Seqscan rather than Index Frank Wiles
• 02:56   Re: Seqscan rather than Index Steinar H. Gunderson
• 06:51   Re: Which is more efficient? Christopher Browne
• 07:31   Re: Seqscan rather than Index Bruno Wolff III
• 07:40   Re: Seqscan rather than Index Tom Lane
• 10:24   Re: Improve performance of query John A Meinel
• 10:25   Monitor CPU time per transaction? Stan Y
• 16:47   Re: Seqscan rather than Index Steinar H. Gunderson

20 December 2004

• 07:19   PG Logging is Slow Theo Galanakis
• 07:31   Re: PG Logging is Slow Bruce Momjian
• 07:47   Re: PG Logging is Slow Grega Bremec
• 17:08   Re: PG Logging is Slow Michael Adler
• 17:40   Postgres version change - pg_dump sarlav kumar
• 18:35   Re: Postgres version change - pg_dump Bruno Wolff III
• 20:08   Re: Postgres version change - pg_dump Stefan Weiss
• 20:30   Re: Postgres version change - pg_dump sarlav kumar
• 20:34   Re: Postgres version change - pg_dump sarlav kumar
• 22:40   Re: Seqscan rather than Index Frank Wiles

21 December 2004

• 01:26   slony replication sarlav kumar
• 01:43   Re: PG Logging is Slow Theo Galanakis
• 02:09   Re: PG Logging is Slow Alexander Borkowski
• 04:42   Question of performance of version 8 kondo_yo@itg.hitachi.co.jp
• 06:55   Re: Question of performance of version 8 Tom Lane
• 08:02   Postgres on Linux Cluster! Gurpreet Sachdeva
• 08:04   Re: Question of performance of version 8 kondo_yo@itg.hitachi.co.jp
• 08:45   Re: Processor optimization compile options? Alexander Kirpa
• 08:45   Tips for a system with _extremely_ slow IO? Ron Mayer
• 08:55   Re: PG Logging is Slow Theo Galanakis
• 09:01   Re: Postgres version change - pg_dump Christopher Kings-Lynne
• 10:08   Re: Postgres version change - pg_dump Iain
• 14:21   Re: Postgres on Linux Cluster! Richard Huxton
• 17:23   Re: Tips for a system with _extremely_ slow IO? Steve Atkins
• 21:29   Re: Tips for a system with _extremely_ slow IO? Ragnar Hafstað
• 21:36   Re: Tips for a system with _extremely_ slow IO? Merlin Moncure

22 December 2004

• 01:56   Re: Partitioned table performance Jim C. Nasby
• 02:12   Re: Partitioned table performance Jim C. Nasby
• 04:41   Re: Partitioned table performance Stacy White
• 19:32   8rc2 & BLCKSZ Pailloncy Jean-Gerard
• 23:09   Why so much time difference with a same query/plan? Litao Wu
• 23:51   Re: 8rc2 & BLCKSZ Vivek Khera

23 December 2004

• 00:06   Re: 8rc2 & BLCKSZ Tom Lane
• 00:52   Re: Why so much time difference with a same query/plan? Litao Wu
• 02:43   Re: Memory leak tsearch2 VACUUM FULL VERBOSE ANALYZE Pailloncy Jean-Gerard
• 03:02   Re: Memory leak tsearch2 VACUUM FULL VERBOSE ANALYZE Tom Lane
• 10:01   Re: 8rc2 & BLCKSZ Mario Weilguni
• 10:05   Re: Why so much time difference with a same query/plan? Yann Michel
• 17:27   Some Performance Advice Needed Alex
• 17:43   Re: Some Performance Advice Needed Jeff
• 23:50   Re: Some Performance Advice Needed William Yu

24 December 2004

• 00:28   Re: Some Performance Advice Needed Joshua D. Drake
• 00:47   Re: Some Performance Advice Needed William Yu
• 01:45   Re: Memory leak tsearch2 VACUUM FULL VERBOSE ANALYZE Tom Lane
• 04:49   Re: LIMIT causes SEQSCAN in subselect Pierre-Frédéric Caillaud
• 05:06   Re: Using LIMIT changes index used by planner Pierre-Frédéric Caillaud
• 05:19   Re: Caching of Queries Pierre-Frédéric Caillaud
• 17:18   Howto Increased performace ? Amrit Angsusingh
• 17:27   Re: Speed in V8.0 Thomas Wegner
• 17:27   Speed in V8.0 Thomas Wegner
• 17:52   Re: Speed in V8.0 Matt Clark
• 18:38   Re: Howto Increased performace ? Ragnar Hafstað
• 18:43   Re: Speed in V8.0 Ragnar Hafstað

27 December 2004

• 04:28   Re: Howto Increased performace ? Iain
• 12:33   Re: Howto Increased performace ? Iain
• 16:45   Re: Some Performance Advice Needed Jeff
• 20:33   user defined data type problem while dumping? sarlav kumar
• 21:07   Re: Howto Increased performace ? Ragnar Hafstað
• 21:53   Wrong Stats and Poor Performance Pallav Kalva
• 22:27   Re: Wrong Stats and Poor Performance John A Meinel
• 22:51   Re: Wrong Stats and Poor Performance Pallav Kalva
• 23:33   Re: Wrong Stats and Poor Performance John A Meinel
• 23:52   Re: Wrong Stats and Poor Performance Greg Stark

28 December 2004

• 08:48   Re: Howto Increased performace ? Iain
• 09:37   Re: Howto Increased performace ? Iain
• 09:51   Re: Howto Increased performace ? Iain

29 December 2004

• 07:03   Re: slony replication Robert Treat

31 December 2004

• 01:06   sudden drop in statement turnaround latency -- yay!. Merlin Moncure
• 06:03   Re: Speed in V8.0 Thomas Wegner
• 06:05   Re: Speed in V8.0 Thomas Wegner
• 06:08   Re: Howto Increased performace ? Cosimo Streppone
• 06:08   Re: Why so much time difference with a same query/plan? Karl Vogel
• 08:31   Re: sudden drop in statement turnaround latency -- yay!. Tom Lane
• 08:48   Optimization while compiling Vishal Kashyap @ [SaiHertz]
• 08:57   Re: Why so much time difference with a same query/plan? Bruno Wolff III