Mailing lists [pgsql-performance]

1 November 2003

• 04:48   [ PROBLEM SOLVED ] Re: Query puts 7.3.4 on endless loop but 7.4beta5 is fine. Rajesh Kumar Mallah
• 16:54   Re: Pg+Linux swap use William Yu
• 16:54   Re: Postgres 7.3.4 + Slackware 9.1 Jeremy M. Guthrie

2 November 2003

• 15:33   Re: Pg+Linux swap use Greg Stark

3 November 2003

• 15:17   join_collapse_limit, from_collapse_limit options missing Lee Hughes
• 15:25   Re: join_collapse_limit, from_collapse_limit options missing Tom Lane
• 17:42   Re: join_collapse_limit, from_collapse_limit options missing Josh Berkus

4 November 2003

• 09:44   Re: Ignoring index on (A is null), (A is not null) conditions Cestmir Hybl
• 13:50   Re: Response time 
• 14:02   Re: Response time Pavel Stehule
• 19:13   Re: Response time Neil Conway

5 November 2003

• 12:01   Interbase/Firebird - any users out there - what's the performance like compared to PostgreSQL? Paul Ganainm
• 12:16   Re: Interbase/Firebird - any users out there - what's the Shridhar Daithankar
• 13:06   Re: Interbase/Firebird - any users out there - what's Franco Bruno Borghesi
• 16:36   Re: Response time 
• 16:41   Re: Response time Neil Conway
• 17:04   Re: Response time Andrew Sullivan

6 November 2003

• 07:44   horrible performance when trying to connect to PostgreSQL using ODBC Adrian Maier
• 13:58   Re: horrible performance when trying to connect to PostgreSQL using ODBC Tom Lane
• 18:17   Re: Interbase/Firebird - any users out there - what's the performance like compared to PostgreSQL? Christopher Browne
• 18:54   Re: Interbase/Firebird - any users out there - what's Hannu Krosing
• 21:59   Re: Pg+Linux swap use Bruce Momjian

8 November 2003

• 19:24   Re: Interbase/Firebird - any users out there - what's the performance like compared to PostgreSQL? Private

9 November 2003

• 14:06   Re: error while executing a c program with embedded sql 
• 14:34   Re: [NOVICE] error while executing a c program with embedded sql Tom Lane

10 November 2003

• 14:01   Re: [NOVICE] error while executing a c program with embedded sql 
• 19:21   *very* slow query to summarize data for a month ... Marc G. Fournier
• 19:40   Re: *very* slow query to summarize data for a month ... Patrick Hatcher
• 19:40   Re: *very* slow query to summarize data for a month ... Patrick Hatcher
• 20:02   Re: *very* slow query to summarize data for a month ... Josh Berkus
• 21:51   Re: *very* slow query to summarize data for a month ... Neil Conway
• 22:16   Re: *very* slow query to summarize data for a month ... Neil Conway
• 22:43   Re: *very* slow query to summarize data for a month ... Tom Lane
• 23:22   Re: *very* slow query to summarize data for a month ... Marc G. Fournier
• 23:30   Re: *very* slow query to summarize data for a month ... Marc G. Fournier
• 23:52   Re: *very* slow query to summarize data for a month ... Marc G. Fournier

11 November 2003

• 05:50   Re: *very* slow query to summarize data for a month ... Dennis Bjorklund
• 13:47   Suggestions for benchmarking 7.4RC2 against 7.3 Rajesh Kumar Mallah
• 14:05   Re: Suggestions for benchmarking 7.4RC2 against 7.3 Rajesh Kumar Mallah
• 16:47   Re: *very* slow query to summarize data for a month ... Greg Stark
• 17:16   Re: *very* slow query to summarize data for a month ... Marc G. Fournier
• 17:19   Re: Suggestions for benchmarking 7.4RC2 against 7.3 Christopher Browne
• 17:26   Re: Suggestions for benchmarking 7.4RC2 against 7.3 Josh Berkus
• 17:31   Re: *very* slow query to summarize data for a month ... Josh Berkus
• 17:40   Re: *very* slow query to summarize data for a month ... Marc G. Fournier
• 18:51   Re: *very* slow query to summarize data for a month ... Greg Stark
• 19:17   Re: Suggestions for benchmarking 7.4RC2 against 7.3 Rajesh Kumar Mallah
• 20:25   Re: Suggestions for benchmarking 7.4RC2 against 7.3 Rajesh Kumar Mallah
• 20:40   Re: *very* slow query to summarize data for a month ... scott.marlowe
• 22:33   Value of Quad vs. Dual Processor machine Chris Field
• 22:41   Re: Server Configs Anjan Dave
• 22:51   Re: Value of Quad vs. Dual Processor machine Rod Taylor
• 23:55   Re: Value of Quad vs. Dual Processor machine scott.marlowe

