pgsql-performance since 2003-07-20 00:00

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

July 20, 2003

Thread Author Time
Re: Poor delete performance AFTER vacuum analyze Tom Lane 04:44
Re: Poor delete performance AFTER vacuum analyze Dennis Björklund 05:42
Re: Moving postgresql.conf tunables into 2003... Bruce Momjian 19:20
Re: Moving postgresql.conf tunables into 2003... Bruce Momjian 19:21
Re: PostgreSQL vs. MySQL Bruce Momjian 23:23
Re: PostgreSQL vs. MySQL Bruce Momjian 23:24
Re: Poor delete performance AFTER vacuum analyze Jeremy M. Guthrie 23:51

July 21, 2003

Thread Author Time
Re: About the default performance Bruce Momjian 02:49
Re: Poor delete performance AFTER vacuum analyze Tom Lane 05:09
Re: Dual Xeon + HW RAID question SZUCS Gábor 05:09
Re: ugly query slower in 7.3, even slower after vacuum full analyze SZŰCS Gábor 05:58
Re: Optimizer differences between 7.2 and 7.3 SZUCS Gábor 08:25
Tuning PostgreSQL Alexander Priem 08:31
Re: Tuning PostgreSQL Shridhar Daithankar 08:51
Re: Tuning PostgreSQL Shridhar Daithankar 09:33
Re: Tuning PostgreSQL Alexander Priem 09:40
Re: Tuning PostgreSQL Ang Chin Han 10:09
Re: Tuning PostgreSQL Shridhar Daithankar 10:31
Re: Tuning PostgreSQL Ang Chin Han 11:27
Re: Tuning PostgreSQL Shridhar Daithankar 11:39
Re: Tuning PostgreSQL Alexander Priem 11:45
Re: Tuning PostgreSQL Shridhar Daithankar 12:05
Re: Tuning PostgreSQL Alexander Priem 12:43
Re: Optimizer differences between 7.2 and 7.3 Tom Lane 13:38
Re: Tuning PostgreSQL Roman Fail 13:45
Re: Tuning PostgreSQL Alexander Priem 14:00
Re: Tuning PostgreSQL Josh Berkus 16:06
Re: Tuning PostgreSQL Vincent van Leeuwen 16:28
Re: Dual Xeon + HW RAID question alexandre paes :: aldeia digital 18:07
Mass file imports Greg Spiegelberg 18:51
Re: Dual Xeon + HW RAID question Bruce Momjian 19:07
Re: Help disk-pages Bruce Momjian 19:46
Commenting postgresql.conf Josh Berkus 19:51
Re: Commenting postgresql.conf scott.marlowe 20:16
Re: Tunning FreeeBSD and PostgreSQL Bruce Momjian 20:41
PGAvd Josh Berkus 20:49
Re: PGAvd Bruce Momjian 20:54
Re: PGAvd Christopher Browne 22:00

July 22, 2003

Thread Author Time
Re: Tuning PostgreSQL Alexander Priem 07:04
Re: Dual Xeon + HW RAID question Mindaugas Riauba 07:23
Re: Tuning PostgreSQL Vincent van Leeuwen 09:40
Re: Tuning PostgreSQL Ron Johnson 09:52
Re: Tuning PostgreSQL Alexander Priem 12:53
Re: Tuning PostgreSQL Alexander Priem 13:27
Re: Tuning PostgreSQL Andrew Sullivan 14:12
Re: Tunning FreeeBSD and PostgreSQL Vivek Khera 14:20
Re: Tuning PostgreSQL Jim C. Nasby 14:33
Re: Tuning PostgreSQL Ron Johnson 14:37
Re: Tuning PostgreSQL Alexander Priem 15:01
Re: Tuning PostgreSQL Ron Johnson 15:36
Re: Tuning PostgreSQL Vivek Khera 16:12
Re: Dual Xeon + HW RAID question Bruce Momjian 16:26
Wrong plan or what ? Mendola Gaetano 17:10
Re: Tuning PostgreSQL Bruno Wolff III 17:10
Re: Dual Xeon + HW RAID question SZUCS Gábor 17:10
Re: Tuning PostgreSQL scott.marlowe 17:19
Re: Tunning FreeeBSD and PostgreSQL Bruce Momjian 17:29
Re: Dual Xeon + HW RAID question Jord Tanner 17:35
Re: Dual Xeon + HW RAID question Bruce Momjian 17:38
Re: Dual Xeon + HW RAID question Bruce Momjian 17:39
Re: [PERFORM] Wrong plan or what ? Josh Berkus 17:40
Re: [PERFORM] Wrong plan or what ? Mendola Gaetano 17:48
Re: Dual Xeon + HW RAID question Jord Tanner 17:54
Re: Wrong plan or what ? Josh Berkus 17:56
Re: [PERFORM] Wrong plan or what ? Mendola Gaetano 17:56
Re: Tunning FreeeBSD and PostgreSQL Vivek Khera 18:18
Re: [PERFORM] Wrong plan or what ? Mendola Gaetano 18:35
Re: Dual Xeon + HW RAID question Bruce Momjian 18:50
Re: Dual Xeon + HW RAID question Jord Tanner 19:18

