Peripheral Links

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

pgsql-performance - October 2003

2003-10-01

• Re: Tuning/performance issue... Tom Lane (04:28)
• Re: Tuning/performance issue... David Griffiths (05:48)
• Re: Tuning/performance issue.... Shridhar Daithankar (07:05)
• Re: inferior SCSI performance Andrew Sullivan (10:33)
• What is the fastest null WHERE Mindaugas Riauba (12:11)
• Re: Tuning/performance issue... Jeff (12:23)
• Re: What is the fastest null WHERE Shridhar Daithankar (12:32)
• Re: What is the fastest null WHERE Richard Huxton (12:39)
• Re: What is the fastest null WHERE Rod Taylor (12:51)
• Re: What is the fastest null WHERE Mindaugas Riauba (13:05)
• Re: inferior SCSI performance scott.marlowe (13:14)
• Re: TPC-R benchmarks scott.marlowe (13:23)
• Re: inferior SCSI performance Andrew Sullivan (13:25)
• Re: Tuning/performance issue... Tom Lane (14:14)
• Ideal Hardware? Jason Hihn (15:13)
• Joins on inherited tables apb18 (16:14)
• Re: inferior SCSI performance Christopher Browne (16:21)
• Re: Tuning/performance issue... Oleg Lebedev (16:51)
• Re: TPC-R benchmarks George Essig (16:55)
• Re: TPC-R benchmarks Josh Berkus (17:08)
• Re: Joins on inherited tables Tom Lane (17:14)
• Re: TPC-R benchmarks Oleg Lebedev (17:29)
• Optimizing >= and <= for numbers and dates Dimitri Nagiev (17:30)
• Re: Optimizing >= and <= for numbers and dates Rod Taylor (17:38)
• Re: Ideal Hardware? Josh Berkus (17:38)
• Re: TPC-R benchmarks Josh Berkus (17:41)
• Re: Tuning/performance issue... Jeff (17:42)
• Re: Tuning/performance issue... Oleg Lebedev (17:43)
• Re: Optimizing >= and <= for numbers and dates Dimitri Nagiev (17:45)
• Re: TPC-R benchmarks Oleg Lebedev (17:59)
• Re: Optimizing >= and <= for numbers and dates Neil Conway (18:35)
• Re: Optimizing >= and <= for numbers and dates scott.marlowe (19:03)
• Re: Optimizing >= and <= for numbers and dates scott.marlowe (19:04)
• Re: Optimizing >= and <= for numbers and dates Manfred Koizar (19:06)
• Re: TPC-R benchmarks Oleg Lebedev (21:02)
• Re: TPC-R benchmarks scott.marlowe (21:59)
• Re: TPC-R benchmarks Tom Lane (22:19)
• Re: TPC-R benchmarks Josh Berkus (22:23)

2003-10-02

• Re: Ideal Hardware? ghaverla (00:19)
• Re: Ideal Hardware? Josh Berkus (01:10)
• Re: inferior SCSI performance Hannu Krosing (07:13)
• Re: inferior SCSI performance Greg Stark (08:00)
• Re: inferior SCSI performance Ang Chin Han (08:54)
• basket, eggs & NAS (was eggs Re: Ideal Hardware?) Ron Johnson (09:28)
• runtime of the same query in function differs on 2 degree! Andriy Tkachuk (13:39)
• Re: TPC-R benchmarks Oleg Lebedev (14:29)
• Re: runtime of the same query in function differs on 2 degree! Tom Lane (15:30)
• Re: TPC-R benchmarks Oleg Lebedev (16:18)
• Re: TPC-R benchmarks Josh Berkus (16:22)
• Re: TPC-R benchmarks scott.marlowe (16:29)
• low cardinality column rwu.cbnco.com (17:03)
• low cardinality column Rong Wu (18:30)
• Re: low cardinality column Josh Berkus (18:37)
• Re: low cardinality column Rod Taylor (18:50)
• Re: low cardinality column Bill Moran (19:00)
• count(*) slow on large tables Dror Matalon (19:15)
• further testing on IDE drives scott.marlowe (19:34)
• Re: count(*) slow on large tables Tomasz Myrta (19:36)
• Re: count(*) slow on large tables Bruno Wolff III (19:39)
• Re: TPC-R benchmarks Oleg Lebedev (19:39)
• Re: TPC-R benchmarks scott.marlowe (19:44)
• Re: count(*) slow on large tables Bruno Wolff III (19:58)
• Thanks - Re: low cardinality column Rong Wu (20:11)
• Re: inferior SCSI performance Vivek Khera (20:16)
• Re: count(*) slow on large tables Jean-Luc Lachance (21:29)
• Re: count(*) slow on large tables Christopher Browne (21:57)
• Re: TPC-R benchmarks Oleg Lebedev (22:27)
• Re: count(*) slow on large tables Dror Matalon (22:33)
• Re: further testing on IDE drives scott.marlowe (23:35)
• Re: runtime of the same query in function differs on 2 degree! Gaetano Mendola (23:52)

