Mailing lists [pgsql-performance]

1 September 2007

• 00:09   Re: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy) Mark Lewis
• 03:10   schemas to limit data access Brennan, Sean \(IMS\)
• 03:10   schemas to limit data access Brennan, Sean \(IMS\)
• 03:12   schemas to limit data access Brennan, Sean \(IMS\)
• 17:28   Slow Query Shawn
• 18:09   Re: Slow Query Tom Lane
• 20:17   Re: Slow Query Shawn
• 23:51   Re: [GENERAL] Performance issue with nested loop Decibel!

2 September 2007

• 00:34   Re: Slow Query Shawn
• 03:00   Re: Slow Query Tom Lane
• 15:49   Re: Slow Query Kevin Grittner

3 September 2007

• 16:14   Re: Slow Query Shawn
• 16:57   Re: Slow Query Shawn
• 18:08   Re: Slow Query Kevin Grittner
• 18:32   Re: Slow Query Kevin Grittner
• 23:52   Re: Slow Query Shawn

4 September 2007

• 00:49   Re: Slow Query Tom Lane
• 01:08   Re: schemas to limit data access Merlin Moncure
• 02:40   Re: Slow Query Kevin Grittner
• 17:27   Vacum Analyze problem 
• 17:33   Re: Vacum Analyze problem Mikko Partio
• 17:47   Re: Vacum Analyze problem 
• 17:49   Re: Vacum Analyze problem Kevin Kempter
• 17:56   Re: Vacum Analyze problem Bill Moran
• 18:40   About autovacuum Jean-David Beyer
• 18:46   Re: Vacum Analyze problem 
• 18:52   Re: Vacum Analyze problem Richard Broersma Jr
• 19:00   join tables vs. denormalization by trigger Walter Mauritz
• 19:01   Re: About autovacuum Bill Moran
• 19:18   Re: join tables vs. denormalization by trigger Mark Lewis
• 22:45   Performance on 8CPU's and 32GB of RAM Carlo Stonebanks
• 22:48   Re: join tables vs. denormalization by trigger Marc Mamin
• 23:03   Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe
• 23:06   Re: Performance on 8CPU's and 32GB of RAM Alvaro Herrera
• 23:15   Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe
• 23:24   Re: Vacum Analyze problem Gregory Stark

5 September 2007

• 08:20   Re: Performance on 8CPU's and 32GB of RAM Hannes Dorbath
• 10:00   optimize query with a maximum(date) extraction JS Ubei
• 11:07   FW: optimize query with a maximum(date) extraction Gregory Williamson
• 11:30   Re: optimize query with a maximum(date) extraction Gregory Stark
• 12:06   Re: optimize query with a maximum(date) extraction Gregory Stark
• 12:43   Re: optimize query with a maximum(date) extraction Peter Childs
• 12:48   Re: optimize query with a maximum(date) extraction Pavel Stehule
• 13:11   Re : optimize query with a maximum(date) extraction JS Ubei
• 13:23   Re: optimize query with a maximum(date) extraction hubert depesz lubaczewski
• 14:14   Re: optimize query with a maximum(date) extraction Gregory Stark
• 14:23   Re: optimize query with a maximum(date) extraction Gregory Stark
• 14:29   Re: optimize query with a maximum(date) extraction Gregory Stark
• 15:05   Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks
• 15:15   Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe
• 15:22   Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks
• 15:23   Re: optimize query with a maximum(date) extraction Tom Lane
• 15:46   Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe
• 15:57   Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks
• 16:03   Re: Performance on 8CPU's and 32GB of RAM Alvaro Herrera
• 16:06   Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe
• 17:16   Re: Performance on 8CPU's and 32GB of RAM Trevor Talbot
• 18:09   Re: Performance on 8CPU's and 32GB of RAM Ron Mayer
• 19:29   Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe
• 19:37   Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe
• 21:08   Re: Performance on 8CPU's and 32GB of RAM Trevor Talbot
• 21:24   Re: Performance on 8CPU's and 32GB of RAM Ansgar -59cobalt- Wiechers
• 21:59   Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe
• 22:15   Re: Performance on 8CPU's and 32GB of RAM Adam Tauno Williams
• 22:49   RESEND:Postgres with Sun Cluster HA/Solaris 10 Subbiah Stalin-XCGF84
• 22:55   utilising multi-cpu/core machines? Thomas Finneid
• 23:02   Re: utilising multi-cpu/core machines? Jonah H. Harris
• 23:19   Re: Performance on 8CPU's and 32GB of RAM Ansgar -59cobalt- Wiechers

