Search

Peripheral Links

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

pgsql-performance - May 2004

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

Prev | Next

2004-05-01

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

2004-05-02

• Re: planner/optimizer question Manfred Koizar (08:03)
• Recommended File System Configuration James Thornton (08:11)
• Re: planner/optimizer question Jochem van Dieten (14:30)
• Re: Wierd context-switching issue on Xeon Robert Creager (15:20)
• Re: Wierd context-switching issue on Xeon Dave Cramer (15:39)
• Re: Wierd context-switching issue on Xeon Robert Creager (21:46)

2004-05-03

• Bug in optimizer Timo Nentwig (16:08)
• Re: Recommended File System Configuration Chris Browne (16:38)
• INSERT RULE Pailloncy Jean-Gérard (20:58)

2004-05-04

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

2004-05-05

• Re: very high CPU usage in "top", but not in "mpstat" Tom Lane (13:03)
• Re: History of oids in postgres? Bruce Momjian (17:03)
• Re: Bug in optimizer Gaetano Mendola (17:31)
• Re: LIKE and INDEX Rod Taylor (17:31)
• Re: LIKE and INDEX Richard Huxton (18:12)
• Re: very high CPU usage in "top", but not in "mpstat" Paul Tuckfield (18:13)
• Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL J. Andrew Rogers (21:11)
• Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL scott.marlowe (21:23)

2004-05-06

• Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL Christopher Kings-Lynne (01:48)
• Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL Richard Huxton (08:13)
• Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL Shridhar Daithankar (08:43)
• Re: [PERFORM] MySQL vs PG TPC-H benchmarks Grega Bremec (08:59)
• Re: [OFF-TOPIC] - Known maximum size of the Don Vaillancourt (13:47)
• Re: pg_stat Litao Wu (15:44)
• Re: INSERT RULE Richard Huxton (18:10)
• Re: [PERFORM] [OFF-TOPIC] - Known maximum size of Gavin Sherry (22:29)

2004-05-07

• Help how to tune-up my Database Michael Ryan S. Puncia (11:07)
• Re: Help how to tune-up my Database scott.marlowe (16:00)
• Re: Help how to tune-up my Database Bricklen (16:47)
• Re: [OFF-TOPIC] - Known maximum size of the Gaetano Mendola (23:35)

2004-05-10

• Why queries takes too much time to execute? Anderson Boechat Lopes (14:00)
• Re: Why queries takes too much time to execute? Shridhar Daithankar (14:21)
• Re: Why queries takes too much time to execute? Christopher Kings-Lynne (14:24)
• Re: Why queries takes too much time to execute? Anderson Boechat Lopes (17:36)
• Re: Why queries takes too much time to execute? Chris Browne (18:11)
• Configuring PostgreSQL to minimize impact of checkpoints jao (18:52)
• Re: Configuring PostgreSQL to minimize impact of checkpoints Bruce Momjian (19:09)
• Re: Why queries takes too much time to execute? scott.marlowe (19:59)
• Re: Help how to tune-up my Database scott.marlowe (20:23)
• Re: Help how to tune-up my Database Bricklen (20:37)

2004-05-11

