pgsql-performance since 2003-11-14 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)

Browse Archives

Prev | Next

Nov. 14, 2003

Thread Author Time
Help with count(*) Rajesh Kumar Mallah 07:21
Re: Help with count(*) Shridhar Daithankar 07:30
INSERT extremely slow with large data sets (fwd) Slavisa Garic 09:38
IDE Hardware RAID Controller Nick Barr 10:11
Re: INSERT extremely slow with large data sets (fwd) Jeff 13:37
Re: Help with count(*) Christopher Browne 14:13
constant vs function param differs in performance SZŰCS Gábor 15:08
Re: Seeking help with a query that takes too long Nick Fankhauser 16:00
Re: IN surpasses NOT EXISTS in 7.4RC2 ?? 📎 Rajesh Kumar Mallah 16:01
Re: Query question Neil Conway 16:07
Re: Seeking help with a query that takes too long Manfred Koizar 16:35
Re: Query question Tom Lane 16:40
Re: Help with count(*) Hannu Krosing 17:43
Re: Help with count(*) Tom Lane 18:49
Re: Help with count(*) Christopher Browne 19:16
Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Rajesh Kumar Mallah 19:27
Re: Help with count(*) Will LaShell 19:40
Re: Help with count(*) Tom Lane 20:38
Re: constant vs function param differs in performance Tom Lane 20:59
n_distinct way off, but following a pattern. Nick Fankhauser 21:27
Re: Help with count(*) Andrew Sullivan 21:30
Re: INSERT extremely slow with large data sets (fwd) George Essig 22:02
Re: Error in transaction processing radha.manohar 22:07
Re: n_distinct way off, but following a pattern. Tom Lane 22:12

Nov. 15, 2003

Thread Author Time
Re: INSERT extremely slow with large data sets (fwd) Slavisa Garic 01:20
Re: Query question Christopher Kings-Lynne 03:35
Re: Help with count(*) Dennis Bjorklund 10:21
Re: INSERT extremely slow with large data sets (fwd) George Essig 13:13
Re: Error in transaction processing radha.manohar 14:52
Re: Help with count(*) Neil Conway 20:20

Nov. 16, 2003

