pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
random_page_cost = 1?
  2005-06-09 16:37 UTC  Alex Stapleton <alexs@advfn.com>
` Re: random_page_cost = 1?
  2005-06-09 16:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Query plan changes after pg_dump / pg_restore
  2005-06-09 06:02 UTC  jonanews@oismail.com
` Re: Query plan changes after pg_dump / pg_restore
  2005-06-09 07:33 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: Query plan changes after pg_dump / pg_restore
  2005-06-09 08:12 UTC  Jona <jonanews@oismail.com>
` Re: Query plan changes after pg_dump / pg_restore
  2005-06-09 08:25 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Query plan changes after pg_dump / pg_restore
  2005-06-09 08:54 UTC  Jona <jonanews@oismail.com>
` Re: Query plan changes after pg_dump / pg_restore
  2005-06-09 08:54 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Query plan changes after pg_dump / pg_restore
  2005-06-09 09:23 UTC  Jona <jonanews@oismail.com>
` Re: Query plan changes after pg_dump / pg_restore
  2005-06-09 10:48 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: Query plan changes after pg_dump / pg_restore
  2005-06-09 13:42 UTC  Jona <jonanews@oismail.com>
` Re: Query plan changes after pg_dump / pg_restore
  2005-06-09 14:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query plan changes after pg_dump / pg_restore
  2005-06-09 16:15 UTC  Jona <jonanews@oismail.com>
  [11+ messages in thread]

Recommendations for configuring a 200 GB database
  2005-06-08 21:04 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Recommendations for configuring a 200 GB database
  2005-06-09 08:06 UTC  Richard Huxton <dev@archonet.com>
` Re: Recommendations for configuring a 200 GB
  2005-06-09 14:55 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Recommendations for configuring a 200 GB
  2005-06-09 15:01 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [4+ messages in thread]

Re: [Npgsql-general] index out of range
  2005-06-09 13:35 UTC  Josh Close <narshe@gmail.com>

pg_autovacuum settings
  2005-06-09 09:19 UTC  Michael Ryan S. Puncia <mpuncia@census.gov.ph>

How to find the size of a database - reg.
  2005-06-09 04:40 UTC  Shanmugasundaram Doraisamy <shan@ceedees.com>
` Re: How to find the size of a database - reg.
  2005-06-09 05:01 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [2+ messages in thread]

Postgresql on an AMD64 machine
  2005-06-06 17:53 UTC  Mark Rinaudo <mark@bowmansystems.com>
` Re: Postgresql on an AMD64 machine
  2005-06-06 18:32 UTC  Vivek Khera <vivek@khera.org>
` Re: Postgresql on an AMD64 machine
  2005-06-06 20:59 UTC  Mike Rylander <mrylander@gmail.com>
` Re: Postgresql on an AMD64 machine
  2005-06-06 21:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgresql on an AMD64 machine
  2005-06-06 22:28 UTC  Mark Rinaudo <mark@bowmansystems.com>
` Re: Postgresql on an AMD64 machine
  2005-06-06 23:48 UTC  Neil Conway <neilc@samurai.com>
` Re: Postgresql on an AMD64 machine
  2005-06-07 04:28 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgresql on an AMD64 machine
  2005-06-07 19:38 UTC  Donald Courtney <Donald.Courtney@Sun.COM>
` Re: Postgresql on an AMD64 machine
  2005-06-07 19:54 UTC  Tom Arthurs <tarthurs@jobflash.com>
` Re: Postgresql on an AMD64 machine
  2005-06-07 20:19 UTC  Donald Courtney <Donald.Courtney@Sun.COM>
` Re: Postgresql on an AMD64 machine
  2005-06-07 20:27 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Postgresql on an AMD64 machine
  2005-06-07 20:27 UTC  Alvaro Herrera <alvherre@surnet.cl>
` Re: Postgresql on an AMD64 machine
  2005-06-07 20:39 UTC  Tom Arthurs <tarthurs@jobflash.com>
` Re: Postgresql on an AMD64 machine
  2005-06-07 21:04 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Postgresql on an AMD64 machine
  2005-06-07 21:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgresql on an AMD64 machine
  2005-06-08 00:20 UTC  Neil Conway <neilc@samurai.com>
