Peripheral Links

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

pgsql-performance - June 2005

2005-06-01

• Re: postgresql-8.0.1 performance tuning Cosimo Streppone (05:30)
• Re: Index on a NULL-value Tobias Brox (05:42)
• Re: postgresql-8.0.1 performance tuning Mark Kirkwood (06:33)
• Re: postgresql-8.0.1 performance tuning Cosimo Streppone (06:44)
• Re: postgresql-8.0.1 performance tuning Mark Kirkwood (07:22)
• How to avoid database bloat Mindaugas Riauba (07:43)
• Re: How to avoid database bloat stig erikson (08:13)
• Re: postgresql-8.0.1 performance tuning Martin Fandel (08:50)
• Re: very large table Simon Riggs (08:57)
• Re: slow queries, possibly disk io Simon Riggs (09:06)
• TIP 9: the planner will ignore... & datatypes Marc Mamin (09:45)
• Re: postgresql-8.0.1 performance tuning Steinar H. Gunderson (09:57)
• Re: postgresql-8.0.1 performance tuning Cosimo Streppone (10:22)
• Re: postgresql-8.0.1 performance tuning Martin Fandel (10:26)
• Re: TIP 9: the planner will ignore... & datatypes Alvaro Herrera (13:40)
• Re: How to avoid database bloat Tom Lane (14:39)
• Moving pg_xlog Keith Worthington (15:31)
• Re: Moving pg_xlog Tom Lane (16:19)
• Most effective tuning choices for busy website? Mark Stosberg (19:19)
• Re: Moving pg_xlog Keith Worthington (20:11)
• Performance nightmare with dspam (urgent) Casey Allen Shobe (20:19)
• Re: Moving pg_xlog Tom Lane (20:30)
• Re: Moving pg_xlog Brad Nicholson (20:31)
• Re: Moving pg_xlog John A Meinel (21:27)

2005-06-02

• Forcing use of specific index Tobias Brox (02:05)
• Adaptec/LSI/?? RAID Stacy White (03:42)
• Re: Adaptec/LSI/?? RAID Sven Willenberger (04:35)
• Re: Adaptec/LSI/?? RAID William Yu (05:00)
• Re: Moving pg_xlog Tom Lane (06:06)
• Re: 'Fastest' PC's are slowest in the house Grega Bremec (06:32)
• Re: Moving pg_xlog Himanshu Baweja (07:02)
• Re: How to avoid database bloat Mindaugas Riauba (07:28)
• Re: SURVEY: who is running postgresql on 8 or more CPUs? Dirk Lutzebäck (08:28)
• Re: Adaptec/LSI/?? RAID Andrew McMillan (09:15)
• BUG #1697: Select getting slower on continously updating data Bahadur Singh (11:05)
• Re: Adaptec/LSI/?? RAID Richard Welty (11:50)
• Re: SURVEY: who is running postgresql on 8 or more CPUs? Dawid Kuroczko (12:12)
• Re: SURVEY: who is running postgresql on 8 or more CPUs? Dirk Lutzebäck (12:28)
• Re: postgresql-8.0.1 performance tuning Martin Fandel (12:50)
• Re: BUG #1697: Select getting slower on continously updating data Bruno Wolff III (13:02)
• Re: postgresql-8.0.1 performance tuning Martin Fandel (13:10)
• Re: postgresql-8.0.1 performance tuning Martin Fandel (13:12)
• Re: How to avoid database bloat Tom Lane (13:45)
• Re: Moving pg_xlog Tom Lane (14:23)
• Re: How to avoid database bloat Mindaugas Riauba (14:24)
• Re: Moving pg_xlog Himanshu Baweja (14:47)
• Re: Specific query performance problem help requested - postgresql 7.4 Brad Might (15:03)
• Query plan for very large number of joins philb (15:25)
• Re: SURVEY: who is running postgresql on 8 or more CPUs? ohp (15:57)
• Re: Query plan for very large number of joins Richard Huxton (16:02)
• Re: How to avoid database bloat Matthew T. O'Connor (16:10)
• Re: How to avoid database bloat Tom Lane (16:10)
• Re: Query plan for very large number of joins Tom Lane (16:26)
• Re: Adaptec/LSI/?? RAID J. Andrew Rogers (17:10)
• Re: Adaptec/LSI/?? RAID Joshua D. Drake (17:42)
• Re: Adaptec/LSI/?? RAID Vivek Khera (17:47)
• Re: Query plan for very large number of joins PFC (20:15)
• Re: Adaptec/LSI/?? RAID (what about JBOD?) mudfoot (21:02)
• Re: Query plan for very large number of joins Sebastian Hennebrueder (22:23)
• Re: Adaptec/LSI/?? RAID (what about JBOD?) Andrew McMillan (23:19)

2005-06-03