6 September 2007

• 00:08   Re: utilising multi-cpu/core machines? Trevor Talbot
• 00:12   Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe
• 02:50   Re: Performance on 8CPU's and 32GB of RAM Joshua D. Drake
• 06:47   Re: Performance on 8CPU's and 32GB of RAM Ansgar -59cobalt- Wiechers
• 06:55   Hardware spec Willo van der Merwe
• 08:43   Re: Hardware spec Richard Huxton
• 09:26   Re: Hardware spec Willo van der Merwe
• 11:16   Re: Hardware spec Jean-David Beyer
• 11:37   Re: Hardware spec Willo van der Merwe
• 12:35   SAN vs Internal Disks Harsh Azad
• 13:47   Re: utilising multi-cpu/core machines? Kevin Grittner
• 14:19   Re: Hardware spec Florian Weimer
• 15:23   Re: Hardware spec Florian Weimer
• 16:17   Re: [ADMIN] ADO -PostgreSQL OLE DB Provider Richard Broersma Jr
• 16:51   Re: SAN vs Internal Disks Scott Marlowe
• 16:58   Re: SAN vs Internal Disks Harsh Azad
• 17:04   Re: SAN vs Internal Disks Harsh Azad
• 17:04   Re: SAN vs Internal Disks Mark Lewis
• 17:12   Re: SAN vs Internal Disks Joshua D. Drake
• 17:39   Re: SAN vs Internal Disks Arjen van der Meijden
• 18:07   Re: SAN vs Internal Disks Scott Marlowe
• 18:16   Re: SAN vs Internal Disks Harsh Azad
• 18:18   Re: Hardware spec] Jean-David Beyer
• 18:29   Re: SAN vs Internal Disks Mark Lewis
• 18:46   Re: SAN vs Internal Disks Scott Marlowe
• 18:48   Re: Hardware spec Willo van der Merwe
• 19:10   Re: SAN vs Internal Disks Joe Uhl
• 19:12   Re: SAN vs Internal Disks Joel Fradkin
• 19:38   Re: SAN vs Internal Disks Arjen van der Meijden
• 19:40   Re: SAN vs Internal Disks Arjen van der Meijden
• 20:24   Reasonable amount of indices Patric
• 20:30   Re: Performance on 8CPU's and 32GB of RAM James Mansion
• 20:40   Re: Performance on 8CPU's and 32GB of RAM James Mansion
• 21:29   Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe
• 22:04   Re: Performance on 8CPU's and 32GB of RAM Alvaro Herrera
• 22:15   Re: Reasonable amount of indices Alvaro Herrera
• 23:05   Re: SAN vs Internal Disks Scott Marlowe
• 23:19   Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks
• 23:19   Re: Reasonable amount of indices Tom Lane

7 September 2007