2003-10-03

• Re: count(*) slow on large tables Christopher Browne (02:08)
• Is This My Speed Limit? CN (02:14)
• Re: count(*) slow on large tables Dror Matalon (04:27)
• Re: count(*) slow on large tables Greg Stark (05:13)
• Re: TPC-R benchmarks Josh Berkus (05:27)
• Re: Is This My Speed Limit? Tomasz Myrta (05:59)
• Re: count(*) slow on large tables Gregory S. Williamson (06:22)
• Re: count(*) slow on large tables Shridhar Daithankar (06:29)
• A Basic Question shyamperi (06:34)
• Re: runtime of the same query in function differs on 2 Andriy Tkachuk (07:02)
• Re: A Basic Question Richard Huxton (10:10)
• Re: count(*) slow on large tables Christopher Browne (11:37)
• Re: count(*) slow on large tables Jeff (12:36)
• Postgres low end processing. Stef (14:30)
• Re: Is This My Speed Limit? scott.marlowe (14:47)
• Re: Postgres low end processing. Tom Lane (15:42)
• Re: count(*) slow on large tables Jean-Luc Lachance (15:48)
• Re: Postgres low end processing. Stef (16:10)
• Re: Postgres low end processing. Tom Lane (16:32)
• Re: count(*) slow on large tables Hilary Forbes (16:50)
• Re: TPC-R benchmarks Oleg Lebedev (16:54)
• Re: TPC-R benchmarks Josh Berkus (17:21)
• Re: Postgres low end processing. Stef (17:52)
• Re: TPC-R benchmarks Oleg Lebedev (18:04)
• Re: Postgres low end processing. Josh Berkus (18:08)
• Re: Postgres low end processing. Ron Johnson (18:34)
• Re: Postgres low end processing. Neil Conway (19:04)
• Re: Postgres low end processing. scott.marlowe (19:13)
• Re: Postgres low end processing. Richard Welty (19:51)
• Speeding up Aggregates Dror Matalon (20:21)
• Re: Joins on inherited tables apb18 (20:21)
• reindex/vacuum locking/performance? Rob Nagler (20:24)
• Re: [PERFORM] Postgres low end processing. Ron Johnson (20:42)
• Re: reindex/vacuum locking/performance? Tom Lane (20:57)
• Re: Speeding up Aggregates Josh Berkus (21:07)
• Re: Speeding up Aggregates Dror Matalon (21:28)
• Re: reindex/vacuum locking/performance? Christopher Browne (21:34)
• Re: Speeding up Aggregates Josh Berkus (21:35)
• Re: Speeding up Aggregates Rod Taylor (21:44)
• Re: reindex/vacuum locking/performance? Rob Nagler (21:47)
• Re: Speeding up Aggregates Dror Matalon (21:53)
• Re: count(*) slow on large tables Christopher Browne (21:55)
• Re: reindex/vacuum locking/performance? Bruno Wolff III (21:59)
• Re: Speeding up Aggregates Dror Matalon (22:03)
• Re: Speeding up Aggregates Rod Taylor (22:10)
• Re: reindex/vacuum locking/performance? Neil Conway (22:11)
• Re: Speeding up Aggregates Dror Matalon (22:16)
• Re: reindex/vacuum locking/performance? Matt Clark (23:21)
• Re: reindex/vacuum locking/performance? Josh Berkus (23:24)
• Re: reindex/vacuum locking/performance? Matt Clark (23:29)
• Re: Speeding up Aggregates Rod Taylor (23:32)
• Re: reindex/vacuum locking/performance? Matt Clark (23:44)
• Re: reindex/vacuum locking/performance? Neil Conway (23:48)

2003-10-04