12 November 2003

• 00:03   Re: Value of Quad vs. Dual Processor machine allanwind@lifeintegrity.com (Allan Wind)
• 00:11   Re: Value of Quad vs. Dual Processor machine fred@redhotpenguin.com
• 00:25   Re: Value of Quad vs. Dual Processor machine Ron Johnson
• 01:12   Re: Value of Quad vs. Dual Processor machine Chris Field
• 02:18   Re: Value of Quad vs. Dual Processor machine Fred Moyer
• 04:53   Re: *very* slow query to summarize data for a month ... Greg Stark
• 07:43   Re: Value of Quad vs. Dual Processor machine Shridhar Daithankar
• 12:35   Seeking help with a query that takes too long Nick Fankhauser
• 13:28   Re: Value of Quad vs. Dual Processor machine Jeff
• 14:06   Re: Seeking help with a query that takes too long Manfred Koizar
• 14:44   Superior performance in PG 7.4 alexandre :: aldeia digital
• 14:56   Re: Seeking help with a query that takes too long Nick Fankhauser
• 15:06   Re: Seeking help with a query that takes too long Nick Fankhauser
• 15:10   Re: Value of Quad vs. Dual Processor machine scott.marlowe
• 15:11   Re: Seeking help with a query that takes too long Tom Lane
• 15:11   Re: *very* slow query to summarize data for a month ... Marc G. Fournier
• 15:53   Re: Seeking help with a query that takes too long Nick Fankhauser
• 16:11   Re: Seeking help with a query that takes too long Tom Lane
• 16:38   performance optimzations Suchandra Thapa
• 17:23   Re: performance optimzations Rod Taylor
• 17:28   Re: Seeking help with a query that takes too long Nick Fankhauser
• 17:55   Re: performance optimzations Suchandra Thapa
• 18:45   Seeking help with a query that take too long Nick Fankhauser - Doxpop
• 23:23   Re: performance optimzations Neil Conway
• 23:23   Re: Seeking help with a query that takes too long Manfred Koizar
• 23:23   Re: performance optimzations Suchandra Thapa

13 November 2003

• 03:07   Query question Christopher Kings-Lynne
• 03:36   Re: performance optimzations Rod Taylor
• 04:21   Re: Query question Josh Berkus
• 05:03   Re: performance optimzations Suchandra Thapa
• 06:51   IN surpasses NOT EXISTS in 7.4RC2 ?? Rajesh Kumar Mallah
• 12:48   Re: performance optimzations Rod Taylor
• 14:51   Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Tom Lane
• 15:00   Re: Value of Quad vs. Dual Processor machine Robert Treat
• 15:25   Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Bruce Momjian
• 15:34   Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Rajesh Kumar Mallah
• 15:39   Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Robert Treat
• 16:00   Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Tom Lane
• 16:20   Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Robert Treat
• 17:14   strange estimate for number of rows Andrew Sullivan
• 17:28   Union+group by planner estimates way off? Arthur Ward
• 17:47   Re: Union+group by planner estimates way off? Tom Lane
• 17:57   Re: strange estimate for number of rows Tom Lane
• 18:19   Re: Union+group by planner estimates way off? Arthur Ward
• 18:27   Re: IN surpasses NOT EXISTS in 7.4RC2 ?? Rajesh Kumar Mallah
• 18:39   Storage space, RAM for NUMERIC Josh Berkus
• 18:43   Re: strange estimate for number of rows Daniel Manley
• 19:19   Re: strange estimate for number of rows Tom Lane
• 20:37   Re: strange estimate for number of rows Andrew Sullivan
• 20:53   Re: strange estimate for number of rows Andrew Sullivan