• 00:06   How planner decides left-anchored LIKE can use index Carlo Stonebanks
• 00:28   Re: How planner decides left-anchored LIKE can use index Tom Lane
• 01:18   Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks
• 02:28   Re: Performance on 8CPU's and 32GB of RAM James Mansion
• 04:26   Re: SAN vs Internal Disks Greg Smith
• 08:15   Re: SAN vs Internal Disks Florian Weimer
• 08:17   Re: Performance on 8CPU's and 32GB of RAM Florian Weimer
• 08:32   postgres memory management issues? Richard Yen
• 08:52   Re: postgres memory management issues? Richard Huxton
• 09:01   Re: postgres memory management issues? Claus Guttesen
• 09:31   Re: postgres memory management issues? Gregory Stark
• 09:38   Re: postgres memory management issues? Florian Weimer
• 09:45   DRBD and Postgres: how to improve the perfomance? Maila Fatticcioni
• 10:05   Re: SAN vs Internal Disks Michael Stone
• 10:13   Re: postgres memory management issues? Michael Stone
• 10:13   Re: DRBD and Postgres: how to improve the perfomance? Heikki Linnakangas
• 10:20   Re: utilising multi-cpu/core machines? Sven Geisler
• 10:37   Re: SAN vs Internal Disks Tobias Brox
• 12:56   Re: DRBD and Postgres: how to improve the perfomance? Merlin Moncure
• 13:16   Re: SAN vs Internal Disks Michael Stone
• 14:56   Re: postgres memory management issues? Tom Lane
• 16:22   Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe
• 17:30   Re: SAN vs Internal Disks Matthew Schumacher
• 17:34   Re: Performance on 8CPU's and 32GB of RAM Harald Armin Massa
• 17:56   Re: SAN vs Internal Disks Bryan Murphy
• 18:19   Re: SAN vs Internal Disks Alan Hodgson
• 18:22   Re: SAN vs Internal Disks Brian Hurt
• 18:22   Re: SAN vs Internal Disks Joshua D. Drake
• 19:06   Re: DRBD and Postgres: how to improve the perfomance? Simon Riggs
• 20:04   Re: SAN vs Internal Disks Greg Smith
• 20:35   Re: SAN vs Internal Disks Vivek Khera
• 21:10   Re: SAN vs Internal Disks david@lang.hm
• 21:16   Re: SAN vs Internal Disks Joshua D. Drake
• 21:54   Re: DRBD and Postgres: how to improve the perfomance? Bernd Helmle

8 September 2007

• 06:26   Re: DRBD and Postgres: how to improve the perfomance? Simon Riggs
• 08:00   Re: optimize query with a maximum(date) extraction Dimitri
• 10:04   Re: DRBD and Postgres: how to improve the perfomance? Gregory Stark
• 16:21   Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake
• 16:34   Re: DRBD and Postgres: how to improve the perfomance? Stefan Kaltenbrunner
• 16:39   Re: DRBD and Postgres: how to improve the perfomance? Tom Lane
• 16:49   Re: DRBD and Postgres: how to improve the perfomance? Gregory Stark
• 16:54   Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake
• 17:02   Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake
• 17:25   Re: DRBD and Postgres: how to improve the perfomance? Stefan Kaltenbrunner
• 17:32   Re: DRBD and Postgres: how to improve the perfomance? Gregory Stark
• 18:22   Re: DRBD and Postgres: how to improve the perfomance? Bernd Helmle
• 21:26   Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake
• 21:31   Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake

10 September 2007

• 01:29   Re: Slow Query Shawn
• 04:06   Re: DRBD and Postgres: how to improve the perfomance? Greg Smith
• 04:54   Re: DRBD and Postgres: how to improve the perfomance? Tom Lane
• 19:25   random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Carlo Stonebanks
• 20:25   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan
• 20:53   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Mark Mielke
• 21:24   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Josh Berkus
• 21:44   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark
• 21:59   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Scott Marlowe
• 22:03   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Jeff Davis
• 22:08   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Mark Mielke
• 22:22   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Mark Mielke
• 22:45   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan
• 22:47   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan

11 September 2007