July 23, 2003

Thread Author Time
One table or many tables for data set Castle, Lindsay 00:34
slow table updates Reece Hart 00:40
Re: One table or many tables for data set Rod Taylor 00:53
Re: One table or many tables for data set Joe Conway 01:02
Re: One table or many tables for data set Castle, Lindsay 01:25
Re: One table or many tables for data set Joe Conway 01:36
Re: One table or many tables for data set Castle, Lindsay 01:47
Re: One table or many tables for data set Rod Taylor 01:50
Re: One table or many tables for data set Rod Taylor 02:10
Re: One table or many tables for data set Castle, Lindsay 02:14
Performance hit of foreign key constraints? Jean-Christian Imbeault 07:05
Re: slow table updates Richard Huxton 08:49
Re: Performance hit of foreign key constraints? Shridhar Daithankar 09:54
factoring problem with view in 7.3.3 Rajesh Kumar Mallah 10:21
Re: factoring problem with view in 7.3.3 Richard Huxton 14:13
different query plan for same select Jörg Schulz 14:28
Re: Performance hit of foreign key constraints? Stephan Szabo 14:49
Re: Performance hit of foreign key constraints? Stephan Szabo 15:02
Re: different query plan for same select Tom Lane 15:21
Re: factoring problem with view in 7.3.3 Tom Lane 15:43
Re: factoring problem with view in 7.3.3 [ PARTIALLY SOLVED ] mallah 16:37
Re: factoring problem with view in 7.3.3 [ PARTIALLY SOLVED ] Tom Lane 16:47
Re: factoring problem with view in 7.3.3 [ SOLVED ] mallah 17:21
Re: [PERFORM] slow table updates Reece Hart 17:44
Re: [PERFORM] slow table updates Reece Hart 18:07
Re: slow table updates Guthrie, Jeremy 18:38

July 24, 2003

Thread Author Time
Re: different query plan for same select Jörg Schulz 06:06
Re: hardware performance and some more Shridhar Daithankar 13:09
Re: hardware performance and some more Roman Fail 15:27
hardware performance and some more Kasim Oztoprak 15:54
Re: hardware performance and some more William Yu 16:42
Re: hardware performance and some more Kasim Oztoprak 18:25
Re: Tuning PostgreSQL Greg Stark 18:29
Re: hardware performance and some more Kasim Oztoprak 19:06
Re: hardware performance and some more Ron Johnson 20:09
Re: Tuning PostgreSQL Ron Johnson 20:13

July 25, 2003

Thread Author Time
Re: Tuning PostgreSQL Andrew McMillan 10:45
Re: hardware performance and some more Shridhar Daithankar 13:59
Re: hardware performance and some more Shridhar Daithankar 14:03
Re: hardware performance and some more Ron Johnson 14:19
Re: hardware performance and some more Shridhar Daithankar 15:31
Re: hardware performance and some more Josh Berkus 16:13
Re: hardware performance and some more Kasim Oztoprak 16:38
index questions Franco Bruno Borghesi 16:52
Re: hardware performance and some more Ron Johnson 17:12
Re: index questions Ron Johnson 17:21
Re: index questions Josh Berkus 17:28
Re: index questions Franco Bruno Borghesi 18:33
Re: hardware performance and some more Kasim Oztoprak 18:41

July 26, 2003

Thread Author Time
Wrong rows number expected Mendola Gaetano 00:44
SUBSCRIBE Rauf Kuliyev 09:52
Re: Tuning PostgreSQL Arjen van der Meijden 10:18
Re: Wrong plan or what ? HansH 10:53
Re: Tuning PostgreSQL Tom Lane 14:12
Re: Tuning PostgreSQL Balazs Wellisch 21:08

July 27, 2003

Thread Author Time
Mapping Database completly into memory Daniel Migowski 08:40
Mapping a database completly into Memory Daniel Migowski 08:49
Query problem pginfo 11:49
Re: RE : Query problem pginfo 12:22
RE : Query problem Bruno BAGUETTE 13:26
Re: Query problem Rod Taylor 14:25
Re: Mapping a database completly into Memory Tom Lane 16:18

