pgsql-performance - November 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 9 10 11 12 13 14 15 16 17 18 19 20 21 22 24 25 26 27 28 30

Nov. 1, 2003

Thread Author Time
Re: Query puts 7.3.4 on endless loop but 7.4beta5 is fine. Rajesh Kumar Mallah 03:08
Re: Query puts 7.3.4 on endless loop but 7.4beta5 is fine. Rajesh Kumar Mallah 03:19
Re: Query puts 7.3.4 on endless loop but 7.4beta5 is fine. Rajesh Kumar Mallah 05:44
[ PROBLEM SOLVED ] Re: Query puts 7.3.4 on endless loop but 7.4beta5 is fine. Rajesh Kumar Mallah 05:47
Re: Query puts 7.3.4 on endless loop but 7.4beta5 is fine. Rajesh Kumar Mallah 08:31
Re: Query puts 7.3.4 on endless loop but 7.4beta5 is fine. Rajesh Kumar Mallah 08:50

Nov. 2, 2003

Thread Author Time
Re: Pg+Linux swap use Greg Stark 16:33

Nov. 3, 2003

Thread Author Time
join_collapse_limit, from_collapse_limit options missing Lee Hughes 16:20
Re: join_collapse_limit, from_collapse_limit options missing Tom Lane 16:24
Re: join_collapse_limit, from_collapse_limit options missing Josh Berkus 18:41

Nov. 4, 2003

Thread Author Time
Re: Ignoring index on (A is null), (A is not null) conditions Cestmir Hybl 10:43
Re: Response time radha.manohar 14:49
Re: Response time Pavel Stehule 15:02
Re: Response time Neil Conway 20:12

Nov. 5, 2003

Thread Author Time
Interbase/Firebird - any users out there - what's the performance like compared to PostgreSQL? Paul Ganainm 10:28
Re: Interbase/Firebird - any users out there - what's the Shridhar Daithankar 13:15
Re: Interbase/Firebird - any users out there - what's Franco Bruno Borghesi 14:05
Re: Response time radha.manohar 17:35
Re: Response time Neil Conway 17:40
Re: Response time Andrew Sullivan 18:04

Nov. 6, 2003

Thread Author Time
horrible performance when trying to connect to PostgreSQL using ODBC Adrian Maier 08:43
Re: horrible performance when trying to connect to PostgreSQL using ODBC Tom Lane 14:57
Re: Interbase/Firebird - any users out there - what's the performance like compared to PostgreSQL? Private 16:57
Re: Interbase/Firebird - any users out there - what's the performance like compared to PostgreSQL? Christopher Browne 18:23
Re: Interbase/Firebird - any users out there - what's Hannu Krosing 19:54
Re: Pg+Linux swap use Bruce Momjian 22:58

Nov. 9, 2003

Thread Author Time
Re: error while executing a c program with embedded sql radha.manohar 15:06
Re: error while executing a c program with embedded sql Tom Lane 15:34
Re: error while executing a c program with embedded sql Oliver Elphick 17:32

Nov. 10, 2003

Thread Author Time
Re: error while executing a c program with embedded sql radha.manohar 15:00
Re: [PERFORM] error while executing a c program with embedded sql Rajesh Kumar Mallah 16:27
*very* slow query to summarize data for a month ... Marc G. Fournier 20:18
Re: *very* slow query to summarize data for a month ... Patrick Hatcher 20:31
Re: *very* slow query to summarize data for a month ... Patrick Hatcher 20:32
Re: *very* slow query to summarize data for a month ... Josh Berkus 20:59
Re: *very* slow query to summarize data for a month ... Neil Conway 22:51
Re: *very* slow query to summarize data for a month ... Neil Conway 23:15
Re: *very* slow query to summarize data for a month ... Tom Lane 23:42

Nov. 11, 2003