• 04:17   What to vacuum after deleting lots of tables Craig James
• 04:23   Re: What to vacuum after deleting lots of tables Tom Lane
• 06:34   [Again] Postgres performance problem Ruben Rubio
• 07:29   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark
• 07:31   Re: [Again] Postgres performance problem db@zigo.dhs.org
• 07:35   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan
• 07:49   Re: [Again] Postgres performance problem Ruben Rubio
• 08:18   Barcelona vs Tigerton Mindaugas
• 08:33   Re: Barcelona vs Tigerton Luke Lonergan
• 09:01   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Heikki Linnakangas
• 12:08   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Jean-David Beyer
• 14:48   Re: DRBD and Postgres: how to improve the perfomance? Maila Fatticcioni
• 14:57   Re: DRBD and Postgres: how to improve the perfomance? Steinar H. Gunderson
• 15:12   Re: Barcelona vs Tigerton Greg Smith
• 16:29   More Vacuum questions... Kevin Kempter
• 16:58   500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running El-Lotso
• 17:02   Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running El-Lotso
• 17:30   Re: More Vacuum questions... Heikki Linnakangas
• 18:16   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark
• 18:23   Re: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running Tom Lane
• 18:42   Re: DRBD and Postgres: how to improve the perfomance? Mario Weilguni
• 19:00   efficient pattern queries (using LIKE, ~) Fernan Aguero
• 19:08   Re: efficient pattern queries (using LIKE, ~) Mario Weilguni
• 19:13   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Jean-David Beyer
• 19:52   Re: Barcelona vs Tigerton Guy Rouillier
• 20:00   Re: Barcelona vs Tigerton Joshua D. Drake
• 20:32   Re: Performance on 8CPU's and 32GB of RAM Decibel!
• 20:36   Re: Hardware spec Decibel!
• 20:56   Re: SAN vs Internal Disks Decibel!
• 21:12   Re: DRBD and Postgres: how to improve the perfomance? Decibel!
• 21:16   Re: SAN vs Internal Disks Michael Stone
• 21:20   Re: DRBD and Postgres: how to improve the perfomance? Decibel!
• 21:22   Re: DRBD and Postgres: how to improve the perfomance? Decibel!
• 21:26   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Decibel!
• 21:31   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Decibel!
• 21:50   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Mark Mielke
• 22:52   Re: [Again] Postgres performance problem Decibel!
• 23:00   Re: Barcelona vs Tigerton Decibel!
• 23:02   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark
• 23:04   Re: More Vacuum questions... Decibel!
• 23:07   Re: SAN vs Internal Disks Decibel!
• 23:49   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Decibel!
• 23:51   Re: SAN vs Internal Disks david@lang.hm

12 September 2007

• 00:10   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Greg Smith
• 00:46   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Joshua D. Drake
• 02:16   Re: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running El-Lotso
• 02:28   Re: DRBD and Postgres: how to improve the perfomance? Jean-David Beyer
• 02:49   Re: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running El-Lotso
• 05:44   Re: SAN vs Internal Disks Harsh Azad
• 05:51   Re: SAN vs Internal Disks Tobias Brox
• 07:01   Re: Hardware spec Willo van der Merwe
• 07:17   Re: Hardware spec Claus Guttesen
• 07:43   Re: [Again] Postgres performance problem ruben@rentalia.com
• 08:10   Re: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running El-Lotso
• 13:15   Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running Nis Jørgensen
• 14:41   Re: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running Tom Lane
• 18:01   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Rafael Barrera Oro
• 18:28   Re: [Again] Postgres performance problem Scott Marlowe
• 18:46   Re: [Again] Postgres performance problem Brian Hurt
• 18:56   Re: [Again] Postgres performance problem Mikko Partio
• 19:07   Re: [Again] Postgres performance problem Scott Marlowe
• 19:20   Re: [Again] Postgres performance problem Frank Schoep
• 19:27   Re: [Again] Postgres performance problem Scott Marlowe
• 19:40   Re: [Again] Postgres performance problem Alvaro Herrera
• 19:58   pg_dump blocking create database? Dan Harris
• 20:01   Re: [Again] Postgres performance problem Erik Jones
• 21:46   db performance/design question Matt Chambers
• 21:58   Re: db performance/design question Scott Marlowe

13 September 2007

• 03:22   Re: pg_dump blocking create database? Tom Lane
• 05:58   Re: [Again] Postgres performance problem Greg Smith
• 07:21   Re: [Again] Postgres performance problem El-Lotso
• 12:30   Index usage when bitwise operator is used W.Alphonse HAROUNY
• 13:11   Clustered tables improves perfs ? Patrice Castet
• 13:32   Re: Clustered tables improves perfs ? Alexander Staubo
• 14:15   Long Running Commits - Not Checkpoints Brad Nicholson
• 14:29   Re: [Again] Postgres performance problem Scott Marlowe
• 15:03   Re: Long Running Commits - Not Checkpoints Brad Nicholson
• 15:04   Re: Clustered tables improves perfs ? Chris Browne
• 15:10   Re: Long Running Commits - Not Checkpoints Tom Lane
• 15:31   Re: [Again] Postgres performance problem Gavin M. Roy
• 15:36   Re: Long Running Commits - Not Checkpoints Brad Nicholson
• 16:03   Re: [Again] Postgres performance problem Erik Jones
• 16:12   Re: Long Running Commits - Not Checkpoints Greg Smith
• 16:19   Re: Long Running Commits - Not Checkpoints Brad Nicholson
• 16:40   Re: [Again] Postgres performance problem Scott Marlowe
• 16:52   Re: Long Running Commits - Not Checkpoints Brad Nicholson
• 17:07   Re: Long Running Commits - Not Checkpoints Alvaro Herrera
• 17:47   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark
• 17:58   Re: Long Running Commits - Not Checkpoints Brad Nicholson
• 18:27   Re: SAN vs Internal Disks Michael Stone
• 18:42   Re: Long Running Commits - Not Checkpoints Greg Smith

