Mailing lists [pgsql-performance]

1 May 2004

• 01:21   Re: planner/optimizer question Tom Lane
• 03:05   Re: Insert only tables and vacuum performance Tom Lane
• 04:04   Re: Wierd context-switching issue on Xeon Robert Creager
• 11:18   Re: planner/optimizer question Jochem van Dieten
• 12:48   Re: planner/optimizer question Gary Doades
• 16:23   Re: planner/optimizer question Tom Lane
• 18:51   Re: Wierd context-switching issue on Xeon Dave Cramer

2 May 2004

• 08:01   Re: planner/optimizer question Manfred Koizar
• 08:10   Recommended File System Configuration James Thornton
• 14:31   Re: planner/optimizer question Jochem van Dieten
• 15:21   Re: Wierd context-switching issue on Xeon Robert Creager
• 15:39   Re: Wierd context-switching issue on Xeon Dave Cramer
• 21:47   Re: Wierd context-switching issue on Xeon Robert Creager

3 May 2004

• 17:16   Re: Recommended File System Configuration Chris Browne

4 May 2004

• 02:46   Re: linux distro for better pg performance Joseph Shraibman
• 02:46   cache table Joseph Shraibman
• 03:41   Re: linux distro for better pg performance James Thornton
• 03:47   Re: linux distro for better pg performance Alan Stange
• 04:24   INSERT RULE Pailloncy Jean-Gérard
• 04:24   Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait! Pailloncy Jean-Gérard
• 06:03   Re: linux distro for better pg performance Greg Stark
• 07:37   Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait! Mark Kirkwood
• 12:06   Re: linux distro for better pg performance Aaron Werman
• 13:55   Re: cache table scott.marlowe
• 15:46   Re: cache table Joseph Shraibman
• 16:32   Re: Bug in optimizer Bruno Wolff III
• 18:15   Re: cache table Greg Stark
• 18:44   pg_stat Litao Wu
• 19:33   Adapting Oracle S.A.M.E. Methodology for Postgres James Thornton
• 19:38   Re: Recommended File System Configuration James Thornton
• 22:15   Re: Horribly slow hash join Greg Stark
• 23:35   very high CPU usage in "top", but not in "mpstat" Cyrille Bonnet

5 May 2004

• 13:03   Re: very high CPU usage in "top", but not in "mpstat" Tom Lane
• 16:52   History of oids in postgres? James Robinson
• 16:54   Re: [ADMIN] 7.4.2 out of memory Jie Liang
• 16:57   7.4.2 out of memory Jie Liang
• 16:57   Re: INSERT RULE Pailloncy Jean-Gérard
• 16:59   LIKE and INDEX Jie Liang
• 17:18   Re: History of oids in postgres? Bruce Momjian
• 18:27   Re: very high CPU usage in "top", but not in "mpstat" Paul Tuckfield
• 18:31   Re: LIKE and INDEX Richard Huxton
• 19:30   Re: LIKE and INDEX Rod Taylor
• 20:24   [OFF-TOPIC] - Known maximum size of the PostgreSQL Database Carlos Eduardo Smanioto
• 21:11   Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL J. Andrew Rogers
• 21:23   Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL scott.marlowe

6 May 2004

• 01:39   Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL Christopher Kings-Lynne
• 08:13   Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL Richard Huxton
• 08:43   Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL Shridhar Daithankar
• 08:59   Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Grega Bremec
• 13:46   Re: [OFF-TOPIC] - Known maximum size of the Don Vaillancourt
• 15:45   Re: pg_stat Litao Wu
• 18:11   Re: INSERT RULE Richard Huxton
• 23:41   Re: [pgsql-advocacy] [OFF-TOPIC] - Known maximum size of Gavin Sherry

7 May 2004

• 10:58   Help how to tune-up my Database Michael Ryan S. Puncia
• 16:01   Re: Help how to tune-up my Database scott.marlowe
• 23:47   Re: [OFF-TOPIC] - Known maximum size of the Gaetano Mendola

10 May 2004