Thread Author Time
Re: *very* slow query to summarize data for a month ... Marc G. Fournier 00:19
Re: *very* slow query to summarize data for a month ... Marc G. Fournier 00:28
Re: *very* slow query to summarize data for a month ... Marc G. Fournier 00:49
Re: *very* slow query to summarize data for a month ... Dennis Bjorklund 06:50
Re: *very* slow query to summarize data for a month ... Greg Stark 17:47
Re: Suggestions for benchmarking 7.4RC2 against 7.3 Christopher Browne 18:08
Re: *very* slow query to summarize data for a month ... Marc G. Fournier 18:14
Re: Suggestions for benchmarking 7.4RC2 against 7.3 Josh Berkus 18:25
Re: *very* slow query to summarize data for a month ... Josh Berkus 18:30
Re: *very* slow query to summarize data for a month ... Marc G. Fournier 18:38
Re: *very* slow query to summarize data for a month ... Greg Stark 19:51
Re: *very* slow query to summarize data for a month ... scott.marlowe 21:25
Seeking help with a query that take too long Nick Fankhauser - Doxpop 22:26
Re: Server Configs Anjan Dave 22:57
Value of Quad vs. Dual Processor machine Chris Field 23:32
Re: Value of Quad vs. Dual Processor machine Rod Taylor 23:51

Nov. 12, 2003

Thread Author Time
Re: Value of Quad vs. Dual Processor machine scott.marlowe 00:40
Re: Value of Quad vs. Dual Processor machine Allan Wind 01:02
Re: Value of Quad vs. Dual Processor machine fred 01:11
Re: Value of Quad vs. Dual Processor machine Ron Johnson 01:24
Re: Value of Quad vs. Dual Processor machine Chris Field 02:13
Re: Value of Quad vs. Dual Processor machine Fred Moyer 03:17
Re: *very* slow query to summarize data for a month ... Greg Stark 05:52
Re: Value of Quad vs. Dual Processor machine Shridhar Daithankar 08:42
Seeking help with a query that takes too long Nick Fankhauser 13:34
Re: Value of Quad vs. Dual Processor machine Jeff 14:28
Suggestions for benchmarking 7.4RC2 against 7.3 Rajesh Kumar Mallah 14:47
Re: Seeking help with a query that takes too long Manfred Koizar 15:04
Re: Suggestions for benchmarking 7.4RC2 against 7.3 Rajesh Kumar Mallah 15:04
Superior performance in PG 7.4 alexandre :: aldeia digital 15:41
Re: Value of Quad vs. Dual Processor machine scott.marlowe 15:53
Re: Seeking help with a query that takes too long Nick Fankhauser 15:55
Re: Seeking help with a query that takes too long Nick Fankhauser 16:05
Re: *very* slow query to summarize data for a month ... Marc G. Fournier 16:08
Re: Seeking help with a query that takes too long Tom Lane 16:10
Re: Seeking help with a query that takes too long Nick Fankhauser 16:52
Re: Seeking help with a query that takes too long Tom Lane 17:10
performance optimzations Suchandra Thapa 17:34
Re: performance optimzations Rod Taylor 18:23
Re: Seeking help with a query that takes too long Nick Fankhauser 18:27
Re: performance optimzations Suchandra Thapa 18:51
Re: Suggestions for benchmarking 7.4RC2 against 7.3 Rajesh Kumar Mallah 20:16
Re: Suggestions for benchmarking 7.4RC2 against 7.3 📎 Rajesh Kumar Mallah 21:25
Re: Seeking help with a query that takes too long Manfred Koizar 22:25
Re: performance optimzations Neil Conway 22:29

Nov. 13, 2003

Thread Author Time
Re: performance optimzations Suchandra Thapa 00:15
Query question Christopher Kings-Lynne 04:09
Re: performance optimzations Rod Taylor 04:35
Re: Query question Josh Berkus 05:20
Re: performance optimzations Suchandra Thapa 05:58
IN surpasses NOT EXISTS in 7.4RC2 ?? Rajesh Kumar Mallah 07:53
Re: performance optimzations Rod Taylor 13:47
Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Bruce Momjian 14:56
Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Tom Lane 15:19
Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Robert Treat 15:31
Re: Value of Quad vs. Dual Processor machine Robert Treat 15:52
Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Tom Lane 17:00
Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Robert Treat 17:19
strange estimate for number of rows Andrew Sullivan 18:14
Union+group by planner estimates way off? Arthur Ward 18:28
Re: Union+group by planner estimates way off? Tom Lane 18:46
Re: strange estimate for number of rows Tom Lane 18:56
Re: Union+group by planner estimates way off? Arthur Ward 19:19
Re: strange estimate for number of rows Daniel Manley 19:35
Storage space, RAM for NUMERIC Josh Berkus 19:36
Re: strange estimate for number of rows Tom Lane 20:19
Re: strange estimate for number of rows Andrew Sullivan 21:37
Re: strange estimate for number of rows Andrew Sullivan 21:52

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

Browse Archives

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