14 November 2003

• 06:19   Help with count(*) Rajesh Kumar Mallah
• 06:44   Re: Help with count(*) Shridhar Daithankar
• 08:45   INSERT extremely slow with large data sets (fwd) Slavisa Garic
• 09:12   IDE Hardware RAID Controller Nick Barr
• 12:38   Re: INSERT extremely slow with large data sets (fwd) Jeff
• 13:49   Re: Help with count(*) Christopher Browne
• 14:17   constant vs function param differs in performance SZŰCS Gábor
• 15:01   Re: Seeking help with a query that takes too long Nick Fankhauser
• 15:08   Re: Query question Neil Conway
• 15:38   Re: Seeking help with a query that takes too long Manfred Koizar
• 15:41   Re: Query question Tom Lane
• 16:44   Re: Help with count(*) Hannu Krosing
• 17:51   Re: Help with count(*) Tom Lane
• 18:41   Re: Help with count(*) Will LaShell
• 18:49   Re: Help with count(*) Christopher Browne
• 19:39   Re: Help with count(*) Tom Lane
• 19:59   Re: constant vs function param differs in performance Tom Lane
• 20:28   n_distinct way off, but following a pattern. Nick Fankhauser
• 20:30   Re: Help with count(*) Andrew Sullivan
• 21:03   Re: INSERT extremely slow with large data sets (fwd) George Essig
• 21:08   Re: Error in transaction processing 
• 21:13   Re: n_distinct way off, but following a pattern. Tom Lane

15 November 2003

• 00:21   Re: INSERT extremely slow with large data sets (fwd) Slavisa Garic
• 02:37   Re: Query question Christopher Kings-Lynne
• 09:21   Re: Help with count(*) Dennis Bjorklund
• 12:14   Re: INSERT extremely slow with large data sets (fwd) George Essig
• 13:53   Re: Error in transaction processing 
• 19:21   Re: Help with count(*) Neil Conway

16 November 2003

• 12:53   Re: n_distinct way off, but following a pattern. Nick Fankhauser
• 14:23   Re: Help with count(*) Tom Lane

17 November 2003

• 13:43   Re: INSERT extremely slow with large data sets (fwd) Andrew Sullivan
• 13:52   Backup/restore of pg_statistics Joel Jacobson
• 15:39   Top n queries and GROUP BY Rich Cullingford
• 16:57   Re: Top n queries and GROUP BY Rich Cullingford
• 21:22   duration logging setting in 7.4 Ryszard Lach

18 November 2003

• 01:38   Re: duration logging setting in 7.4 Bruce Momjian
• 08:18   Re: duration logging setting in 7.4 Ryszard Lach
• 09:10   Join on incompatible types Laurent Martelli
• 09:46   Re: Join on incompatible types Shridhar Daithankar
• 14:08   Re: duration logging setting in 7.4 Bruce Momjian
• 16:01   Re: Top n queries and GROUP BY Harald Fuchs
• 18:47   Re: Join on incompatible types Laurent Martelli
• 23:01   More detail on settings for pgavd? Josh Berkus

19 November 2003