• 14:00   Why queries takes too much time to execute? Anderson Boechat Lopes
• 14:22   Re: Why queries takes too much time to execute? Shridhar Daithankar
• 14:24   Re: Why queries takes too much time to execute? Christopher Kings-Lynne
• 17:36   Re: Why queries takes too much time to execute? Anderson Boechat Lopes
• 18:54   Configuring PostgreSQL to minimize impact of checkpoints jao@geophile.com
• 19:10   Re: Configuring PostgreSQL to minimize impact of checkpoints Bruce Momjian
• 19:17   Re: Why queries takes too much time to execute? Chris Browne
• 19:49   Re: Help how to tune-up my Database Bricklen
• 20:00   Re: Why queries takes too much time to execute? scott.marlowe
• 20:23   Re: Help how to tune-up my Database scott.marlowe

11 May 2004

• 02:04   Re: Configuring PostgreSQL to minimize impact of checkpoints Jack Orenstein
• 02:34   Re: Configuring PostgreSQL to minimize impact of checkpoints Bruce Momjian
• 03:24   Re: Configuring PostgreSQL to minimize impact of checkpoints Tom Lane
• 13:35   Re: Configuring PostgreSQL to minimize impact of checkpoints Matthew Nuzum
• 14:42   Re: Configuring PostgreSQL to minimize impact of checkpoints Tom Lane
• 15:12   Re: Configuring PostgreSQL to minimize impact of checkpoints Rob Fielding
• 16:55   Re: Configuring PostgreSQL to minimize impact of checkpoints jao@geophile.com
• 17:31   Re: Configuring PostgreSQL to minimize impact of checkpoints scott.marlowe
• 18:48   Re: Help how to tune-up my Database Bricklen
• 19:13   Re: Configuring PostgreSQL to minimize impact of checkpoints Paul Tuckfield
• 19:13   Quad processor options Bjoern Metzdorf
• 19:33   Re: Quad processor options Anjan Dave
• 20:15   Re: Quad processor options Paul Tuckfield
• 20:17   Re: Quad processor options scott.marlowe
• 20:23   Re: Configuring PostgreSQL to minimize impact of checkpoints scott.marlowe
• 20:33   Re: Quad processor options Bjoern Metzdorf
• 20:39   Re: Quad processor options Anjan Dave
• 20:43   Re: Quad processor options Bjoern Metzdorf
• 21:03   Re: Quad processor options scott.marlowe
• 21:06   Re: Quad processor options Bjoern Metzdorf
• 21:07   Re: Quad processor options Bjoern Metzdorf
• 21:16   Re: Quad processor options Bjoern Metzdorf
• 21:30   Re: Quad processor options scott.marlowe
• 21:43   Re: Quad processor options Rob Sell
• 21:47   Re: Configuring PostgreSQL to minimize impact of checkpoints Rob Sell
• 21:53   Re: Configuring PostgreSQL to minimize impact of checkpoints Paul Tuckfield
• 22:02   Clarification on some settings Doug Y
• 22:08   Re: Configuring PostgreSQL to minimize impact of checkpoints scott.marlowe
• 22:09   Re: Configuring PostgreSQL to minimize impact of checkpoints scott.marlowe
• 22:10   Intermittent slowdowns, connection delays Jason Coene
• 22:17   Re: Quad processor options allanwind@lifeintegrity.com (Allan Wind)
• 22:24   Re: Quad processor options J. Andrew Rogers
• 22:33   Re: Configuring PostgreSQL to minimize impact of J. Andrew Rogers
• 22:47   Re: Quad processor options Paul Tuckfield
• 22:53   Re: Quad processor options scott.marlowe

12 May 2004

• 01:06   Re: Intermittent slowdowns, connection delays Jason Coene
• 04:04   Re: Quad processor options Dennis Bjorklund
• 04:59   Re: Quad processor options Grega Bremec
• 05:35   Re: Quad processor options spied@yandex.ru
• 06:11   Using LIKE expression problem.. Michael Ryan S. Puncia
• 06:41   Re: Using LIKE expression problem.. Christopher Kings-Lynne
• 07:39   Re: Using LIKE expression problem.. Michael Ryan S. Puncia
• 07:51   Re: Using LIKE expression problem.. Christopher Kings-Lynne
• 08:07   Re: Using LIKE expression problem.. Michael Ryan S. Puncia
• 10:15   Re: Quad processor options Manfred Koizar
• 13:44   Re: Clarification on some settings Shridhar Daithankar
• 13:46   Re: [ADMIN] Quad processor options scott.marlowe
• 18:58   Re: Configuring PostgreSQL to minimize impact of checkpoints Vivek Khera
• 19:05   Re: Configuring PostgreSQL to minimize impact of Vivek Khera
• 19:25   Re: Configuring PostgreSQL to minimize impact of checkpoints jao@geophile.com
• 19:29   Re: Configuring PostgreSQL to minimize impact of checkpoints Vivek Khera
• 22:41   Quad processor options - summary Bjoern Metzdorf