Thread Author Time
start of transaction (was: Re: [PERFORM] Help with count(*)) Hannu Krosing 11:58
Re: n_distinct way off, but following a pattern. Nick Fankhauser 13:52
Re: start of transaction (was: Re: [PERFORM] Help with count(*)) Tom Lane 14:50
Re: Help with count(*) Tom Lane 15:22
Re: start of transaction (was: Re: [PERFORM] Help with Dennis Bjorklund 15:51
Re: start of transaction (was: Re: [PERFORM] Help with count(*)) Neil Conway 22:55
start of transaction (was: Re: [PERFORM] Help with count(*)) Neil Conway 23:18

Nov. 17, 2003

Thread Author Time
Re: start of transaction (was: Re: [PERFORM] Help with count(*)) Tom Lane 00:08
Re: start of transaction (was: Re: [PERFORM] Help with count(*)) Bruce Momjian 00:31
Re: start of transaction (was: Re: [PERFORM] Help with count(*)) Greg Stark 06:11
Re: start of transaction (was: Re: [PERFORM] Help with Stephan Szabo 07:09
Re: start of transaction (was: Re: [PERFORM] Help with Hannu Krosing 10:16
Re: start of transaction (was: Re: [PERFORM] Help with Hannu Krosing 10:19
Re: start of transaction Shridhar Daithankar 10:43
Re: INSERT extremely slow with large data sets (fwd) Andrew Sullivan 14:42
Backup/restore of pg_statistics Joel Jacobson 14:51
Top n queries and GROUP BY Rich Cullingford 16:38
Re: Top n queries and GROUP BY Rich Cullingford 17:56
duration logging setting in 7.4 Ryszard Lach 22:20

Nov. 18, 2003

Thread Author Time
Re: start of transaction (was: Re: [PERFORM] Help with count(*)) Bruce Momjian 00:52
Re: duration logging setting in 7.4 Bruce Momjian 02:37
Re: start of transaction (was: Re: [PERFORM] Help with count(*)) Tom Lane 07:34
Re: duration logging setting in 7.4 Ryszard Lach 09:16
Join on incompatible types Laurent Martelli 10:01
Re: Join on incompatible types Shridhar Daithankar 10:45
Re: Join on incompatible types Laurent Martelli 13:24
Re: duration logging setting in 7.4 Bruce Momjian 15:07
Re: Top n queries and GROUP BY Harald Fuchs 17:01
More detail on settings for pgavd? Josh Berkus 23:58

Nov. 19, 2003

Thread Author Time
High Processor consumption Benjamin Bostow 01:19
Re: More detail on settings for pgavd? Shridhar Daithankar 06:32
Re: High Processor consumption Shridhar Daithankar 06:34
Re: Join on incompatible types Shridhar Daithankar 06:54
TEXT column and indexing Ian Barwick 09:18
Re: Join on incompatible types Laurent Martelli 09:52
Re: Join on incompatible types Shridhar Daithankar 10:19
Re: Join on incompatible types Laurent Martelli 12:16
Re: Join on incompatible types Shridhar Daithankar 12:31
Re: More detail on settings for pgavd? Shridhar Daithankar 14:10
Re: problem with select count(*) .. Bruno Wolff III 15:49
Re: More detail on settings for pgavd? Josh Berkus 16:00
Re: constant vs function param differs in performance SZŰCS Gábor 16:04
Re: TEXT column and indexing Manfred Koizar 16:26
Re: TEXT column and indexing Stephan Szabo 16:35
Re: More detail on settings for pgavd? Josh Berkus 17:06
Re: duration logging setting in 7.4 Ryszard Lach 18:38
Re: duration logging setting in 7.4 Bruce Momjian 18:58
Re: TEXT column and indexing Ian Barwick 19:13
Re: TEXT column and indexing Ian Barwick 19:16
Re: duration logging setting in 7.4 Ryszard Lach 19:28
Re: duration logging setting in 7.4 Bruce Momjian 19:42

Nov. 20, 2003

Thread Author Time
problem with select count(*) .. Rajesh Kumar Mallah 01:37
Re: Backup/restore of pg_statistics Tom Lane 04:39
Re: High Processor consumption Shridhar Daithankar 05:58
Re: More detail on settings for pgavd? Shridhar Daithankar 07:23
Re: [PERFORM] More detail on settings for pgavd? Matthew T. O'Connor 14:30
Re: [HACKERS] More detail on settings for pgavd? 📎 Shridhar Daithankar 14:59
Re: [HACKERS] More detail on settings for pgavd? 📎 Shridhar Daithankar 15:07
Re: [PERFORM] More detail on settings for pgavd? Matthew T. O'Connor 16:32
Re: [HACKERS] More detail on settings for pgavd? Josh Berkus 17:18
Re: More detail on settings for pgavd? Josh Berkus 18:00
Re: [HACKERS] More detail on settings for pgavd? Chester Kustarz 18:48
Re: [HACKERS] More detail on settings for pgavd? Tom Lane 19:20
Re: [HACKERS] More detail on settings for pgavd? Chester Kustarz 20:54
Problem with insert into select... stephen farrell 21:04
Problem with insert into select... stephen farrell 21:09
Re: Problem with insert into select... Tom Lane 22:58
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor 23:18

Nov. 21, 2003

Thread Author Time
Re: duration logging setting in 7.4 Tom Lane 00:17
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor 00:40
Re: Problem with insert into select... stephen farrell 02:05
Re: [HACKERS] More detail on settings for pgavd? Josh Berkus 06:24
Re: duration logging setting in 7.4 Ryszard Lach 08:53
Re: Hardware advice Adam Witney 10:08
Re: duration logging setting in 7.4 Ryszard Lach 10:18
Re: [HACKERS] More detail on settings for pgavd? Robert Treat 14:14
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor 14:31
Re: duration logging setting in 7.4 Tom Lane 14:54
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor 14:56
Re: [HACKERS] More detail on settings for pgavd? Shridhar Daithankar 15:06
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor 15:17
Re: [HACKERS] More detail on settings for pgavd? Josh Berkus 17:09
Re: [HACKERS] More detail on settings for pgavd? Josh Berkus 21:23
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor 21:24
Re: [HACKERS] More detail on settings for pgavd? Josh Berkus 21:49
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor 21:52
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor 22:40
Re: [HACKERS] More detail on settings for pgavd? Tom Lane 23:04
Re: [HACKERS] More detail on settings for pgavd? Chester Kustarz 23:53

Nov. 22, 2003

Thread Author Time
Re: [PERFORM] More detail on settings for pgavd? Greg Stark 00:51
pg_autoconfig.pl Nick Barr 11:56
Re: [HACKERS] More detail on settings for pgavd? Alvaro Herrera Munoz 14:46
Re: pg_autoconfig.pl Josh Berkus 17:19

Nov. 24, 2003

Thread Author Time
Maximum Possible Insert Performance? William Yu 03:48
Re: Maximum Possible Insert Performance? Tom Lane 04:21
Re: Maximum Possible Insert Performance? Josh Berkus 04:29
Re: Maximum Possible Insert Performance? Joe Conway 04:40
Re: Maximum Possible Insert Performance? Shridhar Daithankar 05:50
Re: pg_autoconfig.pl Nick Barr 11:24
Re: Maximum Possible Insert Performance? Bill Moran 13:38
VACUUM problems with 7.4 Rajesh Kumar Mallah 17:13
Re: Maximum Possible Insert Performance? William Yu 17:19
Re: Maximum Possible Insert Performance? Josh Berkus 17:25
Re: VACUUM problems with 7.4 Tom Lane 17:44
Re: Maximum Possible Insert Performance? William Yu 17:45
Re: VACUUM problems with 7.4 mallah 18:04
Re: Maximum Possible Insert Performance? Josh Berkus 18:04
Re: Maximum Possible Insert Performance? William Yu 18:23
Re: Problem with insert into select... Richard Huxton 19:29
Re: Optimize Gaetano Mendola 20:20
Optimize Torsten Schulz 20:48
Re: Optimize Gaetano Mendola 20:56
Re: Optimize Torsten Schulz 21:33
Re: Optimize Dennis Bjorklund 21:45
Where to start for performance problem? MK Spam 22:03
Re: Where to start for performance problem? Nid 22:08

Nov. 25, 2003

Thread Author Time
Re: Where to start for performance problem? Christopher Kings-Lynne 01:13
Re: Maximum Possible Insert Performance? Greg Stark 01:16
Re: Optimize Neil Conway 02:24
Re: VACUUM problems with 7.4 Neil Conway 02:27
Re: Where to start for performance problem? Nid 03:05
Re: Where to start for performance problem? Christopher Kings-Lynne 03:18
Re: [HACKERS] More detail on settings for pgavd? Christopher Browne 04:08
Re: Maximum Possible Insert Performance? Shridhar Daithankar 06:06
Re: Where to start for performance problem? Rob Fielding 14:07
Re: Maximum Possible Insert Performance? Tom Lane 15:47
Re: Where to start for performance problem? Bruno Wolff III 16:52
Re: Where to start for performance problem? Tom Lane 17:07
design question: general db performance shane hill 18:42
Re: design question: general db performance Jord Tanner 18:58
Re: Maximum Possible Insert Performance? Suchandra Thapa 18:59
Re: design question: general db performance Josh Berkus 19:12
Re: [Fwd: Re: Optimize] Gaetano Mendola 19:19
Re: design question: general db performance Jeff 19:23
Re: design question: general db performance Richard Huxton 19:27
[Fwd: Re: Optimize] Torsten Schulz 19:39
why index scan not working when using 'like'? LIANHE SHAO 19:48
Re: why index scan not working when using 'like'? Josh Berkus 19:51
Re: why index scan not working when using 'like'? Dror Matalon 19:56
Re: why index scan not working when using 'like'? Tom Lane 21:29
Impossibly slow DELETEs Stefan Champailler 21:56
Re: [Fwd: Re: Optimize] Torsten Schulz 22:06
Re: Optimize Torsten Schulz 22:07
Wierd context-switching issue on Xeon Josh Berkus 22:19
Re: [Fwd: Re: Optimize] Russell Garrett 22:27
Re: Wierd context-switching issue on Xeon Josh Berkus 23:37
Re: Wierd context-switching issue on Xeon Tom Lane 23:40
Re: Impossibly slow DELETEs Bill Moran 23:45
Re: Impossibly slow DELETEs Neil Conway 23:55

Nov. 26, 2003

Thread Author Time
Re: Impossibly slow DELETEs Tom Lane 00:37
Re: [PERFORM] More detail on settings for pgavd? Andrew Sullivan 04:27
Re: Optimize Shridhar Daithankar 06:06
expression (functional) index use in joins Roger Ging 16:38
Re: Maximum Possible Insert Performance? William Yu 16:44
Re: Impossibly slow DELETEs Greg Stark 17:11
Re: why index scan not working when using 'like'? Hannu Krosing 17:33
Re: expression (functional) index use in joins Richard Huxton 17:52
Re: Maximum Possible Insert Performance? Tom Lane 17:55
Re: Maximum Possible Insert Performance? William Yu 18:03
Followup - expression (functional) index use in joins Roger Ging 18:39
Re: Maximum Possible Insert Performance? Dror Matalon 18:54
Re: Followup - expression (functional) index use in joins Richard Huxton 19:12
For full text indexing, which is better, tsearch2 or fulltextindex LIANHE SHAO 20:06
cross table indexes or something? Jeremiah Jahn 20:14
very large db performance question LIANHE SHAO 20:22
Re: Followup - expression (functional) index use in joins Roger Ging 21:29
Re: very large db performance question Neil Conway 22:03
Re: cross table indexes or something? Marc A. Leith 22:23
Re: cross table indexes or something? Hannu Krosing 22:32
Re: very large db performance question LIANHE SHAO 22:46

Browse Archives

Prev | Next