• Re: Configuring PostgreSQL to minimize impact of checkpoints Jack Orenstein (02:02)
• Re: Configuring PostgreSQL to minimize impact of checkpoints Bruce Momjian (02:33)
• Re: Configuring PostgreSQL to minimize impact of checkpoints Tom Lane (03:23)
• Re: Configuring PostgreSQL to minimize impact of checkpoints Matthew Nuzum (13:35)
• Re: Configuring PostgreSQL to minimize impact of checkpoints Tom Lane (14:41)
• Re: Configuring PostgreSQL to minimize impact of checkpoints Rob Fielding (15:12)
• Re: Configuring PostgreSQL to minimize impact of checkpoints jao (16:52)
• Re: Configuring PostgreSQL to minimize impact of checkpoints scott.marlowe (17:30)
• Quad processor options Bjoern Metzdorf (19:06)
• Re: Configuring PostgreSQL to minimize impact of checkpoints Paul Tuckfield (19:12)
• Re: [PERFORM] Quad processor options Anjan Dave (19:32)
• Re: [PERFORM] Quad processor options Paul Tuckfield (20:14)
• Re: [PERFORM] Quad processor options scott.marlowe (20:16)
• Re: Configuring PostgreSQL to minimize impact of checkpoints scott.marlowe (20:22)
• Re: [PERFORM] Quad processor options Bjoern Metzdorf (20:28)
• Re: [PERFORM] Quad processor options Anjan Dave (20:38)
• Re: [PERFORM] Quad processor options Bjoern Metzdorf (20:41)
• Re: [PERFORM] Quad processor options Bjoern Metzdorf (20:45)
• Re: [PERFORM] Quad processor options Bjoern Metzdorf (20:46)
• Re: [PERFORM] Quad processor options scott.marlowe (21:02)
• Re: [PERFORM] Quad processor options Bjoern Metzdorf (21:11)
• Re: [PERFORM] Quad processor options scott.marlowe (21:29)
• Clarification on some settings Doug Y (21:36)
• Re: Quad processor options Rob Sell (21:42)
• Re: Configuring PostgreSQL to minimize impact of checkpoints Rob Sell (21:47)
• Re: Configuring PostgreSQL to minimize impact of checkpoints Paul Tuckfield (21:52)
• Re: Configuring PostgreSQL to minimize impact of checkpoints scott.marlowe (22:07)
• Re: Configuring PostgreSQL to minimize impact of checkpoints scott.marlowe (22:08)
• Intermittent slowdowns, connection delays Jason Coene (22:10)
• Re: Quad processor options Allan Wind (22:13)
• Re: Quad processor options J. Andrew Rogers (22:23)
• Re: Configuring PostgreSQL to minimize impact of J. Andrew Rogers (22:32)
• Re: Quad processor options scott.marlowe (22:44)
• Re: [PERFORM] Quad processor options Paul Tuckfield (22:46)

2004-05-12

• Re: Intermittent slowdowns, connection delays Jason Coene (01:04)
• Re: [PERFORM] Quad processor options Dennis Bjorklund (04:03)
• Re: [PERFORM] Quad processor options Grega Bremec (04:58)
• Re: Quad processor options spied (05:34)
• Using LIKE expression problem.. Michael Ryan S. Puncia (06:18)
• Re: Using LIKE expression problem.. Christopher Kings-Lynne (06:48)
• Re: Using LIKE expression problem.. Michael Ryan S. Puncia (07:46)
• Re: Using LIKE expression problem.. Christopher Kings-Lynne (07:59)
• Re: Using LIKE expression problem.. Michael Ryan S. Puncia (08:17)
• Re: Quad processor options Andrew McMillan (08:58)
• Re: Clarification on some settings Shridhar Daithankar (09:02)
• Re: [PERFORM] Quad processor options Manfred Koizar (10:17)
• Re: [PERFORM] Quad processor options Halford Dace (10:27)
• Re: [PERFORM] Quad processor options scott.marlowe (13:44)
• Re: Configuring PostgreSQL to minimize impact of checkpoints Vivek Khera (18:57)
• Re: Configuring PostgreSQL to minimize impact of Vivek Khera (19:05)
• Re: Configuring PostgreSQL to minimize impact of checkpoints jao (19:22)
• Re: Configuring PostgreSQL to minimize impact of checkpoints Vivek Khera (19:29)
• Quad processor options - summary Bjoern Metzdorf (22:40)

2004-05-13

• Re: Clarification on some settings Neil Conway (06:44)
• Re: Clarification on some settings Mark Kirkwood (07:31)
• Query plan on identical tables differs . Why ? Fabio Panizzutti (12:42)
• Re: Query plan on identical tables differs . Why ? Shridhar Daithankar (13:05)
• Off Topic - Re: [PERFORM] Quad processor options - summary Greg Spiegelberg (13:15)
• R: Query plan on identical tables differs . Why ? Fabio Panizzutti (14:06)
• Re: R: Query plan on identical tables differs . Why ? Tom Lane (15:01)
• Re: R: Query plan on identical tables differs . Why ? Stephan Szabo (15:16)
• Re: Clarification on some settings Doug Y (19:42)
• Re: Clarification on some settings Greg Copeland (20:28)
• Re: [PERFORM] Quad processor options - summary James Thornton (21:02)
• Re: [PERFORM] Quad processor options - summary Bjoern Metzdorf (21:53)
• Re: [PERFORM] Quad processor options - summary James Thornton (22:50)
• Re: [PERFORM] Quad processor options - summary Hadley Willan (22:59)
• Re: [PERFORM] Quad processor options - summary James Thornton (23:36)