13 May 2004

• 12:33   Query plan on identical tables differs . Why ? Fabio Panizzutti
• 13:02   Re: Clarification on some settings Neil Conway
• 13:05   Re: Query plan on identical tables differs . Why ? Shridhar Daithankar
• 13:16   Off Topic - Re: Quad processor options - summary Greg Spiegelberg
• 13:56   R: Query plan on identical tables differs . Why ? Fabio Panizzutti
• 13:57   Re: Clarification on some settings Mark Kirkwood
• 15:01   Re: R: Query plan on identical tables differs . Why ? Tom Lane
• 15:16   Re: R: Query plan on identical tables differs . Why ? Stephan Szabo
• 19:42   Re: Clarification on some settings Doug Y
• 20:28   Re: Clarification on some settings Greg Copeland
• 21:01   Re: Quad processor options - summary James Thornton
• 21:54   Re: Quad processor options - summary Bjoern Metzdorf
• 22:49   Re: Quad processor options - summary James Thornton
• 23:35   Re: [ADMIN] Quad processor options - summary James Thornton

14 May 2004

• 00:52   Re: Quad processor options - summary Paul Tuckfield
• 01:04   Re: Quad processor options Andrew McMillan
• 08:30   R: R: Query plan on identical tables differs . Why ? Fabio Panizzutti
• 08:45   R: R: Query plan on identical tables differs . Why ? Fabio Panizzutti
• 09:13   R: R: Query plan on identical tables differs . Why ? Fabio Panizzutti
• 09:55   Re: R: R: Query plan on identical tables differs . Why ? Christopher Kings-Lynne
• 10:15   Re: Quad processor options - summary Mark Kirkwood
• 10:20   R: R: R: Query plan on identical tables differs . Why ? Fabio Panizzutti
• 18:12   TPCH 100GB - need some help Eduardo Almeida
• 18:26   Re: TPCH 100GB - need some help Rod Taylor
• 21:08   numeric data types Jaime Casanova

15 May 2004

• 04:03   Re: numeric data types Tom Lane
• 16:04   Re: TPCH 100GB - need some help Tom Lane

16 May 2004

• 17:13   Re: numeric data types Neil Conway

17 May 2004

• 23:10   Hardware Platform Duane Lee - EGOVX

18 May 2004

• 12:51   Re: TPCH 100GB - need some help Eduardo Almeida
• 18:43   Interpreting vmstat Doug Y
• 21:30   where to find out when a table was last analyzed? Litao Wu

19 May 2004

• 03:20   Re: Using LIKE expression problem.. Joseph Shraibman
• 03:39   Re: Quad processor options Marty Scholes
• 07:31   DB Design Michael Ryan S. Puncia
• 11:22   Re: DB Design Andrew McMillan
• 19:51   shared buffer size on linux Joseph Shraibman
• 20:07   PostgreSQL performance in simple queries Eugeny Balakhonov
• 20:23   Re: PostgreSQL performance in simple queries Gary Doades
• 21:51   Re: PostgreSQL performance in simple queries Neil Conway

20 May 2004

• 01:22   Re: Wierd context-switching issue on Xeon Bruce Momjian
• 02:00   Re: Wierd context-switching issue on Xeon Robert Creager
• 02:42   Re: Wierd context-switching issue on Xeon Tom Lane
• 02:44   Re: Wierd context-switching issue on Xeon Tom Lane
• 03:05   Re: Wierd context-switching issue on Xeon Bruce Momjian
• 03:07   Re: Wierd context-switching issue on Xeon Robert Creager
• 04:01   Re: Wierd context-switching issue on Xeon Tom Lane
• 04:05   Re: Wierd context-switching issue on Xeon Tom Lane
• 04:12   Re: Wierd context-switching issue on Xeon Bruce Momjian
• 04:13   Re: Wierd context-switching issue on Xeon Bruce Momjian
• 05:11   Re: Wierd context-switching issue on Xeon Matthew T. O'Connor
• 05:19   Re: PostgreSQL performance in simple queries Joseph Shraibman
• 05:19   Re: Wierd context-switching issue on Xeon Christopher Browne
• 09:28   Re: DB Design Mark Kirkwood
• 13:46   Re: Hardware Platform Marty Scholes
• 15:38   Re: PostgreSQL performance in simple queries Tom Lane
• 15:58   Re: PostgreSQL performance in simple queries Bruce Momjian
• 16:01   Re: Interpreting vmstat Thom Dyson
• 16:57   Re: PostgreSQL performance in simple queries Joseph Shraibman
• 21:52   Re: Wierd context-switching issue on Xeon Josh Berkus
• 22:16   Re: Wierd context-switching issue on Xeon Tom Lane