14 September 2007

• 02:50   Index files Harsh Azad
• 02:58   Re: Index files Ow Mun Heng
• 03:03   Re: Index files Harsh Azad
• 03:11   Re: Index files Ow Mun Heng
• 03:33   Re: Index files Tom Lane
• 04:23   Re: When/if to Reindex Bruce Momjian
• 05:53   Re: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running El-Lotso
• 06:31   Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running Ow Mun Heng
• 07:02   Re: Long Running Commits - Not Checkpoints Peter Childs
• 07:19   Re: [Again] Postgres performance problem Greg Smith
• 07:43   Re: Long Running Commits - Not Checkpoints Peter Childs
• 09:05   Re: Index files Philippe Amelant
• 10:21   Regarding COPY command from Postgres 8.2.0 soni de
• 11:31   Re: Long Running Commits - Not Checkpoints db@zigo.dhs.org
• 12:03   Re: Regarding COPY command from Postgres 8.2.0 Ansgar -59cobalt- Wiechers
• 13:22   Re: Index files Jean-David Beyer
• 14:00   Re: [Again] Postgres performance problem Adam Tauno Williams
• 16:22   Re: Long Running Commits - Not Checkpoints Greg Smith
• 20:21   Re: Index files Harsh Azad
• 20:26   Re: Index files Mark Lewis
• 20:29   Re: Index files Alan Hodgson

16 September 2007

• 10:08   Re: Index usage when bitwise operator is used Valentine Gogichashvili
• 20:01   Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Kevin Grittner
• 23:58   Re: Index usage when bitwise operator is used Kevin Grittner

17 September 2007

• 07:47   Re: Index usage when bitwise operator is used valgog
• 07:49   Re: Index usage when bitwise operator is used valgog
• 08:10   DELETE queries slow down Galantucci Giovanni
• 09:20   Re: DELETE queries slow down Heikki Linnakangas
• 10:21   Re: DELETE queries slow down Gregory Stark
• 12:01   Re: [Again] Postgres performance problem Ruben Rubio
• 12:24   Re: [Again] Postgres performance problem Decibel!
• 12:27   Re: Index usage when bitwise operator is used Kevin Grittner
• 12:27   Re: [Again] Postgres performance problem Decibel!
• 13:37   Re: Index usage when bitwise operator is used Tom Lane
• 14:30   Re: Index usage when bitwise operator is used Kevin Grittner
• 14:41   Re: Index usage when bitwise operator is used W.Alphonse HAROUNY
• 15:20   Re: DRBD and Postgres: how to improve the perfomance? Markus Schiltknecht
• 20:22   Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks

18 September 2007

• 00:03   Re: Query works when kludged, but would prefer "best practice" solution Merlin Moncure
• 00:13   Re: Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks
• 00:17   Re: Query works when kludged, but would prefer "best practice" solution Merlin Moncure
• 00:38   Re: Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks
• 03:29   Re: Query works when kludged, but would prefer "best practice" solution Tom Lane
• 04:31   Re: Regarding COPY command from Postgres 8.2.0 soni de
• 06:28   Re: Query works when kludged, but would prefer "best practice" solution Carlo Stonebanks
• 07:17   R: DELETE queries slow down Galantucci Giovanni
• 10:36   Re: Index usage when bitwise operator is used valgog
• 14:08   Re: Query works when kludged, but would prefer "best practice" solution Tom Lane
• 14:53   Re: Regarding COPY command from Postgres 8.2.0 Evan Carroll
• 15:05   Re: Regarding COPY command from Postgres 8.2.0 Scott Marlowe
• 15:11   Re: Query works when kludged, but would prefer "best practice" solution Dave Dutcher
• 16:22   Re: R: DELETE queries slow down Bill Moran
• 19:59   Performance improves only after repeated VACUUM/ANALYZE Carlo Stonebanks
• 20:07   Nested loops row estimates always too high Carlo Stonebanks

