Mailing lists [pgsql-performance]

1 May 2005

• 23:23   Re: BLOB's bypassing the OS Filesystem for better Image PFC

2 May 2005

• 13:52   batch inserts are "slow" Tim Terlegård
• 15:10   Re: batch inserts are "slow" Christopher Kings-Lynne
• 15:17   Re: batch inserts are "slow" Christopher Petrilli
• 15:20   Re: batch inserts are "slow" Tim Terlegård
• 15:27   Re: batch inserts are "slow" Christopher Petrilli
• 15:30   Re: batch inserts are "slow" Tom Lane
• 15:53   Re: batch inserts are "slow" David Parker
• 16:14   Citation for "Bad n_distinct estimation; hacks suggested?" Gurmeet Manku
• 17:04   Re: batch inserts are "slow" Chris Browne

3 May 2005

• 13:08   Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Markus Schaber
• 14:42   Re: batch inserts are "slow" Markus Schaber
• 15:11   Foreign key constraints compile faster in 7.4 Ashish Arte
• 15:41   Re: batch inserts are "slow" Josh Berkus
• 15:55    Steven Rosenstein
• 15:57   Re: batch inserts are "slow" Kris Jurka
• 16:00   Re: Foreign key constraints compile faster in 7.4 Tom Lane
• 16:12   Re: Tom Lane
• 17:29   Testing list access Jona
• 17:37   Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 2 Jona
• 17:44   Re: batch inserts are "slow" Tim Terlegård
• 17:57   Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1b Jona
• 18:30   Re: batch inserts are "slow" Steve Wampler
• 18:53   Re: COPY vs INSERT Mischa Sandberg
• 19:17   Re: batch inserts are "slow" Christopher Petrilli
• 19:59   Re: batch inserts are "slow" Dave Cramer
• 21:33   Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Mischa Sandberg
• 21:42   Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Josh Berkus

4 May 2005

• 00:45   Re: [HACKERS] Bad n_distinct estimation; hacks suggested? John A Meinel
• 00:51   Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Josh Berkus
• 01:13   Kernel Resources and max_connections Chris Hebrard
• 01:46   Re: Kernel Resources and max_connections Mark Kirkwood
• 02:04   Re: Kernel Resources and max_connections Chris Hebrard
• 02:40   Kernel Resources Solved Chris Hebrard
• 02:52   Re: [HACKERS] Bad n_distinct estimation; hacks suggested? Mischa Sandberg
• 04:07   Re: Kernel Resources and max_connections Jim C. Nasby
• 05:17   Re: Kernel Resources and max_connections Mark Kirkwood
• 11:09   Re: Mike Rylander
• 14:58   Table stats Mike G.
• 22:41   Re: COPY vs INSERT David Roussel
• 23:11   Re: COPY vs INSERT Mischa Sandberg
• 23:24   Re: COPY vs INSERT John A Meinel
• 23:29   Re: COPY vs INSERT Christopher Petrilli
• 23:33   Re: COPY vs INSERT Kris Jurka

5 May 2005

• 01:49   Re: COPY vs INSERT Christopher Kings-Lynne
• 02:23   Re: COPY vs INSERT Tom Lane
• 04:41   Re: COPY vs INSERT Mischa Sandberg
• 09:15   Re: COPY vs INSERT Kris Jurka
• 09:48   Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1 Jona
• 16:02   Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 part 1 Tom Lane
• 23:59   Re: Table stats David Roussel

6 May 2005

• 00:53   Re: COPY vs INSERT Keith Worthington
• 06:51   Re: COPY vs INSERT Jim C. Nasby
• 07:25   Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Jona
• 07:30   Re: COPY vs INSERT Dennis Bjorklund
• 07:31   Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Jona
• 08:37   Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Christopher Kings-Lynne
• 09:28   Re: COPY vs INSERT Harald Fuchs
• 11:12   Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Jona
• 12:18   Re: COPY vs INSERT Bruno Wolff III
• 13:52   Re: COPY vs INSERT Tom Lane
• 13:59   Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Tom Lane
• 20:35   Re: [SQL] ORDER BY Optimization Rosser Schwarz
• 20:59   Re: [SQL] ORDER BY Optimization Derek Buttineau|Compu-SOLVE
• 21:39   Whence the Opterons? Mischa Sandberg
• 22:09   Re: Whence the Opterons? Ian Meyer
• 22:30   Re: Whence the Opterons? Steve Poe
• 22:44   Re: Whence the Opterons? Gavin M. Roy

