Search

Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-performance - December 2004

Search archives
	(enter a message-id to go directly to that message)	Advanced Search

Prev | Next

2004-12-01

• Re: Hardware purchase question Josh Berkus (00:26)
• Re: FW: Index usage BBI Edwin Punzalan (01:50)
• Re: FW: Index usage gnari (02:07)
• Re: FW: Index usage BBI Edwin Punzalan (02:33)
• Re: FW: Index usage Iain (04:00)
• Re: FW: Index usage BBI Edwin Punzalan (04:05)
• Using "LIMIT" is much faster even though, searching with PK. 장현성 (04:10)
• Re: FW: Index usage Iain (04:18)
• Re: Using "LIMIT" is much faster even though, searching with PK. Tom Lane (04:26)
• Re: Using "LIMIT" is much faster even though, searching Hyun-Sung, Jang (04:38)
• Re: Using "LIMIT" is much faster even though, searching Josh Berkus (05:03)
• Re: Using "LIMIT" is much faster even though, searching Hyun-Sung, Jang (06:03)
• Re: Using "LIMIT" is much faster even though, searching Andrew McMillan (08:23)
• Re: FW: Index usage gnari (08:24)
• pg_restore taking 4 hours! Rodrigo Carvalhaes (11:16)
• Re: Query Performance and IOWait George Woodring (13:29)
• Re: [PERFORM] pg_restore taking 4 hours! Shridhar Daithankar (14:25)
• Re: [PERFORM] pg_restore taking 4 hours! Riccardo G. Facchini (15:19)
• Re: [PERFORM] pg_restore taking 4 hours! Tom Lane (15:38)
• query with timestamp not using index Brian Hirt (16:46)
• Re: query with timestamp not using index Richard Huxton (17:38)
• Re: query with timestamp not using index Tom Lane (20:06)
• Re: [PERFORM] pg_restore taking 4 hours! Josh Berkus (20:19)
• Re: Using "LIMIT" is much faster even though, searching Josh Berkus (20:25)
• Re: query with timestamp not using index Brian Hirt (22:09)
• Re: query with timestamp not using index Tom Lane (22:16)
• Alternatives to Dell? Josh Berkus (22:24)
• Re: Alternatives to Dell? Bruce Momjian (22:25)
• Re: Alternatives to Dell? Geoffrey (22:38)
• Re: Alternatives to Dell? Frank Wiles (22:41)
• Re: Alternatives to Dell? Merlin Moncure (22:43)
• Re: Alternatives to Dell? Mike Rylander (22:48)
• Re: Alternatives to Dell? Joshua D. Drake (23:13)
• Re: Off-list Re: Alternatives to Dell? Josh Berkus (23:35)

2004-12-02

• Re: Alternatives to Dell? Steven Rosenstein (00:17)
• Recommended Specs Hasnul Fadhly bin Hasan (00:20)
• Re: Alternatives to Dell? Matthew Marlowe (01:35)
• Re: Alternatives to Dell? Geoffrey (01:58)
• Re: Alternatives to Dell? Iain (02:10)
• Re: Alternatives to Dell? Joshua D. Drake (02:15)
• Re: Alternatives to Dell? Geoffrey (02:21)
• Re: Off-list Re: Alternatives to Dell? Sven Willenberger (02:23)
• Re: Alternatives to Dell? Anjan Dave (03:48)
• Re: Alternatives to Dell? Geoffrey (03:56)
• Re: Recommended Specs Josh Berkus (06:15)
• Re: Alternatives to Dell? Robin Ericsson (08:43)
• Re: Alternatives to Dell? Steinar H. Gunderson (10:59)
• Re: Alternatives to Dell? Steinar H. Gunderson (11:00)
• Re: Alternatives to Dell? Dave Cramer (12:06)
• Re: Alternatives to Dell? Geoffrey (13:12)
• pg replication tools? sarlav kumar (14:38)
• Re: Alternatives to Dell? Joe Conway (14:42)
• Re: pg_restore taking 4 hours! Thierry Missimilly (15:46)
• Re: VACUUM ANALYZE downgrades performance Dmitry Karasik (16:07)
• Re: VACUUM ANALYZE downgrades performance Rod Taylor (16:25)
• Re: VACUUM ANALYZE downgrades performance Steinar H. Gunderson (16:30)
• Re: VACUUM ANALYZE downgrades performance Shridhar Daithankar (16:38)
• Re: Alternatives to Dell? Thomas F.O'Connell (16:47)
• Re: pg replication tools? Joshua D. Drake (16:50)
• Re: pg_restore taking 4 hours! Joshua D. Drake (16:53)
• Re: pg replication tools? Darcy Buskermolen (16:58)
• Normalization or Performance Alvaro Nunes Melo (17:05)
• Different location or different instance Gabriele Bartolini (17:16)
• Re: pg_restore taking 4 hours! Andrew McMillan (17:58)
• Re: Normalization or Performance Richard Huxton (18:34)
• Re: Alternatives to Dell? Merlin Moncure (18:39)
• Poor Performance on a table Pallav Kalva (19:11)
• Re: Poor Performance on a table Frank Wiles (19:20)
• Re: [PERFORM] scalability issues on win32 Merlin Moncure (19:21)
• Re: [PERFORM] scalability issues on win32 Bruce Momjian (19:28)
• Re: Poor Performance on a table Pallav Kalva (19:32)
• Re: Poor Performance on a table Tom Lane (19:36)
• Re: Poor Performance on a table Frank Wiles (19:38)
• Re: [PERFORM] scalability issues on win32 Tom Lane (19:42)
• Re: Poor Performance on a table Pallav Kalva (19:54)
• Re: Poor Performance on a table Tom Lane (20:10)
• Re: Normalization or Performance Jim C. Nasby (23:03)