19 September 2007

• 09:47   R: R: DELETE queries slow down Galantucci Giovanni
• 11:15   Re: R: R: DELETE queries slow down Bill Moran
• 11:27   Re: R: R: DELETE queries slow down Gregory Williamson
• 16:16   Tablespaces and NFS Carlos Moreno
• 17:45   Low CPU Usage brauagustin-susc@yahoo.com.ar
• 17:53   Re: Low CPU Usage Heikki Linnakangas
• 18:03   Re: Low CPU Usage Mark Lewis
• 19:13   Re: Low CPU Usage brauagustin-susc@yahoo.com.ar
• 19:41   Re: Low CPU Usage Scott Marlowe
• 19:52   Re: Low CPU Usage brauagustin-susc@yahoo.com.ar
• 20:15   Re: Low CPU Usage Scott Marlowe
• 20:48   Re: Tablespaces and NFS Craig James
• 21:54   Re: Tablespaces and NFS Peter Koczan

20 September 2007

• 11:31   Re: Low CPU Usage brauagustin-susc@yahoo.com.ar
• 12:32   Re: Low CPU Usage Jean-David Beyer
• 13:20   Re: Tablespaces and NFS Carlos Moreno
• 15:20   REPOST: Performance improves only after repeated VACUUM/ANALYZE Carlo Stonebanks
• 15:20   REPOST: Nested loops row estimates always too high Carlo Stonebanks
• 17:28   Re: Low CPU Usage brauagustin-susc@yahoo.com.ar
• 18:50   Re: Tablespaces and NFS Peter Koczan
• 19:10   Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211
• 19:24   Re: Tablespaces and NFS Carlos Moreno
• 19:34   Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Carlos Moreno
• 20:32   Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211
• 21:25   Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Scott Marlowe
• 21:26   Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Scott Marlowe
• 21:37   query io stats and finding a slow query Kamen Stanev
• 23:04   Linux mis-reporting memory Decibel!
• 23:12   Re: Linux mis-reporting memory Tom Lane
• 23:25   Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211

21 September 2007

• 00:22   Re: Linux mis-reporting memory Adam Tauno Williams
• 00:52   Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Scott Marlowe
• 03:25   Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211
• 05:58   Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! db@zigo.dhs.org
• 08:03   Re: Linux mis-reporting memory Gregory Stark
• 08:29   Re: Linux mis-reporting memory Csaba Nagy
• 09:49   Re: Linux mis-reporting memory Dimitri Fontaine
• 10:00   Re: Linux mis-reporting memory Gregory Stark
• 10:03   Searching for the cause of a bad plan Csaba Nagy
• 10:08   Re: Linux mis-reporting memory Csaba Nagy
• 10:35   Re: Linux mis-reporting memory Heikki Linnakangas
• 11:01   Re: Searching for the cause of a bad plan Simon Riggs
• 11:03   Re: Linux mis-reporting memory Simon Riggs
• 11:29   Re: Searching for the cause of a bad plan Csaba Nagy
• 11:33   Re: Linux mis-reporting memory Csaba Nagy
• 11:36   Re: Searching for the cause of a bad plan Simon Riggs
• 12:11   Re: Searching for the cause of a bad plan Csaba Nagy
• 13:14   Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! smiley2211
• 13:26   Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Bill Moran
• 13:38   Re: Searching for the cause of a bad plan Simon Riggs
• 13:44   Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Jeff Harris
• 14:08   Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Dave Dutcher
• 14:26   Re: Searching for the cause of a bad plan Csaba Nagy
• 15:38   Query planner unaware of possibly best plan Denes Daniel
• 15:47   Re: Searching for the cause of a bad plan Csaba Nagy
• 16:08   Re: Searching for the cause of a bad plan Tom Lane
• 16:35   Re: query io stats and finding a slow query Kevin Grittner
• 17:20   Re: Searching for the cause of a bad plan Simon Riggs
• 17:30   Re: Low CPU Usage brauagustin-susc@yahoo.com.ar
• 17:40   Re: Searching for the cause of a bad plan Simon Riggs
• 17:51   Re: Query planner unaware of possibly best plan Simon Riggs
• 17:52   Re: Low CPU Usage brauagustin-susc@yahoo.com.ar
• 17:52   Re: Low CPU Usage Kevin Grittner
• 17:53   Re: Searching for the cause of a bad plan Tom Lane
• 18:20   Re: Low CPU Usage brauagustin-susc@yahoo.com.ar
• 18:34   Re: Low CPU Usage Bill Moran
• 18:39   Re: Searching for the cause of a bad plan Simon Riggs
• 19:01   Re: Low CPU Usage brauagustin-susc@yahoo.com.ar
• 19:11   Re: Low CPU Usage Bill Moran
• 19:24   Re: Linux mis-reporting memory Greg Smith
• 19:30   Re: Query planner unaware of possibly best plan Denes Daniel
• 19:34   Re: Low CPU Usage brauagustin-susc@yahoo.com.ar
• 19:56   Re: Query planner unaware of possibly best plan Alvaro Herrera
• 20:05   Re: Query planner unaware of possibly best plan Denes Daniel
• 20:41   Re: Low CPU Usage Luiz K. Matsumura
• 20:55   Re: Low CPU Usage Dave Dutcher
• 20:57   Re: Low CPU Usage Kevin Grittner
• 21:13   Re: Low CPU Usage Craig James
• 21:45   Re: Low CPU Usage brauagustin-susc@yahoo.com.ar
• 23:30   Re: Searching for the cause of a bad plan Tom Lane