7 May 2005

• 11:56   Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Jona
• 14:57   Re: Whence the Opterons? Andrew Sullivan
• 18:04   Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Tom Lane
• 21:00   Re: Whence the Opterons? Josh Berkus
• 22:56   Re: [SQL] ORDER BY Optimization Tom Lane

8 May 2005

• 11:06   Re: Bad choice of query plan from PG 7.3.6 to PG 7.3.9 Jona
• 12:59   sequence scan on PK Jeroen van Iddekinge
• 13:44   Re: sequence scan on PK John A Meinel
• 15:49   Re: sequence scan on PK Jeroen van Iddekinge
• 16:19   Re: sequence scan on PK Matteo Beccati
• 16:24   Re: sequence scan on PK John A Meinel
• 16:32   Re: sequence scan on PK Jeroen van Iddekinge
• 16:49   Re: sequence scan on PK Tom Lane
• 17:05   Re: sequence scan on PK Matteo Beccati
• 17:12   Re: COPY vs INSERT Jim C. Nasby
• 18:15   Re: sequence scan on PK Jeroen van Iddekinge
• 21:59   Re: Whence the Opterons? Sam Vilain
• 22:33   Re: Whence the Opterons? Mischa Sandberg
• 23:20   Query tuning help Dan Harris

9 May 2005

• 00:48   Re: Query tuning help Josh Berkus
• 00:51   Re: Query tuning help Russell Smith
• 00:58   Re: Query tuning help Tom Lane
• 01:49   Re: Query tuning help Dan Harris
• 02:06   Re: Query tuning help Josh Berkus
• 02:17   Re: Whence the Opterons? Geoffrey
• 02:29   Re: Query tuning help Tom Lane
• 02:31   Re: Query tuning help Dan Harris
• 02:32   Re: Query tuning help Russell Smith
• 02:49   Re: Query tuning help Dan Harris
• 04:14   Re: Query tuning help Klint Gore
• 05:49   Re: sequence scan on PK Grega Bremec
• 11:42   Re: Query tuning help Harald Fuchs
• 13:40   "Hash index" vs. "b-tree index" (PostgreSQL 8.0) Ying Lu
• 14:37   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL 8.0) Neil Conway
• 15:06   Re: Whence the Opterons? Anjan Dave
• 15:18   Re: Whence the Opterons? John A Meinel
• 15:22   Re: Whence the Opterons? John A Meinel
• 15:28   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL 8.0) Christopher Petrilli
• 15:30   Re: Whence the Opterons? Anjan Dave
• 15:35   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Neil Conway
• 15:40   Re: Whence the Opterons? John A Meinel
• 16:34   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Jim C. Nasby
• 16:39   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Neil Conway
• 16:51   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Jim C. Nasby
• 17:10   Re: Whence the Opterons? Jeff Frost
• 17:23   Re: Whence the Opterons? William Yu
• 17:32   Re: Query tuning help Mischa Sandberg
• 18:10   Re: ORDER BY Optimization Derek Buttineau|Compu-SOLVE
• 19:23   PGSQL Capacity bouchia.nazha@free.fr
• 19:41   Re: PGSQL Capacity John A Meinel
• 19:55   Re: PGSQL Capacity Dave Held
• 20:01   Re: Whence the Opterons? Geoffrey
• 20:10   Re: Whence the Opterons? Anjan Dave
• 20:35   Re: PGSQL Capacity Steinar H. Gunderson
• 20:55   Configing 8 gig box. Joel Fradkin
• 22:04   Re: PGSQL Capacity Chris Browne
• 22:39   Re: "Hash index" vs. "b-tree index" (PostgreSQL 8.0) David Roussel

10 May 2005