July 28, 2003

Thread Author Time
Re: Mapping a database completly into Memory Josh Berkus 04:14
Re: Mapping a database completly into Memory Franco Bruno Borghesi 14:16
Optimization Justin Long 16:18
Re: Mapping a database completly into Memory Tom Lane 16:25
Re: Mapping a database completly into Memory Josh Berkus 16:50
Re: Mapping a database completly into Memory Tom Lane 16:58
Re: Tuning PostgreSQL Josh Berkus 17:10
Re: Mapping a database completly into Memory Franco Bruno Borghesi 17:48
Re: Mapping Database completly into memory scott.marlowe 17:58
Re: Optimization Josh Berkus 18:00
Re: Mapping a database completly into Memory Andrew Sullivan 18:20
Re: Optimization Nick Fankhauser - Doxpop 18:25
Re: Optimization Nick Fankhauser 18:28
Re: Optimization Nick Fankhauser 18:39
Re: Optimization Josh Berkus 19:27
Rebuild indexes Shankar K 21:29

July 29, 2003

Thread Author Time
Re: [PERFORM] Rebuild indexes Josh Berkus 00:18
Re: Rebuild indexes Tom Lane 02:21
Re: [ADMIN] Rebuild indexes Shankar K 03:00
Why performance improvement on converting subselect to a function ? Rajesh Kumar Mallah 05:44
Re: Optimization Shridhar Daithankar 06:51
Re: Optimization Peter Childs 07:14
Re: Optimization Shridhar Daithankar 07:21
autovacuum Christopher Browne 11:56
Autovacuum Christopher Browne 12:03
Re: Autovacuum Shridhar Daithankar 12:31
Re: Why performance improvement on converting subselect to a function ? Tom Lane 14:09
Re: Tuning PostgreSQL Vivek Khera 15:14
Re: Mapping a database completly into Memory Vivek Khera 15:22
Re: Tuning PostgreSQL Ron Johnson 15:46
Re: Tuning PostgreSQL Will LaShell 16:16
Re: Tuning PostgreSQL scott.marlowe 16:18
Re: Why performance improvement on converting subselect Rajesh Kumar Mallah 16:46
Re: Tuning PostgreSQL Ron Johnson 18:08
Re: Tuning PostgreSQL scott.marlowe 19:00
Re: Tuning PostgreSQL Ron Johnson 19:50
Re: Tuning PostgreSQL scott.marlowe 20:09
Re: Tuning PostgreSQL Ron Johnson 20:38
Re: Why performance improvement on converting subselect to a function ? Tom Lane 21:32

July 30, 2003

Thread Author Time
function returning setof performance question Mark Bronnimann 02:08
Re: function returning setof performance question Rod Taylor 02:28
Re: function returning setof performance question Mark Bronnimann 02:57
Re: function returning setof performance question Joe Conway 03:51
Re: Why performance improvement on converting subselect to a function ? Rajesh Kumar Mallah 07:24
Re: Why performance improvement on converting subselect to a function ? Tom Lane 13:51
Re: Why performance improvement on converting subselect to a function ? Shridhar Daithankar 13:56
Re: Tuning PostgreSQL, pt 2 Ron Johnson 14:41
Getting Started Guide? Josh Berkus 16:00
postgresql.conf scott.marlowe 16:59
Re: postgresql.conf Josh Berkus 17:19
Re: [SQL] function returning setof performance question Josh Berkus 17:28
Re: postgresql.conf Ron Johnson 18:32
Re: postgresql.conf Robert Treat 18:34
Re: postgresql.conf Josh Berkus 18:43
Re: postgresql.conf Ron 18:59
Re: postgresql.conf Josh Berkus 19:10
Re: Why performance improvement on converting subselect Rajesh Kumar Mallah 19:38
Re: postgresql.conf scott.marlowe 20:09
Re: postgresql.conf Josh Berkus 20:42
Re: Mapping a database completly into Memory Bruce Momjian 22:10
Re: Mapping a database completly into Memory Bruce Momjian 22:12

July 31, 2003

Thread Author Time
Re: Why performance improvement on converting subselect Tom Lane 03:21
Possible problem with DOMAIN evaluation? Christopher Browne 05:39
Targeted CPU compilations Ron Johnson 05:45
Re: Possible problem with DOMAIN evaluation? Rod Taylor 12:11
Re: Mapping a database completly into Memory Vivek Khera 14:15
Re: postgresql.conf cafweb 14:43
Help on my database performance Jianshuo Niu 15:06
Re: Moving postgresql.conf tunables into 2003... Manfred Koizar 17:37

Browse Archives

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