` Re: Postgresql on an AMD64 machine
  2005-06-08 00:44 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Postgresql on an AMD64 machine
  2005-06-08 03:05 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Postgresql on an AMD64 machine
  2005-06-08 03:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgresql on an AMD64 machine
  2005-06-08 06:16 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Postgresql on an AMD64 machine
  2005-06-08 09:51 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Postgresql on an AMD64 machine
  2005-06-08 16:43 UTC  Tom Arthurs <tarthurs@jobflash.com>
` Re: Postgresql on an AMD64 machine
  2005-06-08 16:53 UTC  Bjoern Metzdorf <bm@turtle-entertainment.de>
` Re: Postgresql on an AMD64 machine
  2005-06-08 21:14 UTC  Sam Vilain <sam@vilain.net>
` Re: Postgresql on an AMD64 machine
  2005-06-09 00:19 UTC  Neil Conway <neilc@samurai.com>
  [25+ messages in thread]

full outer performance problem
  2005-05-10 09:03 UTC  Kim Bisgaard <kib+pg@dmi.dk>
` Re: full outer performance problem
  2005-05-10 14:28 UTC  John A Meinel <john@arbash-meinel.com>
` Re: full outer performance problem
  2005-05-10 14:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: full outer performance problem
  2005-05-11 07:05 UTC  Kim Bisgaard <kib@dmi.dk>
` Re: full outer performance problem
  2005-05-11 08:20 UTC  Kim Bisgaard <kib@dmi.dk>
` full outer performance problem
  2005-06-08 09:37 UTC  Kim Bisgaard <kib+pg@dmi.dk>
` Re: full outer performance problem
  2005-06-08 12:17 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: full outer performance problem
  2005-06-08 12:32 UTC  Kim Bisgaard <kib+pg@dmi.dk>
` Re: full outer performance problem
  2005-06-08 14:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: full outer performance problem
  2005-06-08 16:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: full outer performance problem
  2005-06-08 18:46 UTC  Kim Bisgaard <kib+pg@dmi.dk>
` Re: full outer performance problem
  2005-06-08 18:53 UTC  Kim Bisgaard <kib+pg@dmi.dk>
  [12+ messages in thread]

Performance problems, bad estimates and plan
  2005-06-08 15:04 UTC  Allan Wang <allanvv@gmail.com>
` Re: Performance problems, bad estimates and plan
  2005-06-08 17:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance problems, bad estimates and plan
  2005-06-08 17:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance problems, bad estimates and plan
  2005-06-08 17:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance problems, bad estimates and plan
  2005-06-08 18:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

SELECT DISTINCT Performance Issue
  2005-06-03 01:56 UTC  K C Lau <KCLau@attglobal.net>
` Re: SELECT DISTINCT Performance Issue
  2005-06-06 11:45 UTC  PFC <lists@boutiquenumerique.com>
` Re: SELECT DISTINCT Performance Issue
  2005-06-06 14:54 UTC  K C Lau <kclau60@netvigator.com>
` Re: SELECT DISTINCT Performance Issue
  2005-06-08 13:34 UTC  George Essig <george.essig@gmail.com>
` Re: SELECT DISTINCT Performance Issue
  2005-06-08 14:25 UTC  K C Lau <kclau60@netvigator.com>
` Re: SELECT DISTINCT Performance Issue
  2005-06-08 14:51 UTC  George Essig <george.essig@gmail.com>
  [6+ messages in thread]

Filesystem
  2005-06-03 07:06 UTC  Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: Filesystem
  2005-06-03 10:41 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Filesystem
  2005-06-03 13:18 UTC  Alex Turner <armtuk@gmail.com>
` Re: Filesystem
  2005-06-03 13:52 UTC  Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: Filesystem
  2005-06-03 17:18 UTC  J. Andrew Rogers <jrogers@neopolitan.com>
` Re: Filesystem
  2005-06-08 07:36 UTC  Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: Filesystem
  2005-06-08 12:10 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Filesystem
  2005-06-08 12:25 UTC  Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: Filesystem
  2005-06-08 13:49 UTC  Grega Bremec <gregab@p0f.net>
  [9+ messages in thread]

Debian Stable goes from Woody to Sarge!!
  2005-06-07 15:51 UTC  brew@theMode.com
` Re: Debian Stable goes from Woody to Sarge!!
  2005-06-07 16:15 UTC  Peter Eisentraut <peter_e@gmx.net>
  [2+ messages in thread]

Postgresql and Software RAID/LVM
  2005-06-03 18:45 UTC  Steve Poe <spoe@sfnet.cc>