• 00:20   High Processor consumption Benjamin Bostow
• 00:37   problem with select count(*) .. Rajesh Kumar Mallah
• 05:33   Re: More detail on settings for pgavd? Shridhar Daithankar
• 05:34   Re: High Processor consumption Shridhar Daithankar
• 05:54   Re: Join on incompatible types Shridhar Daithankar
• 08:18   TEXT column and indexing Ian Barwick
• 09:01   Re: Join on incompatible types Laurent Martelli
• 09:20   Re: Join on incompatible types Shridhar Daithankar
• 11:24   Re: Join on incompatible types Laurent Martelli
• 11:32   Re: Join on incompatible types Shridhar Daithankar
• 13:12   Re: More detail on settings for pgavd? Shridhar Daithankar
• 15:07   Re: constant vs function param differs in performance SZŰCS Gábor
• 15:07   Re: More detail on settings for pgavd? Josh Berkus
• 15:09   Re: problem with select count(*) .. Bruno Wolff III
• 16:12   Re: TEXT column and indexing Stephan Szabo
• 16:15   Re: TEXT column and indexing Manfred Koizar
• 16:28   Re: More detail on settings for pgavd? Josh Berkus
• 17:59   Re: duration logging setting in 7.4 Bruce Momjian
• 18:15   Re: TEXT column and indexing Ian Barwick
• 18:17   Re: TEXT column and indexing Ian Barwick
• 18:26   Re: duration logging setting in 7.4 Ryszard Lach
• 18:34   Re: duration logging setting in 7.4 Ryszard Lach
• 18:45   Re: duration logging setting in 7.4 Bruce Momjian

20 November 2003

• 03:40   Re: Backup/restore of pg_statistics Tom Lane
• 04:58   Re: High Processor consumption Shridhar Daithankar
• 06:24   Re: More detail on settings for pgavd? Shridhar Daithankar
• 14:00   Re: [HACKERS] More detail on settings for pgavd? Shridhar Daithankar
• 14:08   Re: [HACKERS] More detail on settings for pgavd? Shridhar Daithankar
• 16:19   Re: [HACKERS] More detail on settings for pgavd? Josh Berkus
• 17:01   Re: More detail on settings for pgavd? Josh Berkus
• 17:49   Re: [HACKERS] More detail on settings for pgavd? Chester Kustarz
• 18:21   Re: [HACKERS] More detail on settings for pgavd? Tom Lane
• 19:55   Re: [HACKERS] More detail on settings for pgavd? Chester Kustarz
• 20:10   Problem with insert into select... stephen farrell
• 21:59   Re: Problem with insert into select... Tom Lane
• 23:17   Re: duration logging setting in 7.4 Tom Lane

21 November 2003

• 01:05   Re: Problem with insert into select... stephen farrell
• 05:25   Re: [HACKERS] More detail on settings for pgavd? Josh Berkus
• 07:54   Re: duration logging setting in 7.4 Ryszard Lach
• 13:15   Re: [HACKERS] More detail on settings for pgavd? Robert Treat
• 13:55   Re: duration logging setting in 7.4 Tom Lane
• 13:56   Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor
• 14:07   Re: [HACKERS] More detail on settings for pgavd? Shridhar Daithankar
• 14:18   Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor
• 16:10   Re: [HACKERS] More detail on settings for pgavd? Josh Berkus
• 20:25   Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor
• 20:34   Re: [HACKERS] More detail on settings for pgavd? Josh Berkus
• 20:53   Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor
• 21:00   Re: [HACKERS] More detail on settings for pgavd? Josh Berkus
• 21:41   Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor
• 22:05   Re: [HACKERS] More detail on settings for pgavd? Tom Lane
• 22:54   Re: [HACKERS] More detail on settings for pgavd? Chester Kustarz

22 November 2003

• 10:57   pg_autoconfig.pl Nick Barr
• 16:20   Re: pg_autoconfig.pl Josh Berkus

24 November 2003

