pgsql-performance - August 2006

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 5 6 7 8 9 10 11 12 14 15 16 17 18 21 22 23 24 25 26 27 28 29 30 31

Aug. 1, 2006

Thread Author Time
Re: Performances with new Intel Core* processors Luke Lonergan 04:26
Are there any performance penalty for opposite edian platform combinations.... Guoping Zhang 05:01
Re: Performances with new Intel Core* processors Florian Weimer 07:28
Re: Are there any performance penalty for opposite edian platform combinations.... Tom Lane 12:10
Re: Fwd: Savepoint performance Ernest Nishiseki 13:09
Query/database optimization Eugeny N Dzhurinsky 13:18
PITR performance overhead? George Pavlov 16:15
Re: PITR performance overhead? Bill Moran 16:59
Re: PostgreSQL scalability on Sun UltraSparc T1 Jim C. Nasby 17:26
Re: PostgreSQL scalability on Sun UltraSparc T1 Arjen van der Meijden 17:49
How to speed up this "translation" query? tlm 18:09
Re: How to speed up this "translation" query? Niklas Johansson 18:38
XFS filessystem for Datawarehousing Milen Kulev 21:49
FW: XFS filessystem for Datawarehousing -2 Milen Kulev 22:19
Re: XFS filessystem for Datawarehousing J. Andrew Rogers 22:46
Re: XFS filessystem for Datawarehousing Milen Kulev 22:59
Re: sub select performance due to seq scans H Hale 23:07

Aug. 2, 2006

Thread Author Time
Re: XFS filessystem for Datawarehousing Alvaro Herrera 00:42
Re: PITR performance overhead? Merlin Moncure 01:17
Re: XFS filessystem for Datawarehousing Mark Kirkwood 02:06
Re: XFS filessystem for Datawarehousing Luke Lonergan 02:42
Re: XFS filessystem for Datawarehousing -2 Luke Lonergan 02:44
Re: Query/database optimization Tom Lane 03:15
Re: Query/database optimization Eugeny N Dzhurinsky 10:56
Re: sub select performance due to seq scans H Hale 12:17
Re: sub select performance due to seq scans Scott Marlowe 16:48
Re: XFS filessystem for Datawarehousing Milen Kulev 20:59
Re: XFS filessystem for Datawarehousing Steve Poe 21:26
Re: XFS filessystem for Datawarehousing Milen Kulev 21:44
Re: XFS filessystem for Datawarehousing Chris Browne 22:43
Re: XFS filessystem for Datawarehousing Michael Stone 23:33

Aug. 3, 2006

Thread Author Time
Re: XFS filessystem for Datawarehousing Luke Lonergan 04:05
Re: RAID stripe size question Merlin Moncure 04:46
Re: RAID stripe size question Luke Lonergan 04:51
Re: Performances with new Intel Core* processors Denis Lussier 05:08
Re: PITR performance overhead? Denis Lussier 05:21
Re: XFS filessystem for Datawarehousing -2 Denis Lussier 05:36
Re: XFS filessystem for Datawarehousing Koth, Christian (DWBI) 07:10
Re: XFS filessystem for Datawarehousing Florian Weimer 07:17
Re: XFS filessystem for Datawarehousing Michael Stone 09:39
unsubscribe Wade Klaver 16:03
Re: Strange behaviour Tom Lane 16:39
[No subject] Jim Nasby 18:33
Re: Steinar H. Gunderson 19:15
Re: Chris Hoover 19:29
Re: Ian Westmacott 19:30
Re: XFS filessystem for Datawarehousing Milen Kulev 19:44
Re: XFS filessystem for Datawarehousing -2 Milen Kulev 19:56
Re: Chris Hoover 20:31
Re: RAID stripe size question Merlin Moncure 20:36
Migrating data from DB2 to SQL Server contact1981 20:42
Re: Ian Westmacott 20:55
Re: XFS filessystem for Datawarehousing -2 Chris Browne 21:00
slow transfer speeds with PostgreSQL hansell baran 23:39

Aug. 4, 2006

Thread Author Time
Re: XFS filessystem for Datawarehousing Luke Lonergan 03:41
Re: Partitioning / constrain exlusion not working with %-operator Martin Lesser 07:36
Re: RAID stripe size question Mikael Carneholm 08:08
Re: XFS filessystem for Datawarehousing -2 Denis Lussier 20:13
Re: XFS filessystem for Datawarehousing Jim C. Nasby 20:44
Query Plan - Bitmap Index Scan and Views Rusty Conover 22:37

Aug. 5, 2006

Thread Author Time
Re: Query Plan - Bitmap Index Scan and Views Tom Lane 02:15
Re: Query Plan - Bitmap Index Scan and Views Rusty Conover 02:56
Re: Query Plan - Bitmap Index Scan and Views Tom Lane 03:27
Postgresql Performance on an HP DL385 and SmartArray 642 Steve Poe 23:10

Aug. 6, 2006

Thread Author Time
7.3.2 pg_restore very slow Saranya Sivakumar 16:54

Aug. 7, 2006

Thread Author Time
High Context-Switches on Linux 8.1.4 Server Donald C. Sumbry ][ 07:38
Re: Migrating data from DB2 to SQL Server Pit M. 09:48
Re: [PERFORM] 7.3.2 pg_restore very slow Richard Huxton 09:55
Re: Disk writes Markus Schaber 11:51
Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Markus Schaber 12:07
Re: High Context-Switches on Linux 8.1.4 Server Tom Lane 12:52
Re: PostgreSQL scalability on Sun UltraSparc T1 Markus Schaber 13:18
Re: sub select performance due to seq scans Markus Schaber 13:32
Re: PostgreSQL scalability on Sun UltraSparc T1 Arjen van der Meijden 13:45
Re: [PERFORM] 7.3.2 pg_restore very slow Saranya Sivakumar 15:35
Re: High Context-Switches on Linux 8.1.4 Server Donald C. Sumbry ][ 15:51
Re: [PERFORM] 7.3.2 pg_restore very slow Saranya Sivakumar 16:08
Re: [PERFORM] 7.3.2 pg_restore very slow Richard Broersma Jr 16:17
Re: XFS filessystem for Datawarehousing Alvaro Herrera 16:55
Slow transfer speeds hansell baran 17:26
Re: [PERFORM] 7.3.2 pg_restore very slow Saranya Sivakumar 17:28
Re: Slow transfer speeds Scott Marlowe 18:05
Re: [PERFORM] 7.3.2 pg_restore very slow Markus Schaber 18:25
Re: High Context-Switches on Linux 8.1.4 Server Tom Lane 18:34
Re: [PERFORM] 7.3.2 pg_restore very slow Richard Broersma Jr 19:18
Re: High Context-Switches on Linux 8.1.4 Server Donald C. Sumbry ][ 19:27
Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Alex Turner 20:02
Re: [PERFORM] 7.3.2 pg_restore very slow Saranya Sivakumar 20:07
Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Steinar H. Gunderson 20:20
Hardware upgraded but performance still ain't good enough Alvaro Nunes Melo 22:06

Aug. 8, 2006

Thread Author Time
Re: Postgresql Performance on an HP DL385 and Luke Lonergan 01:10
Re: Postgresql Performance on an HP DL385 and Steve Poe 01:46
Re: Postgresql Performance on an HP DL385 and Joshua D. Drake 02:19
Re: Postgresql Performance on an HP DL385 and Steve Poe 02:28
Re: Postgresql Performance on an HP DL385 and Steve Poe 04:13
Re: Hardware upgraded but performance still ain't good enough Alex Turner 06:33
Re: Postgresql Performance on an HP DL385 and Alex Turner 06:40
vacuuming Eugeny N Dzhurinsky 07:39
BUG #2567: High IOWAIT kumarselvan 08:42
shared_buffer optimization Ruben Rubio 10:40
Re: Hardware upgraded but performance still ain't good enough Stephen Frost 12:05
Re: Hardware upgraded but performance still ain't good enough Stephen Frost 12:14
Re: shared_buffer optimization Christopher Browne 12:20
Re: Postgresql Performance on an HP DL385 and SmartArray 642 Jeff Trout 12:20
Re: Postgresql Performance on an HP DL385 and Steve Poe 13:57
Re: Postgresql Performance on an HP DL385 and Luke Lonergan 14:36
Re: Postgresql Performance on an HP DL385 and Steve Poe 15:01
Re: Postgresql Performance on an HP DL385 and Luke Lonergan 16:22
Re: Postgresql Performance on an HP DL385 and Steve Poe 16:57
Optimizing queries Patrice Beliveau 17:49
Re: Optimizing queries Scott Marlowe 18:39
Re: Optimizing queries Patrice Beliveau 20:14
Re: Optimizing queries Tom Lane 20:42
most bang for buck with ~ $20,000 Kenji Morishige 20:43
Re: most bang for buck with ~ $20,000 Joshua D. Drake 21:49
Re: most bang for buck with ~ $20,000 Thomas F. O'Connell 21:59
Re: most bang for buck with ~ $20,000 Kenji Morishige 22:07
Re: most bang for buck with ~ $20,000 Scott Marlowe 22:08
Re: most bang for buck with ~ $20,000 Kenji Morishige 22:15
Re: most bang for buck with ~ $20,000 Steve Atkins 22:16
Re: most bang for buck with ~ $20,000 Joshua D. Drake 22:28
Re: most bang for buck with ~ $20,000 Thomas F. O'Connell 22:53
Re: most bang for buck with ~ $20,000 Joshua D. Drake 23:24

Aug. 9, 2006

Thread Author Time
Re: most bang for buck with ~ $20,000 Thomas F. O'Connell 00:16
Re: Postgresql Performance on an HP DL385 and Luke Lonergan 01:55
Re: Hardware upgraded but performance still ain't good David Lang 02:10
Re: Postgresql Performance on an HP DL385 and Steve Poe 04:56
Re: Postgresql Performance on an HP DL385 and Steve Poe 05:22
Re: Postgresql Performance on an HP DL385 and Luke Lonergan 05:22
unsubscribe Andrzej B.J.Schulz 05:23
Re: Postgresql Performance on an HP DL385 and Luke Lonergan 05:24
Re: most bang for buck with ~ $20,000 Arjen van der Meijden 05:35
Re: Postgresql Performance on an HP DL385 and Steve Poe 05:45
Re: most bang for buck with ~ $20,000 Kenji Morishige 06:30
Re: Postgresql Performance on an HP DL385 and Steve Poe 06:33
Re: Postgresql Performance on an HP DL385 and Luke Lonergan 06:35
Re: Postgresql Performance on an HP DL385 and Steve Poe 06:47
Re: Postgresql Performance on an HP DL385 and Luke Lonergan 06:50
Re: Postgresql Performance on an HP DL385 and Steve Poe 06:56
Re: most bang for buck with ~ $20,000 Arjen van der Meijden 07:38
unsubscribe Gourish Singbal 09:24
unsubscribe Gourish Singbal 09:25
Fwd: unsubscribe Gourish Singbal 09:26
Unsubscribe Werner vd Merwe 09:31
Re: Hardware upgraded but performance still ain't good enough Stephen Frost 10:30
Re: shared_buffer optimization Ruben Rubio 10:50
unsubscribe Mohan R 11:58
Re: Optimizing queries Patrice Beliveau 12:05
Re: Optimizing queries Ruben Rubio 12:20
Re: Hardware upgraded but performance still ain't good Joshua D. Drake 12:47
Re: Hardware upgraded but performance still ain't good Joshua D. Drake 12:50
Re: unsubscribe Devrim GUNDUZ 12:52
Re: unsubscribe Bill Moran 13:00
Re: Hardware upgraded but performance still ain't good enough Merlin Moncure 13:20
3-table query optimization Michal Taborsky - Internet Mall 14:06
Re: Optimizing queries Patrice Beliveau 14:23
Re: Optimizing queries Tom Lane 14:39
Re: 3-table query optimization Tom Lane 15:08
Re: most bang for buck with ~ $20,000 Scott Marlowe 15:15
Dell PowerEdge 2950 performance Bucky Jordan 15:56
Re: Hardware upgraded but performance still ain't good David Lang 16:19
Re: Hardware upgraded but performance still ain't good David Lang 16:20
Re: most bang for buck with ~ $20,000 Merlin Moncure 16:26
Re: Hardware upgraded but performance still ain't good Joshua D. Drake 16:27
Re: Hardware upgraded but performance still ain't good David Lang 16:37
Re: Hardware upgraded but performance still ain't good Scott Marlowe 16:45
Re: Hardware upgraded but performance still ain't good Steve Atkins 16:50
Re: Hardware upgraded but performance still ain't good Joshua D. Drake 16:53
Re: Postgresql Performance on an HP DL385 and Jim C. Nasby 21:05
Re: Performance with 2 AMD/Opteron 2.6Ghz and 8gig Jim C. Nasby 21:09
Re: Postgresql Performance on an HP DL385 and Steve Poe 21:11
Re: vacuuming Jim C. Nasby 21:20
Re: shared_buffer optimization Jim C. Nasby 21:28
Re: most bang for buck with ~ $20,000 Jim C. Nasby 21:35
Re: Postgresql Performance on an HP DL385 and Scott Marlowe 21:37
Re: most bang for buck with ~ $20,000 Scott Marlowe 21:50
Re: most bang for buck with ~ $20,000 Jim C. Nasby 21:59
Re: BUG #2567: High IOWAIT Jim C. Nasby 22:26
Re: shared_buffer optimization Tom Lane 22:37
Re: Postgresql Performance on an HP DL385 and Steve Poe 23:47

Aug. 10, 2006

Thread Author Time
Re: Postgresql Performance on an HP DL385 and Steve Poe 01:24
Re: Postgresql Performance on an HP DL385 and Steve Poe 03:29
Beginner optimization questions, esp. regarding Tsearch2 configuration Carl Youngblood 04:00
Re: 3-table query optimization Michal Taborsky - Internet Mall 07:30
setting up foreign keys Sue Fitt 08:05
Re: setting up foreign keys Chris 08:15
Re: setting up foreign keys Sue Fitt 09:04
Re: setting up foreign keys Chris 09:13
Re: setting up foreign keys Sue Fitt 09:20
Re: Beginner optimization questions, esp. regarding Tsearch2 Richard Huxton 09:23
Slow access to PostgreSQL server Phil Cairns 10:00
Re: Beginner optimization questions, esp. regarding Tsearch2 Markus Schaber 11:07
Re: Postgresql Performance on an HP DL385 and Michael Stone 11:09
Re: most bang for buck with ~ $20,000 Jeff Trout 13:16
Re: setting up foreign keys Merlin Moncure 13:33
Re: Postgresql Performance on an HP DL385 and Luke Lonergan 15:15
Re: Postgresql Performance on an HP DL385 and Scott Marlowe 15:35
Re: Postgresql Performance on an HP DL385 and Steve Poe 15:47
Re: 3-table query optimization Alvaro Herrera 15:50
Re: [BUGS] BUG #2567: High IOWAIT Jim Nasby 16:53

Browse Archives

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