2004-12-03

• Re: Normalization or Performance Iain (01:44)
• Re: pg replication tools? Christopher Browne (02:39)
• Re: pg replication tools? Vishal Kashyap @ [SaiHertz] (05:16)
• Re: Poor Performance on a table Josh Berkus (05:57)
• Re: VACUUM ANALYZE downgrades performance Dmitry Karasik (10:42)
• Re: Alternatives to Dell? Cott Lang (14:19)
• Re: Alternatives to Dell? Joshua D. Drake (14:30)
• Re: Alternatives to Dell? Cott Lang (14:33)
• Re: Alternatives to Dell? Joshua D. Drake (14:38)
• Re: Alternatives to Dell? Cott Lang (16:55)
• DB2 feature Pailloncy Jean-Gérard (20:38)
• Re: DB2 feature Josh Berkus (21:02)
• Performance difference in similar queries Kiran Mukhyala (22:12)
• Re: DB2 feature Christopher Browne (22:27)
• Performance difference in similar queries Kiran Mukhyala (22:31)
• Re: DB2 feature Pailloncy Jean-Gérard (22:48)

2004-12-04

• Re: Alternatives to Dell? Mike Rylander (01:53)
• Overhead of dynamic query in trigger Sven Willenberger (03:46)
• Improve BULK insertion Grupos (13:39)
• Re: Improve BULK insertion Patrick Hatcher (14:47)
• Re: Improve BULK insertion Christopher Browne (14:48)
• lock problem sarlav kumar (16:56)
• Re: Alternatives to Dell? Cott Lang (17:22)
• Re: lock problem Stephan Szabo (17:34)
• Re: Improve BULK insertion Josh Berkus (19:14)

2004-12-05

• Partitioned table performance Stacy White (02:45)
• Re: pg_restore taking 4 hours! Rodrigo Carvalhaes (19:43)
• Re: Improve BULK insertion Rodrigo Carvalhaes (19:52)
• Re: Improve BULK insertion Gregory S. Williamson (22:48)
• Re: Partitioned table performance Josh Berkus (23:06)
• Re: Improve BULK insertion Josh Berkus (23:19)

2004-12-06

• 8.0 vs. 7.4 benchmarks Postgres Learner (09:28)
• TableSpace Design issues on Postgres 8.0 beta 5 Rosny (13:52)
• Config review Bryan Vest (14:40)
• Config Check Bryan (14:43)
• Re: Config Check Pierre-Frédéric Caillaud (15:18)
• Poor Query Pallav Kalva (15:28)
• Re: Poor Query Pierre-Frédéric Caillaud (15:48)
• Re: Poor Query Pallav Kalva (15:52)
• Re: Config Check Tom Lane (15:56)
• Re: Poor Query Pierre-Frédéric Caillaud (16:16)
• Re: Poor Query Pallav Kalva (16:37)
• Processor optimization compile options? Josh Berkus (17:26)
• Re: Poor Query Pierre-Frédéric Caillaud (17:34)
• Re: Poor Query Pallav Kalva (18:00)
• Re: Alternatives to Dell? Andrew Sullivan (18:57)
• Re: Poor Query Pierre-Frédéric Caillaud (20:18)
• Re: TableSpace Design issues on Postgres 8.0 beta 5 Rosny (20:28)
• Re: Poor Query Pallav Kalva (20:44)
• scaling beyond 4 processors vogler (22:18)

2004-12-07