• Re: Adaptec/LSI/?? RAID (what about JBOD?) mudfoot (00:30)
• SELECT DISTINCT Performance Issue K C Lau (01:56)
• Re: How to avoid database bloat matthew (03:38)
• SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance tuning) Paul McGarry (03:45)
• Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance Mark Kirkwood (06:11)
• Query limitations (size, number of UNIONs ...) Marc Mamin (06:35)
• Filesystem Martin Fandel (07:06)
• Re: BUG #1697: Select getting slower on continously updating data Bahadur Singh (07:09)
• Re: Adaptec/LSI/?? RAID Cosimo Streppone (07:37)
• Re: How to avoid database bloat Mindaugas Riauba (08:41)
• Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance tuning) Martin Fandel (08:49)
• Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance Mark Kirkwood (09:10)
• Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance tuning) Martin Fandel (09:19)
• Re: Filesystem Mark Kirkwood (10:41)
• Re: Query plan for very large number of joins philb (12:22)
• Re: Query plan for very large number of joins Tom Lane (13:15)
• Re: Filesystem Alex Turner (13:18)
• Re: Query limitations (size, number of UNIONs ...) Stephen Frost (13:27)
• Re: Filesystem Martin Fandel (13:52)
• Re: Query plan for very large number of joins philb (14:24)
• Re: BUG #1697: Select getting slower on continously updating data Bruno Wolff III (14:49)
• Re: How to avoid database bloat Matthew T. O'Connor (16:43)
• Re: Filesystem J. Andrew Rogers (17:18)
• Re: Query plan for very large number of joins Tom Lane (17:29)
• Postgresql and Software RAID/LVM Steve Poe (18:45)
• Re: Need help to decide Mysql vs Postgres Bill Ewing (20:01)
• Re: Postgresql and Software RAID/LVM Joshua D. Drake (22:03)
• Insert slow down on empty database Morgan (23:13)
• Re: Forcing use of specific index William Yu (23:22)
• Re: Query plan for very large number of joins Simon Riggs (23:23)

2005-06-04

• Re: Insert slow down on empty database Christopher Browne (01:20)
• Re: Forcing use of specific index Junaili Lie (01:52)
• strategies for optimizing read on rather large tables hubert lubaczewski (08:17)
• Re: Query plan for very large number of joins philb (10:04)
• Re: strategies for optimizing read on rather large tables Christopher Kings-Lynne (11:17)
• Re: strategies for optimizing read on rather large tables PFC (11:18)
• Re: strategies for optimizing read on rather large tables hubert lubaczewski (11:40)
• Re: strategies for optimizing read on rather large tables hubert lubaczewski (11:41)
• Re: strategies for optimizing read on rather large tables PFC (12:07)
• Re: strategies for optimizing read on rather large tables hubert lubaczewski (12:13)
• Best hardware Bernd Jagla (13:30)
• Re: Forcing use of specific index Qingqing Zhou (14:14)
• Re: Best hardware Mischa Sandberg (23:23)

2005-06-06

• Re: Need help to decide Mysql vs Postgres Christopher Kings-Lynne (01:57)
• Re: Most effective tuning choices for busy website? Neil Conway (02:04)
• Re: Postgresql and Software RAID/LVM Andrew McMillan (06:48)
• Re: SELECT DISTINCT Performance Issue PFC (11:45)
• Re: Need help to decide Mysql vs Postgres PFC (11:54)
• Re: SELECT DISTINCT Performance Issue K C Lau (14:54)
• Re: Performance nightmare with dspam (urgent) (resolved) Casey Allen Shobe (14:54)
• Re: How to avoid database bloat Mindaugas Riauba (14:58)
• Re: Performance nightmare with dspam (urgent) (resolved) John A Meinel (15:08)
• Re: Performance nightmare with dspam (urgent) (resolved) PFC (15:11)
• Re: Performance nightmare with dspam (urgent) (resolved) Michael Stone (15:19)
• Re: Need help to decide Mysql vs Postgres Jeffrey Tenny (15:51)
• Re: Performance nightmare with dspam (urgent) (resolved) John A Meinel (15:52)
• Re: Need help to decide Mysql vs Postgres Amit V Shah (16:00)
• Re: Performance nightmare with dspam (urgent) (resolved) Casey Allen Shobe (16:04)
• Re: Need help to decide Mysql vs Postgres Alvaro Herrera (16:15)
• Re: Need help to decide Mysql vs Postgres Rod Taylor (16:22)
• Re: Need help to decide Mysql vs Postgres PFC (16:41)
• Re: Need help to decide Mysql vs Postgres Amit V Shah (16:45)
• slow growing table Jone C (16:48)
• Re: slow growing table Steinar H. Gunderson (17:00)
• Re: Need help to decide Mysql vs Postgres Christopher Browne (17:01)
• Re: slow growing table Steinar H. Gunderson (17:12)
• Re: Need help to decide Mysql vs Postgres Tobias Brox (17:25)
• Re: Performance nightmare with dspam (urgent) (resolved) Michael Stone (17:27)
• Postgresql on an AMD64 machine Mark Rinaudo (17:53)
• Re: Need help to decide Mysql vs Postgres PFC (18:12)
• Re: Postgresql on an AMD64 machine Vivek Khera (18:32)
• Re: Need help to decide Mysql vs Postgres Michael Fuhr (18:33)
• Re: Need help to decide Mysql vs Postgres Jan Wieck (18:55)
• Re: Need help to decide Mysql vs Postgres Ron Mayer (19:02)
• Re: Need help to decide Mysql vs Postgres Joel Fradkin (19:12)
• Re: Postgresql and Software RAID/LVM Marty Scholes (19:13)
• Re: Postgresql on an AMD64 machine Mike Rylander (20:59)
• Re: Postgresql on an AMD64 machine Tom Lane (21:15)
• Re: Postgresql on an AMD64 machine Mark Rinaudo (22:28)
• Re: Postgresql on an AMD64 machine Neil Conway (23:48)