• 00:14   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Neil Conway
• 02:20   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Bruce Momjian
• 03:04   Re: Whence the Opterons? Andrew Rawnsley
• 04:11   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane
• 04:25   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Neil Conway
• 04:55   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane
• 05:30   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Neil Conway
• 06:12   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Greg Stark
• 09:03   full outer performance problem Kim Bisgaard
• 10:03   Partitioning / Clustering Alex Stapleton
• 13:52   Prefetch Matt Olson
• 13:53   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane
• 14:16   Re: Prefetch Tom Lane
• 14:29   Re: full outer performance problem John A Meinel
• 14:41   Re: Partitioning / Clustering John A Meinel
• 14:47   Re: full outer performance problem Tom Lane
• 15:03   Re: Partitioning / Clustering Adam Haberlach
• 15:05   Re: Prefetch Rod Taylor
• 15:10   Re: Partitioning / Clustering Alex Stapleton
• 15:24   Re: Partitioning / Clustering Alex Stapleton
• 15:32   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Jim C. Nasby
• 15:39   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Jim C. Nasby
• 15:45   Re: Partitioning / Clustering Richard_D_Levine@raytheon.com
• 15:47   Re: Partitioning / Clustering John A Meinel
• 15:50   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane
• 17:26   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Jim C. Nasby
• 17:31   Re: Partitioning / Clustering PFC
• 17:36   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Greg Stark
• 17:46   Re: Partitioning / Clustering Josh Berkus
• 18:07   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane
• 18:12   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Mischa Sandberg
• 18:13   Re: Prefetch Greg Stark
• 18:28   RE: Partitioning / Clustering 
• 18:36   Re: Prefetch Matt Olson
• 18:54   Re: Prefetch Tom Lane
• 19:17   Prefetch - OffTopic Mohan, Ross
• 19:50   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane
• 20:49   Re: Partitioning / Clustering Mischa Sandberg
• 21:04   Re: Prefetch - OffTopic Chris Browne
• 21:29   Re: Prefetch - OffTopic Mohan, Ross
• 21:36   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Mischa Sandberg
• 21:40   Re: PGSQL Capacity Jim C. Nasby
• 21:45   Re: Configing 8 gig box. Jim C. Nasby
• 21:50   Re: Partitioning / Clustering Jim C. Nasby
• 21:55   Re: Partitioning / Clustering Mischa Sandberg
• 22:16   Re: Partitioning / Clustering Jim C. Nasby
• 22:47   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Mark Lewis
• 22:56   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane
• 23:24   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Mischa Sandberg
• 23:56   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Greg Stark

11 May 2005