` Re: Postgresql and Software RAID/LVM
  2005-06-03 22:03 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Postgresql and Software RAID/LVM
  2005-06-06 06:48 UTC  Andrew McMillan <andrew@catalyst.net.nz>
` Re: Postgresql and Software RAID/LVM
  2005-06-06 19:13 UTC  Marty Scholes <marty@outputservices.com>
` Re: Postgresql and Software RAID/LVM
  2005-06-07 04:36 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Postgresql and Software RAID/LVM
  2005-06-07 15:30 UTC  Marty Scholes <marty@outputservices.com>
  [6+ messages in thread]

Performance nightmare with dspam (urgent)
  2005-06-01 20:19 UTC  Casey Allen Shobe <cshobe@seattleserver.com>
` Re: Performance nightmare with dspam (urgent)
  2005-06-07 09:43 UTC  Russell Smith <mr-russ@pws.com.au>
  [2+ messages in thread]

Re: Performance nightmare with dspam (urgent) (resolved)
  2005-06-06 14:54 UTC  Casey Allen Shobe <lists@seattleserver.com>
` Re: Performance nightmare with dspam (urgent) (resolved)
  2005-06-06 15:08 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Performance nightmare with dspam (urgent) (resolved)
  2005-06-06 15:11 UTC  PFC <lists@boutiquenumerique.com>
` Re: Performance nightmare with dspam (urgent) (resolved)
  2005-06-06 15:19 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Performance nightmare with dspam (urgent) (resolved)
  2005-06-06 15:52 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Performance nightmare with dspam (urgent) (resolved)
  2005-06-06 16:04 UTC  Casey Allen Shobe <lists@seattleserver.com>
` Re: Performance nightmare with dspam (urgent) (resolved)
  2005-06-06 17:27 UTC  Michael Stone <mstone+postgres@mathom.us>
  [7+ messages in thread]

How to avoid database bloat
  2005-06-01 07:43 UTC  Mindaugas Riauba <mind@bi.lt>
` Re: How to avoid database bloat
  2005-06-01 08:13 UTC  stig erikson <stigerikson_nospam_@yahoo.se>
` Re: How to avoid database bloat
  2005-06-01 14:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to avoid database bloat
  2005-06-02 07:28 UTC  Mindaugas Riauba <mind@bi.lt>
` Re: How to avoid database bloat
  2005-06-02 13:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to avoid database bloat
  2005-06-02 14:24 UTC  Mindaugas Riauba <mind@bi.lt>
` Re: How to avoid database bloat
  2005-06-02 16:10 UTC  Matthew T. O'Connor <matthew@zeut.net>
` Re: How to avoid database bloat
  2005-06-02 16:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to avoid database bloat
  2005-06-03 03:38 UTC  matthew@tocr.com
` Re: How to avoid database bloat
  2005-06-03 08:41 UTC  Mindaugas Riauba <mind@bi.lt>
` Re: How to avoid database bloat
  2005-06-03 16:43 UTC  Matthew T. O'Connor <matthew@zeut.net>
` Re: How to avoid database bloat
  2005-06-06 14:58 UTC  Mindaugas Riauba <mind@bi.lt>
  [12+ messages in thread]

Forcing use of specific index
  2005-06-02 02:05 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Forcing use of specific index
  2005-06-03 23:22 UTC  William Yu <wyu@talisys.com>
` Re: Forcing use of specific index
  2005-06-04 01:52 UTC  Junaili Lie <junaili@gmail.com>
` Re: Forcing use of specific index
  2005-06-04 14:14 UTC  Qingqing Zhou <zhouqq@cs.toronto.edu>
  [4+ messages in thread]

strategies for optimizing read on rather large tables
  2005-06-04 08:17 UTC  hubert lubaczewski <hubert.lubaczewski@eo.pl>
` Re: strategies for optimizing read on rather large tables
  2005-06-04 11:17 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: strategies for optimizing read on rather large tables
  2005-06-04 11:18 UTC  PFC <lists@boutiquenumerique.com>
` Re: strategies for optimizing read on rather large tables
  2005-06-04 11:40 UTC  hubert lubaczewski <hubert.lubaczewski@eo.pl>
` Re: strategies for optimizing read on rather large tables
  2005-06-04 11:41 UTC  hubert lubaczewski <hubert.lubaczewski@eo.pl>
` Re: strategies for optimizing read on rather large tables
  2005-06-04 12:07 UTC  PFC <lists@boutiquenumerique.com>
` Re: strategies for optimizing read on rather large tables
  2005-06-04 12:13 UTC  hubert lubaczewski <hubert.lubaczewski@eo.pl>
  [7+ messages in thread]