• Re: reindex/vacuum locking/performance? Matt Clark (00:14)
• Re: Tuning/performance issue... Bruce Momjian (01:39)
• Re: Tuning/performance issue... Rod Taylor (02:22)
• Re: Tuning/performance issue... Christopher Browne (02:37)
• Re: Tuning/performance issue... Bruce Momjian (02:38)
• Re: reindex/vacuum locking/performance? Tom Lane (03:49)
• Re: Tuning/performance issue... Tom Lane (03:58)
• Re: [HACKERS] Index/Function organized table layout (from Re: Hannu Krosing (09:00)
• Re: count(*) slow on large tables Christopher Kings-Lynne (09:37)
• Re: Tuning/performance issue... Jeff (12:56)
• Re: reindex/vacuum locking/performance? Andrew Sullivan (15:18)
• Re: reindex/vacuum locking/performance? Andrew Sullivan (15:22)
• Re: reindex/vacuum locking/performance? Andrew Sullivan (15:23)
• Re: count(*) slow on large tables Bruce Momjian (15:56)
• COUNT(*) again (was Re: [HACKERS] Index/Function organized table layout) Tom Lane (16:07)
• Re: count(*) slow on large tables Tom Lane (16:49)
• Re: count(*) slow on large tables Bruce Momjian (17:48)
• Re: count(*) slow on large tables Tom Lane (17:51)
• Re: count(*) slow on large tables Bruce Momjian (18:19)
• Re: count(*) slow on large tables Tom Lane (18:34)
• Re: COUNT(*) again (was Re: [HACKERS] Index/Function Hannu Krosing (20:59)
• Uses for Index/Function organizing James Rogers (21:15)
• Re: COUNT(*) again (was Re: [HACKERS] Index/Function organized table layout) Tom Lane (21:15)
• Re: count(*) slow on large tables Christopher Browne (23:33)

2003-10-05

• Re: COUNT(*) again (was Re: [HACKERS] Index/Function organized Bruce Momjian (04:20)
• Re: COUNT(*) again (was Re: [HACKERS] Index/Function organized table layout) Tom Lane (06:08)
• Re: reindex/vacuum locking/performance? Matt Clark (11:14)
• Re: COUNT(*) again (was Re: [HACKERS] Index/Function organized Bruce Momjian (13:36)
• Re: reindex/vacuum locking/performance? Andrew Sullivan (14:34)
• Re: reindex/vacuum locking/performance? Matt Clark (16:46)
• Re: reindex/vacuum locking/performance? Tom Lane (17:11)
• Re: reindex/vacuum locking/performance? Matt Clark (17:59)
• Re: reindex/vacuum locking/performance? Tom Lane (18:07)
• Re: reindex/vacuum locking/performance? Matt Clark (18:43)
• Re: count(*) slow on large tables Josh Berkus (18:57)
• Re: count(*) slow on large tables Rod Taylor (19:11)
• Re: reindex/vacuum locking/performance? Christopher Browne (21:57)
• Re: reindex/vacuum locking/performance? Neil Conway (23:32)
• Re: reindex/vacuum locking/performance? Tom Lane (23:43)
• Re: reindex/vacuum locking/performance? Neil Conway (23:50)

2003-10-06

• Re: reindex/vacuum locking/performance? Andrew Sullivan (02:01)
• Re: reindex/vacuum locking/performance? Ronald Khoo (03:07)
• Re: count(*) slow on large tables Shridhar Daithankar (06:06)
• Re: Postgres low end processing. Shridhar Daithankar (06:11)
• Re: Postgres low end processing. Stef (07:55)
• Re: reindex/vacuum locking/performance? Jeff (12:07)
• Re: reindex/vacuum locking/performance? Andrew Sullivan (12:15)
• Re: reindex/vacuum locking/performance? Shridhar Daithankar (12:19)
• Re: Postgres low end processing. Bruno Wolff III (13:29)
• locking/performance, Solaris performance discovery Jeff (13:33)
• Re: locking/performance, Solaris performance discovery Tom Lane (14:30)
• Re: count(*) slow on large tables Harald Fuchs (15:08)
• Re: locking/performance, Solaris performance discovery Jeff (15:16)
• Shopping for hardware Jason Hihn (15:17)
• Re: Shopping for hardware scott.marlowe (15:43)
• Re: Shopping for hardware Vivek Khera (16:21)
• Re: Shopping for hardware Josh Berkus (16:33)
• Seqscan buffer promotion (was: reindex/vacuum locking/performance?) James Rogers (16:55)
• Re: count(*) slow on large tables Sean Chittenden (17:01)
• SOlaris updates Jeff (17:58)
• Re: reindex/vacuum locking/performance? Neil Conway (18:14)
• Re: Postgres low end processing. Josh Berkus (18:21)
• Re: reindex/vacuum locking/performance? Tom Lane (18:26)
• Re: reindex/vacuum locking/performance? Larry Rosenman (18:39)
• Re: reindex/vacuum locking/performance? Bruce Momjian (18:56)
• Re: reindex/vacuum locking/performance? Jason Hihn (19:14)

2003-10-07

• Re: Postgres low end processing. Stef (15:28)
• Re: Postgres low end processing. Jeff (15:40)
• Re: TPC-R benchmarks Timothy D. Witham (18:34)
• Re: TPC-R benchmarks Josh Berkus (23:59)

2003-10-08

• Re: TPC-R benchmarks Tom Lane (04:15)
• Sun performance - Major discovery! Jeff (12:36)
• IMMUTABLE function's flag do not work: 7.3.4, plpgsql Andriy Tkachuk (13:16)
• Compare rows Greg Spiegelberg (14:07)
• planner doesn't use multicolumn index Adrian Demaestri (14:08)
• Re: planner doesn't use multicolumn index Tomasz Myrta (14:18)
• Re: planner doesn't use multicolumn index Shridhar Daithankar (14:27)