Search

Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-performance - November 2003

Search archives
	(enter a message-id to go directly to that message)	Advanced Search

Prev | Next

2003-11-01

• 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)

2003-11-02

• Re: Pg+Linux swap use Greg Stark (16:33)

2003-11-03

• 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)

2003-11-04

• 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)

2003-11-05

• 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)

2003-11-06

• 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)

2003-11-09

• 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)

2003-11-10

• 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)

2003-11-11

• 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)

2003-11-12

• 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)

2003-11-13

• 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)

2003-11-14

• 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)

2003-11-15

• 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)

2003-11-16

• 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)

2003-11-17

• 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)

2003-11-18

• 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)

2003-11-19

• 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)

2003-11-20

• 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)

Prev | Next