Query plan for very large number of joins
  2005-06-02 15:25 UTC  philb@vodafone.ie
` Re: Query plan for very large number of joins
  2005-06-02 16:02 UTC  Richard Huxton <dev@archonet.com>
` Re: Query plan for very large number of joins
  2005-06-02 16:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query plan for very large number of joins
  2005-06-02 20:15 UTC  PFC <lists@boutiquenumerique.com>
` Re: Query plan for very large number of joins
  2005-06-02 22:23 UTC  Sebastian Hennebrueder <usenet@laliluna.de>
` Re: Query plan for very large number of joins
  2005-06-03 12:22 UTC  philb@vodafone.ie
` Re: Query plan for very large number of joins
  2005-06-03 13:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query plan for very large number of joins
  2005-06-03 14:24 UTC  philb@vodafone.ie
` Re: Query plan for very large number of joins
  2005-06-03 17:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query plan for very large number of joins
  2005-06-03 23:23 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Query plan for very large number of joins
  2005-06-04 10:04 UTC  philb@vodafone.ie
  [11+ messages in thread]

Insert slow down on empty database
  2005-06-03 23:13 UTC  Morgan <mkita@verseon.com>
` Re: Insert slow down on empty database
  2005-06-04 01:20 UTC  Christopher Browne <cbbrowne@acm.org>
  [2+ messages in thread]

BUG #1697: Select getting slower on continously updating data
  2005-06-02 11:05 UTC  Bahadur Singh <bahadursingh@yahoo.com>
` Re: BUG #1697: Select getting slower on continously updating data
  2005-06-02 13:02 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: BUG #1697: Select getting slower on continously updating data
  2005-06-03 07:09 UTC  Bahadur Singh <bahadursingh@yahoo.com>
` Re: BUG #1697: Select getting slower on continously updating data
  2005-06-03 14:49 UTC  Bruno Wolff III <bruno@wolff.to>
  [4+ messages in thread]

Query limitations (size, number of UNIONs ...)
  2005-06-03 06:35 UTC  Marc Mamin <m.mamin@gmx.net>
` Re: Query limitations (size, number of UNIONs ...)
  2005-06-03 13:27 UTC  Stephen Frost <sfrost@snowman.net>
  [2+ messages in thread]

SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance tuning)
  2005-06-03 03:45 UTC  Paul McGarry <paul.mcgarry@gmail.com>
` Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance
  2005-06-03 06:11 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance tuning)
  2005-06-03 08:49 UTC  Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance
  2005-06-03 09:10 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: SHMMAX / SHMALL Was (Re: postgresql-8.0.1 performance tuning)
  2005-06-03 09:19 UTC  Martin Fandel <martin.fandel@alphyra-evs.de>
  [5+ messages in thread]

Adaptec/LSI/?? RAID
  2005-06-02 03:42 UTC  Stacy White <harsh@computer.org>
` Re: Adaptec/LSI/?? RAID
  2005-06-02 04:35 UTC  Sven Willenberger <sven@dmv.com>
` Re: Adaptec/LSI/?? RAID
  2005-06-02 05:00 UTC  William Yu <wyu@talisys.com>
` Re: Adaptec/LSI/?? RAID
  2005-06-02 09:15 UTC  Andrew McMillan <andrew@catalyst.net.nz>
` Re: Adaptec/LSI/?? RAID
  2005-06-02 11:50 UTC  Richard Welty <rwelty@averillpark.net>
` Re: Adaptec/LSI/?? RAID
  2005-06-02 17:10 UTC  J. Andrew Rogers <jrogers@neopolitan.com>
` Re: Adaptec/LSI/?? RAID
  2005-06-02 17:42 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Adaptec/LSI/?? RAID
  2005-06-02 17:47 UTC  Vivek Khera <vivek@khera.org>
` Re: Adaptec/LSI/?? RAID
  2005-06-03 07:37 UTC  Cosimo Streppone <cosimo@streppone.it>
  [9+ messages in thread]

Re: Adaptec/LSI/?? RAID (what about JBOD?)
  2005-06-02 21:02 UTC  mudfoot@rawbw.com
` Re: Adaptec/LSI/?? RAID (what about JBOD?)
  2005-06-02 23:19 UTC  Andrew McMillan <andrew@catalyst.net.nz>
` Re: Adaptec/LSI/?? RAID (what about JBOD?)
  2005-06-03 00:30 UTC  mudfoot@rawbw.com
  [3+ messages in thread]


[next (older)]

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox