pgsql-performance - August 2003

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 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Aug. 1, 2003

Thread Author Time
Re: Views With Unions Rajesh Kumar Mallah 03:40
Re: Odd explain estimate Andrew Sullivan 12:16
Re: Views With Unions Christopher Browne 12:20
Re: Views With Unions Stephan Szabo 15:10
Re: Views With Unions Christopher Browne 15:48
Re: Wrong plan or what ? Mendola Gaetano 15:49
How number of columns affects performance Francisco Reyes 16:08
Re: How number of columns affects performance Ron Johnson 16:34
Re: Views With Unions Tom Lane 16:51
Re: How number of columns affects performance Francisco J Reyes 17:14
Domains (Was [PERFORM] Views With Unions) Francisco J Reyes 17:26
Re: How number of columns affects performance Ron Johnson 17:32
Re: How number of columns affects performance Josh Berkus 17:44
OSDL Database Test Suite 3 is available on PostgreSQL Jenny Zhang 18:04
Re: [PERFORM] OSDL Database Test Suite 3 is available on PostgreSQL Josh Berkus 18:57
Re: How number of columns affects performance Ron Johnson 19:19
Re: How number of columns affects performance Josh Berkus 19:21
Re: How number of columns affects performance Francisco J Reyes 20:56
I can't wait too much: Total runtime 432478.44 msec Fernando Papa 21:17
Re: How number of columns affects performance Josh Berkus 21:18
Re: I can't wait too much: Total runtime 432478.44 msec Christopher Browne 21:27
Re: I can't wait too much: Total runtime 432478.44 msec Josh Berkus 21:31
Re: Domains (Was [PERFORM] Views With Unions) Ron Johnson 23:56

Aug. 2, 2003

Thread Author Time
Re: I can't wait too much: Total runtime 432478.44 msec Mendola Gaetano 10:36
Re: Odd explain estimate Jim C. Nasby 15:59
Inheritance vs child tables (Was Domains) Francisco J Reyes 18:22
Re: Inheritance vs child tables (Was Domains) 📎 Ron Johnson 21:50

Aug. 3, 2003

Thread Author Time
testing Ron Johnson 07:09
Re: Inheritance vs child tables (Was Domains) Francisco J Reyes 14:27

Aug. 4, 2003

Thread Author Time
Re: [PERFORM] OSDL Database Test Suite 3 is available on PostgreSQL Manfred Koizar 13:33
Re: I can't wait too much: Total runtime 432478.44 msec Fernando Papa 14:01
Re: I can't wait too much: Total runtime 432478.44 msec Manfred Koizar 14:10
Re: I can't wait too much: Total runtime 432478.44 msec Fernando Papa 14:13
Re: I can't wait too much: Total runtime 432478.44 msec Fernando Papa 14:51
Re: I can't wait too much: Total runtime 432478.44 msec Fernando Papa 15:02
Re: I can't wait too much: Total runtime 432478.44 msec Manfred Koizar 15:17
Re: EXTERNAL storage and substring on long strings Scott Cain 15:25
Re: I can't wait too much: Total runtime 432478.44 msec Fernando Papa 15:26
Re: [SQL] EXTERNAL storage and substring on long strings Tom Lane 15:53
Re: [SQL] EXTERNAL storage and substring on long strings Richard Huxton 15:55
Re: [PERFORM] OSDL Database Test Suite 3 is available on PostgreSQL scott.marlowe 16:07
Re: [PERFORM] OSDL Database Test Suite 3 is available on PostgreSQL scott.marlowe 16:09
Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain 16:14
Re: [SQL] EXTERNAL storage and substring on long strings Shridhar Daithankar 16:19
Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain 16:25
Re: [PERFORM] OSDL Database Test Suite 3 is available on PostgreSQL Shridhar Daithankar 16:39
Re: [SQL] EXTERNAL storage and substring on long strings Matt Clark 16:56
Re: I can't wait too much: Total runtime 432478.44 msec Fernando Papa 20:17
Re: [SQL] EXTERNAL storage and substring on long strings Joe Conway 20:29
Re: Indexes not used for "min()" Bruno Wolff III 21:19
Re: I can't wait too much: Total runtime 432478.44 msec Tom Lane 21:28
Re: I can't wait too much: Total runtime 432478.44 msec Fernando Papa 22:01
Re: I can't wait too much: Total runtime 432478.44 msec Tom Lane 22:30
Re: [osdldbt-general] Re: [PERFORM] OSDL Database Test Suite 3 is scott.marlowe 22:40
Re: [osdldbt-general] Re: [PERFORM] OSDL Database Test Suite 3 is Craig Thomas 22:48
Re: [osdldbt-general] Re: [PERFORM] OSDL Database Test Suite 3 is Jenny Zhang 22:48
Re: I can't wait too much: Total runtime 432478.44 msec Manfred Koizar 23:36

Aug. 5, 2003

Thread Author Time
Re: I can't wait too much: Total runtime 432478.44 msec Volker Helm 06:22
query/table design help Ara Anjargolian 09:33
Re: query/table design help Shridhar Daithankar 09:57
Some vacuum & tuning help Jeff 12:09
Re: Some vacuum & tuning help Shridhar Daithankar 12:35
Re: Some vacuum & tuning help Peter Childs 13:15
Re: Some vacuum & tuning help Jeff 13:18
Fwd: Re: postgresql.conf Hilary Forbes 13:20
Re: Some vacuum & tuning help Shridhar Daithankar 13:35
Re: Some vacuum & tuning help Shridhar Daithankar 13:48
Re: Some vacuum & tuning help Peter Childs 14:17
Re: Some vacuum & tuning help Christopher Browne 14:29
Re: Some vacuum & tuning help Tom Lane 14:37
Re: Some vacuum & tuning help Shridhar Daithankar 14:43
Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain 15:01
Re: [SQL] EXTERNAL storage and substring on long strings Scott Cain 15:05
Re: Some vacuum & tuning help Matthew T. O'Connor 15:06
Re: [SQL] EXTERNAL storage and substring on long strings Joe Conway 15:19
Re: Some vacuum & tuning help Matthew T. O'Connor 15:30
Re: Some vacuum & tuning help Tom Lane 15:35
Re: Some vacuum & tuning help Matthew T. O'Connor 15:45
How Many Inserts Per Transactions Trevor Astrope 15:59
Re: Some vacuum & tuning help Matthew T. O'Connor 16:01
Re: How Many Inserts Per Transactions scott.marlowe 16:02
Re: Some vacuum & tuning help Tom Lane 16:18
Re: How Many Inserts Per Transactions Christopher Browne 16:28
Re: Some vacuum & tuning help Bruce Momjian 16:49
Odd performance results - more info Medora Schauer 17:30
Re: Odd performance results - more info Joe Conway 17:41
Re: Odd performance results - more info Stephan Szabo 17:50
Re: Odd performance results - more info Medora Schauer 17:58
Re: Odd performance results - more info Medora Schauer 18:18
Re: Some vacuum & tuning help Christopher Browne 21:40
Re: Moving postgresql.conf tunables into 2003... Sean Chittenden 22:26

Aug. 6, 2003

Thread Author Time
Re: Some vacuum & tuning help Christopher Kings-Lynne 01:19
Re: Some vacuum & tuning help Matthew T. O'Connor 04:21
Re: Some vacuum & tuning help Bruce Momjian 04:32
Re: Some vacuum & tuning help Matthew T. O'Connor 04:36
Re: Some vacuum & tuning help Christopher Kings-Lynne 04:41
Re: Some vacuum & tuning help Tom Lane 04:45
Re: Some vacuum & tuning help Neil Conway 05:35
Re: How Many Inserts Per Transactions Hannu Krosing 06:42
PostgreSQL performance problem -> tuning 📎 Yaroslav Mazurak 07:34
Re: PostgreSQL performance problem -> tuning Richard Huxton 09:30
Re: How Many Inserts Per Transactions Shridhar Daithankar 10:16
Re: PostgreSQL performance problem -> tuning Mendola Gaetano 11:48
Re: PostgreSQL performance problem -> tuning Yaroslav Mazurak 12:42
Re: PostgreSQL performance problem -> tuning Shridhar Daithankar 12:53
Re: Some vacuum & tuning help Matthew T. O'Connor 12:54
Postgresql slow on XEON 2.4ghz/1gb ram Wilson A. Galafassi Jr. 13:50
Re: PostgreSQL performance problem -> tuning Richard Huxton 15:38
PostgreSql under Linux Wilson A. Galafassi Jr. 18:03
Re: PostgreSQL performance problem -> tuning Tom Lane 18:13
Re: PostgreSQL performance problem -> tuning Tom Lane 18:16
How to efficiently duplicate a whole schema? Sebastien Lemieux 18:56
Re: How to efficiently duplicate a whole schema? scott.marlowe 19:09
Re: How to efficiently duplicate a whole schema? Nick Fankhauser 19:09
Re: How to efficiently duplicate a whole schema? Tom Lane 19:13
Re: How to efficiently duplicate a whole schema? Tom Lane 19:29
Re: How to efficiently duplicate a whole schema? scott.marlowe 20:00
Re: partitioning for postgresql scott.marlowe 20:09
partitioning for postgresql Wilson A. Galafassi Jr. 20:09
ext3 block size Wilson A. Galafassi Jr. 20:34
Re: EXTERNAL storage and substring on long strings Tom Lane 20:36
Re: ext3 block size scott.marlowe 20:37
Re: partitioning for postgresql Christopher Browne 20:51
Re: EXTERNAL storage and substring on long strings Joe Conway 20:51
Re: EXTERNAL storage and substring on long strings Tom Lane 21:08
Re: How to efficiently duplicate a whole schema? Sebastien Lemieux 21:22
Re: PostgreSql under Linux Neil Conway 21:33
Re: PostgreSql under Linux Sam Barnett-Cormack 21:39
Re: How to efficiently duplicate a whole schema? Stephan Szabo 21:41
Re: How to efficiently duplicate a whole schema? Tom Lane 21:47
Re: How to efficiently duplicate a whole schema? Tom Lane 22:06

Aug. 7, 2003

Thread Author Time
Re: PostgreSQL performance problem -> tuning Yaroslav Mazurak 07:05
Re: PostgreSQL performance problem -> tuning Shridhar Daithankar 07:37
Re: PostgreSQL performance problem -> tuning Yaroslav Mazurak 07:41
Re: PostgreSQL performance problem -> tuning Richard Huxton 08:10
Re: PostgreSQL performance problem -> tuning Dennis Björklund 08:23
Re: PostgreSQL performance problem -> tuning Yaroslav Mazurak 08:24
Simple filesystem benchmark on Linux 2.6 Shridhar Daithankar 08:28
Re: PostgreSql under Linux Ben-Nes Michael 08:51
Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram Martijn van Oosterhout 09:30
Re: Moving postgresql.conf tunables into 2003... Manfred Koizar 14:44
Re: PostgreSQL performance problem -> tuning Richard Huxton 14:52
Re: How to efficiently duplicate a whole schema? Sebastien Lemieux 15:04
Re: PostgreSQL performance problem -> tuning scott.marlowe 16:15
Re: PostgreSQL performance problem -> tuning scott.marlowe 16:20
Re: PostgreSQL performance problem -> tuning Yaroslav Mazurak 16:30
Re: PostgreSQL performance problem -> tuning Yaroslav Mazurak 17:04
Testing gateway Marc G. Fournier 17:49
Re: PostgreSQL performance problem -> tuning matt 18:06
Re: PostgreSQL performance problem -> tuning scott.marlowe 18:52
Re: PostgreSQL performance problem -> tuning Ron Johnson 18:59
Re: PostgreSQL performance problem -> tuning Richard Huxton 19:06
Re: Moving postgresql.conf tunables into 2003... Sean Chittenden 20:24
Re: EXTERNAL storage and substring on long strings Scott Cain 21:15
Re: Moving postgresql.conf tunables into 2003... Tom Lane 23:31

Aug. 8, 2003

Thread Author Time
Re: PostgreSQL performance problem -> tuning Yaroslav Mazurak 07:53
Perfomance Tuning mixo 10:28
Re: Perfomance Tuning Bjoern Metzdorf 10:40
Re: Perfomance Tuning Shridhar Daithankar 10:52
Re: Perfomance Tuning Paul Thomas 11:28
Re: Perfomance Tuning scott.marlowe 13:28
Re: Perfomance Tuning Jonathan Gardner 16:40
Index correlation (was: Moving postgresql.conf tunables into 2003... ) Manfred Koizar 16:52
Re: Perfomance Tuning Andrew Sullivan 18:53
Re: Perfomance Tuning Rod Taylor 19:13
Re: Perfomance Tuning Bruce Momjian 19:34
Re: Perfomance Tuning Rod Taylor 19:46
Re: Perfomance Tuning Andrew Sullivan 19:56
Re: Perfomance Tuning Tom Lane 20:13

Aug. 11, 2003

Thread Author Time
Windows on SuSE? 7.4 elein 03:04
Re: Windows on SuSE? 7.4 Bruce Momjian 04:08
How to force PostgreeSQL to work faster? Serge Dorofeev 08:59
Peformance of Update whchung 11:33
Re: How to force PostgreeSQL to work faster? Tomka Gergely 11:37
Re: How to force PostgreeSQL to work faster? Paul Thomas 12:30
Re: How to force PostgreeSQL to work faster? Shridhar Daithankar 13:24
Re: Peformance of Update Shridhar Daithankar 13:26
Analyze makes queries slow... 📎 Stef 13:58
Re: Perfomance Tuning scott.marlowe 14:47
Re: Perfomance Tuning Andrew Sullivan 15:24
Re: Analyze makes queries slow... Tom Lane 15:43
Re: Windows on SuSE? 7.4 Tom Lane 15:54
Re: Analyze makes queries slow... 📎 Stef 16:47
Re: Windows on SuSE? 7.4 elein 17:07
Re: Windows on SuSE? 7.4 Tom Lane 17:29
Re: Windows on SuSE? 7.4 elein 17:44
Re: Windows on SuSE? 7.4 elein 17:53
Re: Windows on SuSE? 7.4 Tom Lane 17:53
Re: Windows on SuSE? 7.4 Tom Lane 18:14
Re: Analyze makes queries slow... Tom Lane 18:25
Re: Analyze makes queries slow... Tom Lane 18:50
Re: Windows on SuSE? 7.4 Robert Treat 18:53
Odd problem with performance in duplicate database 📎 Josh Berkus 21:15
Re: Windows on SuSE? 7.4 Bruce Momjian 21:45
Re: Odd problem with performance in duplicate database Josh Berkus 22:03
Re: Perfomance Tuning Bruce Momjian 22:16
Re: Odd problem with performance in duplicate database Ron Johnson 22:42
Re: Odd problem with performance in duplicate database Josh Berkus 22:48
Re: Odd problem with performance in duplicate database Peter Darley 22:51
Re: Perfomance Tuning Reece Hart 22:56

Browse Archives

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