21 May 2004

• 14:42   PostgreSQL caching Vitaly Belman
• 15:30   Re: PostgreSQL caching Rosser Schwarz
• 15:34   Re: PostgreSQL caching Richard Huxton
• 17:33   Re: PostgreSQL caching Vitaly Belman
• 18:20   Re: PostgreSQL caching Chris Browne
• 18:34   Re: PostgreSQL caching Rod Taylor
• 18:50   Avoiding vacuum full on an UPDATE-heavy table Bill Montgomery
• 19:02   Re: PostgreSQL caching Neil Conway
• 19:23   Re: Avoiding vacuum full on an UPDATE-heavy table Matthew T. O'Connor
• 20:11   Re: PostgreSQL caching Marty Scholes
• 20:36   Re: Avoiding vacuum full on an UPDATE-heavy table Vivek Khera
• 21:32   Re: Avoiding vacuum full on an UPDATE-heavy table Bill Montgomery
• 22:09   Re: Avoiding vacuum full on an UPDATE-heavy table Tom Lane
• 23:23   tuning for AIX 5L with large memory Dan Harris

22 May 2004

• 02:20   Re: tuning for AIX 5L with large memory Christopher Browne
• 02:31   Re: tuning for AIX 5L with large memory Neil Conway

23 May 2004

• 06:25   Re: PostgreSQL caching Vitaly Belman
• 06:55   Re: tuning for AIX 5L with large memory Dan Harris

24 May 2004

• 16:51   index's relpages after table analyzed Litao Wu
• 17:21   Re: index's relpages after table analyzed Litao Wu
• 19:05   Re: index's relpages after table analyzed Josh Berkus
• 19:09   Re: Avoiding vacuum full on an UPDATE-heavy table Josh Berkus
• 19:48   Re: index's relpages after table analyzed Litao Wu
• 22:52   Re: PostgreSQL caching Marty Scholes

25 May 2004

• 01:23   Re: index's relpages after table analyzed Tom Lane
• 02:50   Server process Michael Ryan S. Puncia
• 03:01   Re: Server process Christopher Kings-Lynne
• 15:38   Re: PostgreSQL caching Jochem van Dieten
• 19:53   Re: PostgreSQL caching Vitaly Belman
• 21:08   Re: Interpreting vmstat Robert Treat
• 22:32   Re: PostgreSQL caching Marty Scholes

26 May 2004

• 13:14   Re: PostgreSQL caching Robert Treat
• 13:29   Re: where to find out when a table was last analyzed? Robert Treat
• 14:33   Re: PostgreSQL caching Vitaly Belman
• 16:18   Re: PostgreSQL caching Josh Berkus
• 16:26   Re: [GENERAL] performance very slow Bill Montgomery
• 17:21   Re: tuning for AIX 5L with large memory Chris Browne
• 17:22   Re: tuning for AIX 5L with large memory Chris Browne
• 18:00   Re: PostgreSQL caching Vitaly Belman

27 May 2004

• 13:57   Re: PostgreSQL caching Matthew Nuzum
• 22:41   Hardware opinions wanted Dan Harris

28 May 2004

• 10:43   Re: Hardware opinions wanted Bjoern Metzdorf
• 23:56   Re: [GENERAL] performance very slow Mario Soto
• 23:57   Not using Primary Key in query Josh Sacks
• 23:57   Re: filesystem option tuning share-postgres@think42.com

29 May 2004

• 05:06   Re: Not using Primary Key in query Tom Lane
• 07:04   Logging all query in one seperate File rajaguru
• 09:31   Re: filesystem option tuning Shridhar Daithankar
• 18:31   Re: filesystem option tuning Tom Lane