2005-06-07

• Re: Postgresql on an AMD64 machine Tom Lane (04:28)
• Re: Postgresql and Software RAID/LVM John A Meinel (04:36)
• Re: Need help to decide Mysql vs Postgres Tom Lane (04:54)
• Re: Performance nightmare with dspam (urgent) Russell Smith (09:43)
• Re: Need help to decide Mysql vs Postgres PFC (12:53)
• Re: Postgresql and Software RAID/LVM Marty Scholes (15:30)
• Debian Stable goes from Woody to Sarge!! brew (15:51)
• Re: Debian Stable goes from Woody to Sarge!! Peter Eisentraut (16:15)
• Re: Postgresql on an AMD64 machine Donald Courtney (19:38)
• Re: Postgresql on an AMD64 machine Tom Arthurs (19:54)
• Re: Postgresql on an AMD64 machine Donald Courtney (20:19)
• Re: Postgresql on an AMD64 machine Joshua D. Drake (20:27)
• Re: Postgresql on an AMD64 machine Alvaro Herrera (20:27)
• Re: Postgresql on an AMD64 machine Tom Arthurs (20:39)
• Re: Postgresql on an AMD64 machine Michael Stone (21:04)
• Re: Postgresql on an AMD64 machine Tom Lane (21:11)
• Re: slow growing table Simon Riggs (22:21)

2005-06-08

• Re: Postgresql on an AMD64 machine Neil Conway (00:20)
• Re: Postgresql on an AMD64 machine John A Meinel (00:44)
• Re: Postgresql on an AMD64 machine Josh Berkus (03:05)
• Re: Postgresql on an AMD64 machine Tom Lane (03:50)
• Re: Postgresql on an AMD64 machine Simon Riggs (06:16)
• Re: Filesystem Martin Fandel (07:36)
• Importing from pg_dump slow, low Disk IO Steve Pollard (09:09)
• full outer performance problem Kim Bisgaard (09:37)
• Re: Postgresql on an AMD64 machine Michael Stone (09:51)
• Re: Filesystem Michael Stone (12:10)
• Re: full outer performance problem Bruno Wolff III (12:17)
• Re: Filesystem Martin Fandel (12:25)
• Re: full outer performance problem Kim Bisgaard (12:32)
• Re: SELECT DISTINCT Performance Issue George Essig (13:34)
• Re: Filesystem Grega Bremec (13:49)
• Re: full outer performance problem Tom Lane (14:03)
• Re: SELECT DISTINCT Performance Issue K C Lau (14:25)
• Re: SELECT DISTINCT Performance Issue George Essig (14:51)
• Performance problems, bad estimates and plan Allan Wang (15:04)
• Re: full outer performance problem Tom Lane (16:23)
• Help specifying new web server/database machine Rory Campbell-Lange (16:34)
• Re: Help specifying new web server/database machine Bjoern Metzdorf (16:41)
• Re: Postgresql on an AMD64 machine Tom Arthurs (16:43)
• Re: Help specifying new web server/database machine Joshua D. Drake (16:48)
• Re: Postgresql on an AMD64 machine Bjoern Metzdorf (16:53)
• Re: Performance problems, bad estimates and plan Tom Lane (17:02)
• Re: Performance problems, bad estimates and plan Tom Lane (17:39)
• Re: Performance problems, bad estimates and plan Tom Lane (17:57)
• Re: Performance problems, bad estimates and plan Tom Lane (18:06)
• Re: full outer performance problem Kim Bisgaard (18:46)
• Re: Help specifying new web server/database machine Matthew Nuzum (18:53)
• Re: full outer performance problem Kim Bisgaard (18:53)
• Help with rewriting query Junaili Lie (19:34)
• Re: Help with rewriting query Tobias Brox (19:56)
• Re: Help with rewriting query Jim Johannsen (20:48)
• Recommendations for configuring a 200 GB database Kevin Grittner (21:04)
• Re: Postgresql on an AMD64 machine Sam Vilain (21:14)
• Re: Help with rewriting query Junaili Lie (22:48)
• Re: Help specifying new web server/database machine William Yu (23:33)

2005-06-09

• Re: Postgresql on an AMD64 machine Neil Conway (00:19)
• Re: Help with rewriting query Bruno Wolff III (02:59)
• Re: Importing from pg_dump slow, low Disk IO Steve Pollard (03:56)
• Re: Help with rewriting query Kevin Grittner (04:01)