• 01:23   Re: Partitioning / Clustering Christopher Kings-Lynne
• 01:34   Re: Partitioning / Clustering Mischa Sandberg
• 01:48   Re: Partitioning / Clustering Joshua D. Drake
• 01:58   Re: Partitioning / Clustering Christopher Kings-Lynne
• 02:06   Re: Partitioning / Clustering Mischa Sandberg
• 02:18   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane
• 02:19   Re: Partitioning / Clustering Mischa Sandberg
• 02:49   Re: Partitioning / Clustering Neil Conway
• 03:11   Re: Partitioning / Clustering Joshua D. Drake
• 03:52   Re: Partitioning / Clustering Bruno Wolff III
• 04:10   Re: Configing 8 gig box. Tom Lane
• 04:34   Re: Prefetch Sam Vilain
• 04:39   Re: Partitioning / Clustering Neil Conway
• 04:44   Re: Partitioning / Clustering Josh Berkus
• 04:52   Re: Prefetch Christopher Kings-Lynne
• 07:20   Re: Partitioning / Clustering Simon Riggs
• 07:55   Re: Partitioning / Clustering Neil Conway
• 07:58   Re: Partitioning / Clustering David Roussel
• 08:35   Optimizer wrongly picks Nested Loop Left Join Edin Kadribasic
• 08:40   Re: Partitioning / Clustering Alex Stapleton
• 08:50   Re: Partitioning / Clustering Alex Stapleton
• 09:04   Re: Partitioning / Clustering Alex Stapleton
• 09:12   Re: Partitioning / Clustering Christopher Kings-Lynne
• 12:46   Re: Query tuning help Ulrich Wisser
• 13:28   Re: Partitioning / Clustering Tom Lane
• 13:46   Re: Prefetch Rod Taylor
• 13:57   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Tom Lane
• 13:59   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Greg Stark
• 14:09   Re: Optimizer wrongly picks Nested Loop Left Join John A Meinel
• 14:15   Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Neil Conway
• 14:18   Re: Optimizer wrongly picks Nested Loop Left Join Tom Lane
• 14:23   Re: Prefetch Bricklen Anderson
• 15:04   Re: Optimizer wrongly picks Nested Loop Left Join Tom Lane
• 15:56   Re: Sort and index Manfred Koizar
• 17:12   Re: Partitioning / Clustering Josh Berkus
• 17:23   Bad plan after vacuum analyze Guillaume Smet
• 18:09   Re: Bad plan after vacuum analyze Josh Berkus
• 18:59   Re: Bad plan after vacuum analyze Tom Lane
• 19:07   Re: Prefetch Mischa Sandberg
• 19:32   Re: Bad plan after vacuum analyze Guillaume Smet
• 19:38   Re: Bad plan after vacuum analyze Tom Lane
• 19:57   Re: Bad plan after vacuum analyze Guillaume Smet
• 20:02   Re: Partitioning / Clustering Greg Stark
• 20:26   Re: Partitioning / Clustering Simon Riggs
• 20:32   Re: Bad plan after vacuum analyze Tom Lane
• 21:02   Re: Bad plan after vacuum analyze Guillaume Smet
• 21:15   Re: Sort and index Jim C. Nasby
• 21:21   Federated PG servers -- Was: Re: [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL Mischa Sandberg
• 21:27   Re: Bad plan after vacuum analyze Mischa Sandberg
• 21:28   Re: Partitioning / Clustering Jim C. Nasby
• 22:35   Re: Partitioning / Clustering PFC
• 23:25   Re: Optimizer wrongly picks Nested Loop Left Join Edin Kadribasic
• 23:26   Re: BLOB's bypassing the OS Filesystem for better Image loading speed? Enrico Weigelt

12 May 2005

• 02:26   Re: Intel SRCS16 SATA raid? Bruce Momjian
• 08:48   Re: Partitioning / Clustering Alex Stapleton
• 09:07   AND OR combination: index not being used David Teran
• 10:03   Re: BLOB's bypassing the OS Filesystem for better Image loading speed? PFC
• 10:09   Re: Partitioning / Clustering PFC
• 10:34   tuning Postgres for large data import (using Copy from) Marc Mamin
• 14:08   Re: Partitioning / Clustering Alex Turner
• 14:15   Re: AND OR combination: index not being used Tom Lane
• 14:31   Re: tuning Postgres for large data import (using Copy from) Tom Lane
• 14:53   Re: tuning Postgres for large data import (using Copy from) John A Meinel
• 15:17   Re: Partitioning / Clustering Alex Stapleton
• 16:05   Re: Partitioning / Clustering Alex Turner
• 16:22   Re: Partitioning / Clustering John A Meinel
• 16:27   Re: Partitioning / Clustering PFC
• 17:25   Re: tuning Postgres for large data import (using Copy from) Josh Berkus
• 17:33   Re: Partitioning / Clustering Josh Berkus
• 17:45   Re: Partitioning / Clustering Alex Stapleton
• 18:50   Re: Partitioning / Clustering Josh Berkus
• 18:51   Re: Sort and index Manfred Koizar
• 22:31   Optimize complex join to use where condition before join Sebastian Hennebrueder
• 22:38   Re: AND OR combination: index not being used David Teran

13 May 2005

• 02:13   Re: Optimize complex join to use where condition before Sebastian Hennebrueder
• 02:44   Re: Optimize complex join to use where condition before Sebastian Hennebrueder
• 02:52   Recommendations for set statistics Sebastian Hennebrueder
• 03:36   Re: Recommendations for set statistics John A Meinel
• 04:50   Re: Recommendations for set statistics Christopher Browne
• 05:57   Re: Optimize complex join to use where condition before Greg Stark
• 12:52   PostgreSQL strugling during high load Mindaugas Riauba
• 13:00   Re: PostgreSQL strugling during high load Steinar H. Gunderson
• 13:43   Re: PostgreSQL strugling during high load Tom Lane
• 14:10   Re: PostgreSQL strugling during high load Mindaugas Riauba
• 14:12   Re: PostgreSQL strugling during high load Tom Lane
• 14:45   Re: PostgreSQL strugling during high load Mindaugas Riauba
• 15:23   Re: PostgreSQL strugling during high load Cosimo Streppone
• 15:41   Re: PostgreSQL strugling during high load Mindaugas Riauba
• 16:12   Re: PostgreSQL strugling during high load Steinar H. Gunderson
• 16:22   Re: Recommendations for set statistics Josh Berkus
• 16:42   Re: PostgreSQL strugling during high load Tom Lane
• 17:33   Re: PostgreSQL strugling during high load Mischa Sandberg
• 18:33   Re: Optimize complex join to use where condition before John A Meinel
• 18:35   Re: Bad plan after vacuum analyze Markus Bertheau
• 19:27   ok you all win what is best opteron (I dont want a hosed system again) Joel Fradkin
• 19:56   Re: ok you all win what is best opteron (I dont want a hosed system again) Merlin Moncure
• 21:07   Re: Whence the Opterons? Andrew Sullivan
• 21:22   Re: Whence the Opterons? Magnus Hagander
• 22:05   Re: Optimize complex join to use where condition before Sebastian Hennebrueder
• 22:15   Re: Optimize complex join to use where condition before John Arbash Meinel

14 May 2005

• 00:02   Re: ok you all win what is best opteron (I dont want a David Brown
• 00:17   Postgresql Performance via the LSI MegaRAID 2x Card Steve Poe
• 00:27   Re: Postgresql Performance via the LSI MegaRAID 2x Card Josh Berkus
• 13:00   Re: Partitioning / Clustering PFC
• 13:37   Re: Sort and index Jim C. Nasby
• 18:19   Re: ok you all win what is best opteron (I dont want a hosed system again) Joel Fradkin
• 21:18   Re: ok you all win what is best opteron (I dont want a hosed system again) Josh Berkus
• 22:16   Re: ok you all win what is best opteron (I dont want a hosed system again) Mike Nolan

15 May 2005

• 00:44   Re: ok you all win what is best opteron (I dont want a hosed system William Yu
• 18:28   Prefetch Matt Olson
• 18:30   Swapping and Kernel 2.6 Guillaume Nobiron
• 18:30   Re: full outer performance problem Kim Bisgaard
• 18:30   Re: full outer performance problem Kim Bisgaard
• 19:36   Re: ok you all win what is best opteron (I dont want a hosed system Greg Stark
• 20:40   Re: ok you all win what is best opteron (I dont want a William Yu
• 21:15   Re: Postgresql Performance via the LSI MegaRAID 2x Card William Yu
• 21:56   Re: Swapping and Kernel 2.6 Grega Bremec

16 May 2005

• 00:22   checkpoint segments David Parker
• 02:26   Re: PostgreSQL strugling during high load Matthew T. O'Connor
• 02:45   Re: PostgreSQL strugling during high load Thomas F. O'Connell
• 03:26   Re: checkpoint segments Josh Berkus
• 03:27   Re: Postgresql Performance via the LSI MegaRAID 2x Card Josh Berkus
• 04:34   Re: checkpoint segments Tom Lane
• 04:39   Re: checkpoint segments Alvaro Herrera
• 04:41   Re: checkpoint segments Alvaro Herrera
• 10:05   Re: PostgreSQL strugling during high load Mindaugas Riauba
• 16:19   Re: checkpoint segments Josh Berkus
• 17:41   Re: Prefetch Joel Fradkin

17 May 2005

• 16:54   [pgsql-benchmarks] Error when try installing pgbench ? Andre Nas
• 16:55   Trigger performance problem Manuel Wenger
• 17:47   Re: Trigger performance problem Tom Lane
• 17:55   Re: Trigger performance problem lists@boutiquenumerique.com
• 22:51   Is there any other way to do this? Wei Weng
• 22:57   Re: Is there any other way to do this? Steinar H. Gunderson

18 May 2005

• 00:22   Tuning planner cost estimates Jim C. Nasby
• 02:11   Re: Is there any other way to do this? Christopher Kings-Lynne
• 14:31   where+orderby+limit not (always) using appropriate index? Szűcs Gábor
• 15:07   Re: where+orderby+limit not (always) using appropriate index? PFC
• 15:14   Re: where+orderby+limit not (always) using appropriate index? Tom Lane
• 19:08   Re: [pgsql-benchmarks] Error when try installing pgbench ? Vivek Khera

19 May 2005

• 16:31   Re: Tuning planner cost estimates Josh Berkus
• 16:55   Re: PostgreSQL strugling during high load Donald Courtney
• 17:16   Re: Tuning planner cost estimates Tom Lane
• 17:20   Re: Tuning planner cost estimates Josh Berkus
• 18:12   Re: PostgreSQL strugling during high load Anjan Dave
• 18:30   Re: PostgreSQL strugling during high load Donald Courtney
• 19:43   Re: PostgreSQL strugling during high load Vivek Khera
• 19:56   Re: PostgreSQL strugling during high load Josh Berkus
• 20:11   Re: PostgreSQL strugling during high load Steve Poe
• 20:19   Re: PostgreSQL strugling during high load Anjan Dave
• 21:50   Which is better, correlated subqueries or joins? Jeffrey Tenny
• 21:53   Re: Which is better, correlated subqueries or joins? Joshua D. Drake
• 22:21   Optimizing for writes. Data integrity not critical Steve Bergman
• 22:27   Re: Optimizing for writes. Data integrity not critical Steinar H. Gunderson
• 23:44   Re: Optimizing for writes. Data integrity not critical Tom Lane

20 May 2005

• 01:42   Re: Optimizing for writes. Data integrity not critical Christopher Kings-Lynne
• 19:46   performance on a querry with many group by's any way to speed it up? Joel Fradkin
• 19:57   cant seem to post the explain Joel Fradkin
• 20:20   Re: Tuning planner cost estimates Jim C. Nasby
• 20:47   Re: Tuning planner cost estimates Tom Lane
• 22:21   Re: Tuning planner cost estimates Josh Berkus
• 22:40   Re: Tuning planner cost estimates Jim C. Nasby
• 22:48   Re: Tuning planner cost estimates Jim C. Nasby
• 23:06   Re: Tuning planner cost estimates Tom Lane

21 May 2005

• 15:16   Re: Optimizing for writes. Data integrity not critical Alex Stapleton
• 17:26   Re: Optimizing for writes. Data integrity not critical Alex Stapleton

23 May 2005

• 17:41   Fwd: Index on table when using DESC clause Yves Vindevogel
• 18:04   Re: Fwd: Index on table when using DESC clause Steinar H. Gunderson
• 19:02   Re: Fwd: Index on table when using DESC clause Yves Vindevogel
• 19:47   Re: Fwd: Index on table when using DESC clause Oleg Bartunov
• 20:19   Re: Fwd: Index on table when using DESC clause Andrew Lazarus
• 20:50   Re: Tuning planner cost estimates Simon Riggs
• 20:58   seqential vs random io David Parker
• 21:19   Re: Fwd: Index on table when using DESC clause Yves Vindevogel
• 22:23   Re: seqential vs random io John A Meinel
• 22:31   Re: seqential vs random io Josh Berkus
• 22:35   Re: seqential vs random io Anjan Dave

24 May 2005

• 05:47   Select performance vs. mssql mark durrant
• 06:18   Re: Select performance vs. mssql Christopher Kings-Lynne
• 06:40   Re: Select performance vs. mssql mark durrant
• 06:47   Re: Select performance vs. mssql Neil Conway
• 08:47   Re: Select performance vs. mssql Harald Lau (Sector-X)
• 15:36   Re: Select performance vs. mssql mark durrant
• 17:06   Need help to decide Mysql vs Postgres Amit V Shah
• 17:14   Re: Need help to decide Mysql vs Postgres Joshua D. Drake
• 17:22   Re: Need help to decide Mysql vs Postgres Amit V Shah
• 17:28   Re: Select performance vs. mssql Bruno Wolff III
• 17:30   Re: Need help to decide Mysql vs Postgres Joel Fradkin
• 17:36   Re: Need help to decide Mysql vs Postgres Josh Berkus
• 17:57   Re: Need help to decide Mysql vs Postgres Amit V Shah
• 18:02   Re: Need help to decide Mysql vs Postgres Steinar H. Gunderson
• 18:19   Re: Need help to decide Mysql vs Postgres Josh Berkus
• 19:15   Re: Select performance vs. mssql mark durrant
• 21:18   Re: Need help to decide Mysql vs Postgres PFC
• 21:36   Re: Need help to decide Mysql vs Postgres Joshua D. Drake
• 23:12   Re: Select performance vs. mssql Alex Turner
• 23:33   Re: Select performance vs. mssql Josh Berkus

25 May 2005

• 00:14   Re: Select performance vs. mssql PFC
• 00:20   Re: Select performance vs. mssql Michael Stone
• 00:38   Re: Select performance vs. mssql John A Meinel
• 01:29   Re: Select performance vs. mssql Christopher Kings-Lynne
• 02:07   Can anyone explain this: duplicate dbs. SpaceBallOne
• 02:21   Re: Can anyone explain this: duplicate dbs. Christopher Kings-Lynne
• 02:22   Re: Can anyone explain this: duplicate dbs. Christopher Kings-Lynne
• 02:39   Re: Can anyone explain this: duplicate dbs. John A Meinel
• 02:52   Re: Can anyone explain this: duplicate dbs. SpaceBallOne
• 03:00   Re: Can anyone explain this: duplicate dbs. Christopher Kings-Lynne
• 03:00   Re: Can anyone explain this: duplicate dbs. John A Meinel
• 03:02   Re: Can anyone explain this: duplicate dbs. Tom Lane
• 03:04   Re: Can anyone explain this: duplicate dbs. Tom Lane
• 03:34   Re: Can anyone explain this: duplicate dbs. Bruno Wolff III
• 15:52   Re: Need help to decide Mysql vs Postgres Philip Hallstrom
• 18:07   Re: [PORTS] Which library has these symbols? -- Eureka Mohan, Ross
• 20:12   Inner join on two OR conditions dont use index Jocelyn Turcotte
• 20:19   Re: Inner join on two OR conditions dont use index John A Meinel
• 20:37   test - pls delete and ignore Mohan, Ross
• 21:22   Re: Inner join on two OR conditions dont use index Jocelyn Turcotte
• 21:43   Re: Inner join on two OR conditions dont use index Tom Lane

26 May 2005

• 01:39   Re: [PORTS] Which library has these symbols? -- Eureka Christopher Kings-Lynne
• 15:22   Optimising queries involving unions Sam Mason
• 16:53   Re: Optimising queries involving unions Tom Lane
• 17:42   Re: Optimising queries involving unions Sam Mason
• 17:55   Specific query performance problem help requested - postgresql 7.4 Brad Might
• 18:02   Re: Optimising queries involving unions Tom Lane
• 18:32   Re: Specific query performance problem help requested - postgresql 7.4 Tom Lane
• 18:41   Re: Specific query performance problem help requested - postgresql 7.4 Brad Might
• 20:24   slow queries, possibly disk io Josh Close
• 21:14   Re: slow queries, possibly disk io John Arbash Meinel
• 21:23   Re: slow queries, possibly disk io Dawid Kuroczko

27 May 2005

• 01:28   Re: slow queries, possibly disk io Christopher Kings-Lynne
• 07:40   Re: Optimising queries involving unions Marc Mamin
• 12:52   Re: slow queries, possibly disk io Josh Close
• 13:04   slow queries, possibly disk io Josh Close
• 13:05   Re: slow queries, possibly disk io Josh Close
• 13:43   postgresql-8.0.1 performance tuning Martin Fandel
• 14:29   Re: slow queries, possibly disk io Tom Lane
• 14:54   Re: slow queries, possibly disk io Josh Close
• 15:00   Re: slow queries, possibly disk io Josh Close
• 17:06   OID vs overall system performances on high load databases. Eric Lauzon
• 21:28   Redundant indexes? Jeffrey Tenny

28 May 2005

• 00:09   Re: Redundant indexes? Tom Lane
• 05:08   Re: OID vs overall system performances on high load Andrew McMillan
• 17:47   Re: OID vs overall system performances on high load PFC

29 May 2005

• 13:27   sequential scan performance Michael Engelhart
• 13:47   Re: sequential scan performance Steinar H. Gunderson
• 14:43   Re: sequential scan performance Christopher Kings-Lynne
• 16:33   Re: Select performance vs. mssql Jim C. Nasby
• 19:44   Re: sequential scan performance Oleg Bartunov
• 20:17   OID vs overall system performances on high load Eric Lauzon
• 21:47   Re: OID vs overall system performances on high load Andrew McMillan
• 21:47   Re: OID vs overall system performances on high load Tom Lane

30 May 2005

• 04:03   Re: OID vs overall system performances on high load Neil Conway
• 05:18   Re: slow queries, possibly disk io Rudi Starcevic
• 09:26   timestamp indexing Tobias Brox
• 13:43   Postgresql and xeon. Eric Lauzon
• 13:54   Re: timestamp indexing Michael Fuhr
• 16:01   Index not used on join with inherited tables Sebastian Böck
• 16:19   Re: Postgresql and xeon. Josh Berkus
• 16:21   Re: Index not used on join with inherited tables Josh Berkus
• 16:33   Re: sequential scan performance Michael Engelhart
• 16:36   Re: Index not used on join with inherited tables Sebastian Böck
• 16:53   Re: sequential scan performance Steve Atkins
• 16:54   Re: Postgresql and xeon. Steinar H. Gunderson
• 17:02   Re: Postgresql and xeon. Eric Lauzon
• 17:02   Re: timestamp indexing Tobias Brox
• 17:15   Re: Postgresql and xeon. Tom Lane
• 17:58   Re: timestamp indexing Tom Lane
• 21:52   poor performance involving a small table Colton A Smith
• 21:53   Specific query performance problem help requested - postgresql 7.4 Brad Might
• 21:53   tuning list
• 21:54   Re: Need help to decide Mysql vs Postgres ellis@no.spam ()
• 22:00   Re: poor performance involving a small table Bricklen Anderson
• 22:07   Drop / create indexes and vacuumdb Yves Vindevogel
• 22:42   Re: tuning Mark Kirkwood

31 May 2005

• 01:51   Re: poor performance involving a small table Christopher Kings-Lynne
• 02:06   Re: timestamp indexing Tobias Brox
• 02:20   Re: timestamp indexing Tobias Brox
• 02:31   Re: poor performance involving a small table andrew@pillette.com
• 03:02   Index on a NULL-value Tobias Brox
• 03:18   Re: Index on a NULL-value Bruno Wolff III
• 03:23   Re: Index on a NULL-value Tobias Brox
• 03:34   Re: Index on a NULL-value Tobias Brox
• 03:45   Re: Index on a NULL-value Bruno Wolff III
• 03:47   Re: Index on a NULL-value Tobias Brox
• 04:09   Re: Index on a NULL-value Bruno Wolff III
• 04:18   Re: Index on a NULL-value Tom Lane
• 04:21   Re: Index on a NULL-value Greg Stark
• 05:13   Re: Index on a NULL-value Tom Lane
• 05:59   Re: Index on a NULL-value Tobias Brox
• 09:37   very large table Praveen Raja
• 13:16   SURVEY: who is running postgresql on 8 or more CPUs? Dirk Lutzebäck
• 13:17   Re: slow queries, possibly disk io Josh Close
• 14:06   Re: very large table Tom Lane
• 14:33   Re: slow queries, possibly disk io Tom Lane
• 16:37   Re: slow queries, possibly disk io Josh Close
• 17:02   'Fastest' PC's are slowest in the house Justin Davis
• 18:00   Major flood of mail to lists ... Marc G. Fournier
• 18:49   Re: slow queries, possibly disk io Manfred Koizar
• 19:40   Re: postgresql-8.0.1 performance tuning John A Meinel