• Re: Config Check Hasnul Fadhly bin Hasan (02:40)
• Re: scaling beyond 4 processors Jeff (02:52)
• Re: Config Check John A Meinel (02:54)
• Re: scaling beyond 4 processors Christopher Browne (04:16)
• Re: scaling beyond 4 processors Christopher Browne (04:17)
• Re: TableSpace Design issues on Postgres 8.0 beta 5 Tom Lane (04:44)
• Re: Config Check Tom Lane (05:03)
• Re: TableSpace Design issues on Postgres 8.0 beta 5 Rosny (07:58)
• Re: Config review Greg Stark (08:03)
• Fwd: 8.0 vs. 7.4 benchmarks Postgres Learner (09:17)
• Re: pg_restore taking 4 hours! Hannu Krosing (11:08)
• Re: Fwd: 8.0 vs. 7.4 benchmarks Bruno Wolff III (14:52)
• Re: Config review Tom Lane (15:07)
• Re: Config review Andrew Sullivan (15:19)
• Re: Fwd: 8.0 vs. 7.4 benchmarks Joshua D. Drake (16:43)
• Re: Fwd: 8.0 vs. 7.4 benchmarks Bruno Wolff III (17:43)
• Re: scaling beyond 4 processors Josh Berkus (17:49)
• Re: Fwd: 8.0 vs. 7.4 benchmarks Joshua D. Drake (18:35)

2004-12-08

• Slow insert Christopher Kings-Lynne (02:42)
• Re: Partitioned table performance Stacy White (04:32)

2004-12-10

• Query is not using index when it should Tomas =?iso-8859-1?q?Sk=E4re?= (11:40)
• LIMIT causes SEQSCAN in subselect Mike Rylander (18:40)

2004-12-11

• Re: Slow insert Steinar H. Gunderson (01:45)
• Re: Query is not using index when it should Stephan Szabo (02:28)
• Re: LIMIT causes SEQSCAN in subselect Josh Berkus (05:40)
• Re: Partitioned table performance Josh Berkus (05:52)
• Re: Query is not using index when it should Tomas =?iso-8859-1?q?Sk=E4re?= (14:17)
• Re: [GENERAL] Query is not using index when it should Steinar H. Gunderson (14:32)
• Re: LIMIT causes SEQSCAN in subselect Mike Rylander (14:37)
• Re: [GENERAL] Query is not using index when it should Michael Fuhr (16:25)
• Very different index usage on similar tables Alvaro Nunes Melo (17:01)
• Re: LIMIT causes SEQSCAN in subselect Tom Lane (18:06)

2004-12-12

• Re: [GENERAL] Query is not using index when it should Tomas =?iso-8859-1?q?Sk=E4re?= (08:32)

2004-12-13

• Re: Query is not using index when it should Josh Berkus (02:48)
• Using LIMIT changes index used by planner Sven Willenberger (06:13)
• Re: Using LIMIT changes index used by planner Andrew McMillan (09:56)
• INSERT question sarlav kumar (16:28)
• Re: Hardware purchase question Vivek Khera (16:33)
• Re: pg_restore taking 4 hours! Vivek Khera (16:37)
• Re: Alternatives to Dell? Vivek Khera (16:47)
• Re: INSERT question Tom Lane (16:48)
• Re: INSERT question Bruno Wolff III (16:49)
• Similar tables, different indexes performance Alvaro Nunes Melo (17:17)
• Re: Off-list Re: Alternatives to Dell? Vivek Khera (17:19)
• Re: Hardware purchase question Joshua D. Drake (17:23)
• Re: Similar tables, different indexes performance Bruno Wolff III (18:03)
• Re: Alternatives to Dell? Bruce Momjian (18:20)
• Re: pg_restore taking 4 hours! Josh Berkus (18:25)
• Re: INSERT question sarlav kumar (18:31)
• Re: Hardware purchase question Josh Berkus (18:31)
• Re: INSERT question sarlav kumar (18:33)
• Re: pg_restore taking 4 hours! Josh Berkus (18:43)
• Re: pg_restore taking 4 hours! Tom Lane (19:21)
• Re: Similar tables, different indexes performance Alvaro Nunes Melo (19:32)
• Re: Using LIMIT changes index used by planner Sven Willenberger (22:06)
• Re: Using LIMIT changes index used by planner Tom Lane (22:43)

2004-12-14

• Trying to create multi db query in one large queries Hasnul Fadhly bin Hasan (01:44)
• Re: pg_restore taking 4 hours! Iain (01:54)
• Re: Trying to create multi db query in one large querie Spiegelberg, Greg (04:07)
• Re: Similar tables, different indexes performance Bruno Wolff III (05:22)
• Re: Trying to create multi db query in one large querie Joe Conway (06:59)
• Re: Trying to create multi db query in one large queries Josh Berkus (07:18)
• Re: Hardware purchase question Andrew Hood (09:33)
• Speeding up pg_dump Rod Taylor (17:36)
• Re: Anything to be gained from a 'Postgres Filesystem'? Markus Schaber (18:20)
• Re: Using LIMIT changes index used by planner Sven Willenberger (18:28)
• Re: Using LIMIT changes index used by planner Tom Lane (19:35)
• Query Optimization sarlav kumar (21:34)
• Re: Speeding up pg_dump Simon Riggs (23:11)

2004-12-15

• Re: Partitioned table performance Stacy White (06:09)
• \d output to a file sarlav kumar (14:38)
• Re: [despammed] \d output to a file Andreas Kretschmer (15:04)
• Re: [PERFORM] \d output to a file Gary Cowell (15:12)

Prev | Next