pgsql-performance - June 2005

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 27 28 29 30

June 1, 2005

Thread Author Time
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

June 2, 2005

Thread Author Time
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

June 3, 2005

Thread Author Time
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

June 4, 2005

Thread Author Time
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

June 6, 2005

Thread Author Time
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

June 7, 2005

Thread Author Time
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

June 8, 2005

Thread Author Time
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

June 9, 2005

Thread Author Time
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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 27 28 29 30