22 September 2007

• 00:08   Re: Query planner unaware of possibly best plan Denes Daniel
• 06:07   Re: Query planner unaware of possibly best plan Tom Lane
• 06:29   Re: Low CPU Usage Greg Smith
• 12:33   Re: Query planner unaware of possibly best plan Denes Daniel

23 September 2007

• 16:45   Possible explanations for catastrophic performace deterioration? Carlos Moreno
• 16:56   Re: Possible explanations for catastrophic performace deterioration? Jonah H. Harris
• 17:01   zero value in statistics collector's result Yinan Li
• 17:27   Re: Possible explanations for catastrophic performace deterioration? Tom Lane
• 18:15   Re: Possible explanations for catastrophic performace deterioration? Carlos Moreno
• 18:24   Re: Possible explanations for catastrophic performace deterioration? Alvaro Herrera
• 19:12   Re: Possible explanations for catastrophic performace deterioration? Carlos Moreno
• 19:24   Re: Possible explanations for catastrophic performace deterioration? Jonah H. Harris
• 20:33   Re: Possible explanations for catastrophic performance deterioration? Carlos Moreno
• 20:58   Re: Possible explanations for catastrophic performance deterioration? Alvaro Herrera
• 21:55   Re: Possible explanations for catastrophic performance deterioration? Carlos Moreno
• 22:29   Re: Possible explanations for catastrophic performance deterioration? Jonah H. Harris
• 23:05   Re: Possible explanations for catastrophic performance deterioration? Gregory Stark

24 September 2007

• 06:46   Re: REPOST: Nested loops row estimates always too high Ow Mun Heng
• 06:58   [OT] Re: [Again] Postgres performance problem Ow Mun Heng
• 13:28   Re: Searching for the cause of a bad plan Simon Riggs
• 13:59   Re: Low CPU Usage brauagustin-susc@yahoo.com.ar
• 14:04   Re: Searching for the cause of a bad plan Csaba Nagy
• 14:14   select count(*) performance (vacuum did not help) Gábor Farkas
• 14:16   Re: Low CPU Usage brauagustin-susc@yahoo.com.ar
• 14:23   Re: select count(*) performance (vacuum did not help) Pavan Deolasee
• 14:31   Re: select count(*) performance (vacuum did not help) Heikki Linnakangas
• 15:04   Re: select count(*) performance (vacuum did not help) Gábor Farkas
• 15:09   Re: select count(*) performance (vacuum did not help) Heikki Linnakangas
• 15:14   Re: select count(*) performance (vacuum did not help) Gábor Farkas
• 15:21   TEXT or LONGTEXT? Fabiola Fernández
• 15:29   Re: select count(*) performance (vacuum did not help) Bill Moran
• 15:29   Re: TEXT or LONGTEXT? Alexander Staubo
• 15:34   Re: select count(*) performance (vacuum did not help) Csaba Nagy
• 15:38   Re: select count(*) performance (vacuum did not help) Dave Dutcher
• 16:01   Re: TEXT or LONGTEXT? Niklas Johansson
• 17:56   Re: Searching for the cause of a bad plan Simon Riggs
• 18:21   Re: REPOST: Nested loops row estimates always too high Carlo Stonebanks
• 19:51   Acceptable level of over-estimation? Carlo Stonebanks
• 20:18   Re: Acceptable level of over-estimation? Gregory Stark