2004-05-14

• Re: [PERFORM] Quad processor options - summary Paul Tuckfield (00:51)
• R: R: Query plan on identical tables differs . Why ? Fabio Panizzutti (08:40)
• R: R: Query plan on identical tables differs . Why ? Fabio Panizzutti (08:55)
• R: R: Query plan on identical tables differs . Why ? Fabio Panizzutti (09:22)
• Re: R: R: Query plan on identical tables differs . Why ? Christopher Kings-Lynne (09:55)
• Re: [PERFORM] Quad processor options - summary Mark Kirkwood (10:17)
• R: R: R: Query plan on identical tables differs . Why ? Fabio Panizzutti (10:30)
• TPCH 100GB - need some help Eduardo Almeida (18:00)
• numeric data types Jaime Casanova (21:08)
• Re: TPCH 100GB - need some help Rod Taylor (21:40)

2004-05-15

• Re: numeric data types Tom Lane (04:03)
• filesystem option tuning share-postgres (10:52)
• Re: TPCH 100GB - need some help Tom Lane (16:00)

2004-05-16

• Re: numeric data types Neil Conway (02:27)

2004-05-17

• Re: filesystem option tuning Richard Huxton (17:04)
• Hardware Platform Duane Lee - EGOVX (23:08)

2004-05-18

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

2004-05-19

• Re: Using LIKE expression problem.. Joseph Shraibman (02:51)
• Re: Quad processor options Marty Scholes (03:38)
• Re: filesystem option tuning share-postgres (07:32)
• DB Design Michael Ryan S. Puncia (07:37)
• Re: DB Design Andrew McMillan (11:21)
• shared buffer size on linux Joseph Shraibman (19:26)
• PostgreSQL performance in simple queries Eugeny Balakhonov (20:07)
• Re: PostgreSQL performance in simple queries Gary Doades (20:23)
• Re: PostgreSQL performance in simple queries Neil Conway (21:51)

2004-05-20

• Re: Wierd context-switching issue on Xeon Bruce Momjian (01:20)
• Re: Wierd context-switching issue on Xeon Robert Creager (01:59)
• Re: Wierd context-switching issue on Xeon Tom Lane (02:41)
• Re: Wierd context-switching issue on Xeon Tom Lane (02:42)
• Re: Wierd context-switching issue on Xeon Robert Creager (02:59)
• Re: Wierd context-switching issue on Xeon Bruce Momjian (03:02)
• Re: Wierd context-switching issue on Xeon Tom Lane (03:58)
• Re: Wierd context-switching issue on Xeon Tom Lane (04:02)
• Re: Wierd context-switching issue on Xeon Bruce Momjian (04:11)
• Re: Wierd context-switching issue on Xeon Bruce Momjian (04:11)
• Re: Wierd context-switching issue on Xeon Christopher Browne (04:48)
• Re: PostgreSQL performance in simple queries Joseph Shraibman (04:49)
• Re: Wierd context-switching issue on Xeon Matthew T. O'Connor (05:10)
• Re: DB Design Mark Kirkwood (09:28)
• Re: Hardware Platform Marty Scholes (13:46)
• Re: PostgreSQL performance in simple queries Tom Lane (15:33)
• Re: PostgreSQL performance in simple queries Bruce Momjian (15:56)
• Re: Interpreting vmstat Thom Dyson (16:00)
• Re: PostgreSQL performance in simple queries Joseph Shraibman (16:52)
• Re: Wierd context-switching issue on Xeon Josh Berkus (21:52)
• Re: Wierd context-switching issue on Xeon Tom Lane (22:14)

2004-05-21

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

2004-05-22

• Re: tuning for AIX 5L with large memory Christopher Browne (01:28)
• Re: tuning for AIX 5L with large memory Neil Conway (02:31)
• Re: PostgreSQL caching Vitaly Belman (22:22)

2004-05-23

• Re: tuning for AIX 5L with large memory Dan Harris (03:30)

2004-05-24

• index's relpages after table analyzed Litao Wu (16:51)
• Re: index's relpages after table analyzed Litao Wu (17:20)

Prev | Next