• 02:51   Maximum Possible Insert Performance? William Yu
• 03:22   Re: Maximum Possible Insert Performance? Tom Lane
• 03:30   Re: Maximum Possible Insert Performance? Josh Berkus
• 03:42   Re: Maximum Possible Insert Performance? Joe Conway
• 04:51   Re: Maximum Possible Insert Performance? Shridhar Daithankar
• 10:26   Re: pg_autoconfig.pl Nick Barr
• 15:03   Re: Maximum Possible Insert Performance? Bill Moran
• 16:14   VACUUM problems with 7.4 Rajesh Kumar Mallah
• 16:21   Re: Maximum Possible Insert Performance? William Yu
• 16:27   Re: Maximum Possible Insert Performance? Josh Berkus
• 16:45   Re: VACUUM problems with 7.4 Tom Lane
• 16:51   Re: Maximum Possible Insert Performance? William Yu
• 17:02   Re: VACUUM problems with 7.4 
• 17:06   Re: Maximum Possible Insert Performance? Josh Berkus
• 17:52   Re: Maximum Possible Insert Performance? William Yu
• 17:53   Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor
• 17:55   Re: duration logging setting in 7.4 Ryszard Lach
• 17:55   Re: Hardware advice Adam Witney
• 17:56   Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor
• 17:56   Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor
• 17:56   Problem with insert into select... stephen farrell
• 17:57   Re: [HACKERS] More detail on settings for pgavd? Alvaro Herrera Munoz
• 18:30   Re: Problem with insert into select... Richard Huxton
• 19:48   Optimize Torsten Schulz
• 20:20   Re: Optimize Gaetano Mendola
• 20:33   Re: Optimize Torsten Schulz
• 20:46   Re: Optimize Dennis Bjorklund
• 20:56   Re: Optimize Gaetano Mendola
• 21:03   Where to start for performance problem? MK Spam
• 21:08   Re: Where to start for performance problem? Nid

25 November 2003

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

26 November 2003

• 05:07   Re: Optimize Shridhar Daithankar
• 15:39   expression (functional) index use in joins Roger Ging
• 15:52   Re: Maximum Possible Insert Performance? William Yu
• 16:12   Re: Impossibly slow DELETEs Greg Stark
• 16:33   Re: why index scan not working when using 'like'? Hannu Krosing
• 16:56   Re: Maximum Possible Insert Performance? Tom Lane
• 17:00   Re: expression (functional) index use in joins Richard Huxton
• 17:22   Re: Maximum Possible Insert Performance? William Yu
• 17:39   Followup - expression (functional) index use in joins Roger Ging
• 17:54   Re: Maximum Possible Insert Performance? Dror Matalon
• 18:18   Re: Followup - expression (functional) index use in joins Richard Huxton
• 19:03   For full text indexing, which is better, tsearch2 or fulltextindex LIANHE SHAO
• 19:14   cross table indexes or something? Jeremiah Jahn
• 19:19   very large db performance question LIANHE SHAO
• 20:29   Re: Followup - expression (functional) index use in joins Roger Ging
• 21:04   Re: very large db performance question Neil Conway
• 21:24   Re: cross table indexes or something? Marc A. Leith
• 21:33   Re: cross table indexes or something? Hannu Krosing
• 21:43   Re: very large db performance question LIANHE SHAO
• 23:09   Re: Followup - expression (functional) index use in joins Tom Lane
• 23:47   Re: For full text indexing, which is better, tsearch2 or Christopher Kings-Lynne
• 23:59   Re: very large db performance question Christopher Kings-Lynne

27 November 2003

• 00:04   Re: For full text indexing, which is better, tsearch2 or Dror Matalon
• 02:35   Re: For full text indexing, which is better, tsearch2 or Steve Atkins
• 03:39   Re: For full text indexing, which is better, tsearch2 or Christopher Kings-Lynne
• 04:17   Re: For full text indexing, which is better, tsearch2 or Steve Atkins
• 07:44   Re: very large db performance question Thierry Missimilly
• 18:58   Re: Impossibly slow DELETEs Stefan Champailler

28 November 2003

• 04:09   Re: For full text indexing, which is better, tsearch2 or Steve Atkins
• 04:14   Re: For full text indexing, which is better, tsearch2 or Christopher Kings-Lynne
• 04:23   Re: For full text indexing, which is better, tsearch2 or Christopher Kings-Lynne
• 04:59   simple left join slows query more than expected Jonathan Knopp
• 16:56   Re: simple left join slows query more than expected Tom Lane
• 17:15   Re: duration logging setting in 7.4 Tom Lane
• 17:15   Re: Maximum Possible Insert Performance? Suchandra Thapa
• 19:58   Re: For full text indexing, which is better, tsearch2 or Steve Atkins

30 November 2003

• 08:47   Re: For full text indexing, which is better, tsearch2 or Christopher Kings-Lynne