25 September 2007

• 00:51   Re: REPOST: Nested loops row estimates always too high Ow Mun Heng
• 04:53   Re: REPOST: Nested loops row estimates always too high Carlo Stonebanks
• 05:16   Re: REPOST: Nested loops row estimates always too high Ow Mun Heng
• 09:31   Re: REPOST: Nested loops row estimates always too high Steinar H. Gunderson
• 11:08   Attempting to disable count triggers on cleanup Dave Cramer
• 11:21   Re: Attempting to disable count triggers on cleanup hubert depesz lubaczewski
• 11:39   Re: Attempting to disable count triggers on cleanup Dave Cramer
• 19:41   Re: query io stats and finding a slow query Kamen Stanev
• 19:59   Re: query io stats and finding a slow query Bryan Murphy

26 September 2007

• 03:50   Re: REPOST: Nested loops row estimates always too high Ow Mun Heng
• 04:03   Re: REPOST: Nested loops row estimates always too high Tom Lane
• 08:22   Re: Effects of cascading references in foreign keys Bruce Momjian
• 14:22   Incorrect row estimates in plan? pgdba
• 14:45   Re: Incorrect row estimates in plan? Tom Lane
• 14:52   Re: Searching for the cause of a bad plan Csaba Nagy
• 15:22   Re: Searching for the cause of a bad plan Tom Lane
• 15:24   Re: Incorrect row estimates in plan? pgdba
• 16:38   Re: Incorrect row estimates in plan? Tom Lane
• 16:56   Re: Incorrect row estimates in plan? pgdba
• 18:00   Difference in query plan when using = or > in where clause Radhika S

27 September 2007

• 06:59   Re: REPOST: Nested loops row estimates always too high Ow Mun Heng
• 11:54   Re: Searching for the cause of a bad plan Csaba Nagy
• 12:40   Re: Difference in query plan when using = or > in where clause Heikki Linnakangas
• 14:40   Re: Searching for the cause of a bad plan Tom Lane
• 15:16   Re: Searching for the cause of a bad plan Csaba Nagy
• 15:26   Re: Searching for the cause of a bad plan Simon Riggs
• 17:44   Tuning for warm standby Kevin Kempter
• 18:22   Re: Searching for the cause of a bad plan Ron Mayer
• 22:04   sequence query performance issues Peter Koczan

28 September 2007

• 08:06   Re: sequence query performance issues Richard Huxton
• 08:12   Re: Searching for the cause of a bad plan Csaba Nagy
• 12:33   Re: Searching for the cause of a bad plan Csaba Nagy
• 13:18   Re: Tuning for warm standby Merlin Moncure
• 14:16   Re: sequence query performance issues Tom Lane
• 14:28   Postgres 7.4.2 hanging when vacuum full is run Radhika S
• 14:43   Re: sequence query performance issues Richard Huxton
• 14:53   Re: Postgres 7.4.2 hanging when vacuum full is run Vivek Khera
• 15:28   Re: Postgres 7.4.2 hanging when vacuum full is run Scott Marlowe
• 17:33   Re: sequence query performance issues Peter Koczan
• 17:53   OOM Errors as a result of table inheritance and a bad plan(?) Arctic Toucan
• 18:12   Non-blocking vacuum full Peter Schuller
• 19:32   Re: Non-blocking vacuum full Heikki Linnakangas
• 20:57   Re: OOM Errors as a result of table inheritance and a bad plan(?) Tom Lane

29 September 2007

• 02:52   Re: Non-blocking vacuum full Ron Mayer
• 08:06   Re: Non-blocking vacuum full Heikki Linnakangas