pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How to determine whether to VACUUM or CLUSTER
  2005-06-15 15:34 UTC  Ken Shaw <kshaw@belarc.com>
` How to determine whether to VACUUM or CLUSTER
  2005-06-16 18:04 UTC  ken shaw <kshaw987@yahoo.com>
` Re: How to determine whether to VACUUM or CLUSTER
  2005-06-17 03:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to determine whether to VACUUM or CLUSTER
  2005-06-20 06:53 UTC  Jim C. Nasby <decibel@decibel.org>
  [4+ messages in thread]

Multiple disks: RAID 5 or PG Cluster
  2005-06-17 19:34 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Multiple disks: RAID 5 or PG Cluster
  2005-06-17 20:21 UTC  Vivek Khera <vivek@khera.org>
` Re: Multiple disks: RAID 5 or PG Cluster
  2005-06-17 20:38 UTC  mudfoot@rawbw.com
` Fwd: Multiple disks: RAID 5 or PG Cluster
  2005-06-17 21:30 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Fwd: Multiple disks: RAID 5 or PG Cluster
  2005-06-17 21:31 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Multiple disks: RAID 5 or PG Cluster
  2005-06-18 16:00 UTC  PFC <lists@boutiquenumerique.com>
` Re: Multiple disks: RAID 5 or PG Cluster
  2005-06-18 16:24 UTC  Jacques Caron <jc@directinfos.com>
` Fwd: Multiple disks: RAID 5 or PG Cluster
  2005-06-18 16:42 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Fwd: Multiple disks: RAID 5 or PG Cluster
  2005-06-18 22:57 UTC  Michael Stone <mstone+postgres@mathom.us>
` Re: Multiple disks: RAID 5 or PG Cluster
  2005-06-19 04:58 UTC  Alex Turner <armtuk@gmail.com>
` Re: Fwd: Multiple disks: RAID 5 or PG Cluster
  2005-06-19 05:53 UTC  Greg Stark <gsstark@mit.edu>
  [11+ messages in thread]

could not send data to client:
  2005-06-16 20:53 UTC  Justin Davis <justin.davis@rapidsys.net>
` Re: could not send data to client:
  2005-06-17 12:49 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
  [2+ messages in thread]

How does the transaction buffer work?
  2005-06-16 19:28 UTC  Veikko Mäkinen <veikko.makinen@ecom.fi>
` Re: How does the transaction buffer work?
  2005-06-16 19:36 UTC  John A Meinel <john@arbash-meinel.com>
` Re: How does the transaction buffer work?
  2005-06-16 20:12 UTC  PFC <lists@boutiquenumerique.com>
` Re: How does the transaction buffer work?
  2005-06-16 21:53 UTC  Josh Berkus <josh@agliodbs.com>
` Re: How does the transaction buffer work?
  2005-06-17 04:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How does the transaction buffer work?
  2005-06-17 05:05 UTC  Rod Taylor <pg@rbt.ca>
  [6+ messages in thread]

Re: Index ot being used
  2005-06-10 15:55 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Index ot being used
  2005-06-10 15:57 UTC  Jacques Caron <jc@directinfos.com>
` Index ot being used
  2005-06-10 16:10 UTC  linux@alteeve.com
` Re: Index ot being used
  2005-06-12 14:12 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-12 15:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index ot being used
  2005-06-12 17:37 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-12 22:52 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-13 03:00 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 03:13 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 03:35 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-13 03:42 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-13 03:53 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 04:29 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-13 13:28 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 14:34 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Index ot being used
  2005-06-13 14:51 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Index ot being used
  2005-06-13 15:48 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 16:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index ot being used
  2005-06-13 16:46 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Index ot being used
  2005-06-13 16:49 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 16:53 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 17:50 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-13 17:57 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-13 18:13 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index ot being used
  2005-06-13 19:05 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-13 20:45 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index ot being used
  2005-06-13 20:53 UTC  Greg Stark <gsstark@mit.edu>
` Re: Index ot being used
  2005-06-13 21:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index ot being used
  2005-06-13 21:30 UTC  Madison Kelly <linux@alteeve.com>
` Re: Index ot being used
  2005-06-15 16:52 UTC  Karim Nassar <karim.nassar@acm.org>
` Re: Index ot being used
  2005-06-15 17:33 UTC  Madison Kelly <linux@alteeve.com>
  [31+ messages in thread]

regular expression search
  2005-06-14 16:40 UTC  Pierre A. Fortier <pfortier@uottawa.ca>
` Re: regular expression search
  2005-06-15 01:21 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [2+ messages in thread]

Most effective tuning choices for busy website?
  2005-06-01 19:19 UTC  Mark Stosberg <mark@summersault.com>
` Re: Most effective tuning choices for busy website?
  2005-06-06 02:04 UTC  Neil Conway <neilc@samurai.com>
` Re: Most effective tuning choices for busy website?
  2005-06-14 22:34 UTC  Mark Stosberg <mark@summersault.com>
` Re: Most effective tuning choices for busy website?
  2005-06-14 23:59 UTC  Christopher Weimann <cweimann@k12hq.com>
  [4+ messages in thread]

Re: PGDATA - SOLVED
  2005-06-14 19:34 UTC  operationsengineer1@yahoo.com
` Re: PGDATA - SOLVED
  2005-06-14 20:41 UTC  Mike <1100100@gmail.com>
  [2+ messages in thread]

PGDATA
  2005-06-14 19:18 UTC  operationsengineer1@yahoo.com

need suggestion for server sizing
  2005-06-10 21:12 UTC  Havasvölgyi Ottó <h.otto@freemail.hu>
` Re: need suggestion for server sizing
  2005-06-13 13:25 UTC  János <janos.lobb@yale.edu>
` Re: need suggestion for server sizing
  2005-06-14 16:31 UTC  Havasvölgyi Ottó <h.otto@freemail.hu>
  [3+ messages in thread]

System Requirement
  2005-06-13 19:56 UTC  Saranya Sivakumar <sarlavk@yahoo.com>
` Re: System Requirement
  2005-06-13 20:10 UTC  Madison Kelly <linux@alteeve.com>
` Re: System Requirement
  2005-06-14 08:32 UTC  hubert depesz lubaczewski <depesz@gmail.com>
` Re: System Requirement
  2005-06-14 13:04 UTC  Saranya Sivakumar <sarlavk@yahoo.com>
  [4+ messages in thread]

Updates on large tables are extremely slow
  2005-06-12 17:40 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Updates on large tables are extremely slow
  2005-06-12 17:57 UTC  Jacques Caron <jc@directinfos.com>
` Re: Updates on large tables are extremely slow
  2005-06-13 02:43 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Updates on large tables are extremely slow
  2005-06-13 08:54 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Updates on large tables are extremely slow
  2005-06-13 09:02 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Fwd: Updates on large tables are extremely slow
  2005-06-13 11:51 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Updates on large tables are extremely slow
  2005-06-13 12:17 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Updates on large tables are extremely slow
  2005-06-13 14:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Fwd: Updates on large tables are extremely slow
  2005-06-13 15:49 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Fwd: Updates on large tables are extremely slow
  2005-06-13 16:02 UTC  Richard Huxton <dev@archonet.com>
` Re: Updates on large tables are extremely slow
  2005-06-13 16:45 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Updates on large tables are extremely slow
  2005-06-13 16:53 UTC  Rod Taylor <pg@rbt.ca>
` Re: Updates on large tables are extremely slow
  2005-06-13 17:22 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: Updates on large tables are extremely slow
  2005-06-13 17:36 UTC  Jacques Caron <jc@directinfos.com>
` Re: Updates on large tables are extremely slow
  2005-06-14 01:29 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [15+ messages in thread]

Resource Requirements
  2005-06-13 00:30 UTC  elein <elein@varlena.com>
` Re: Resource Requirements
  2005-06-13 22:06 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

Pseudo-Solved was: (Re: Index ot being used)
  2005-06-13 21:18 UTC  Madison Kelly <linux@alteeve.com>

How to enhance the chance that data is in disk cache
  2005-06-13 13:04 UTC  Jona <jonanews@oismail.com>
` Re: How to enhance the chance that data is in disk cache
  2005-06-13 14:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to enhance the chance that data is in disk cache
  2005-06-13 17:10 UTC  Jona <jonanews@oismail.com>
  [3+ messages in thread]

PostgreSQL using the wrong Index
  2005-06-13 13:02 UTC  Alex Stapleton <alexs@advfn.com>
` Re: PostgreSQL using the wrong Index
  2005-06-13 13:08 UTC  Alex Stapleton <alexs@advfn.com>
` Re: PostgreSQL using the wrong Index
  2005-06-13 14:47 UTC  John A Meinel <john@arbash-meinel.com>
` Re: PostgreSQL using the wrong Index
  2005-06-13 14:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL using the wrong Index
  2005-06-13 15:20 UTC  Alex Stapleton <alexs@advfn.com>
` Re: PostgreSQL using the wrong Index
  2005-06-13 15:47 UTC  Wei Weng <wweng@kencast.com>
  [6+ messages in thread]

Help with rewriting query
  2005-06-08 19:34 UTC  Junaili Lie <junaili@gmail.com>
` Re: Help with rewriting query
  2005-06-08 19:56 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Help with rewriting query
  2005-06-08 20:48 UTC  Jim Johannsen <jjsa@gvtc.com>
` Re: Help with rewriting query
  2005-06-08 22:48 UTC  Junaili Lie <junaili@gmail.com>
` Re: Help with rewriting query
  2005-06-09 02:59 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Help with rewriting query
  2005-06-09 04:01 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Help with rewriting query
  2005-06-10 01:26 UTC  Junaili Lie <junaili@gmail.com>
` Re: Help with rewriting query
  2005-06-10 01:30 UTC  Junaili Lie <junaili@gmail.com>
` Re: Help with rewriting query
  2005-06-10 08:49 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Help with rewriting query
  2005-06-10 12:06 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Help with rewriting query
  2005-06-10 19:49 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Help with rewriting query
  2005-06-11 09:59 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: Help with rewriting query
  2005-06-13 14:21 UTC  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  [13+ messages in thread]

View not using index
  2005-06-13 06:54 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: View not using index
  2005-06-13 07:05 UTC  Russell Smith <mr-russ@pws.com.au>
` Re: View not using index
  2005-06-13 07:18 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: View not using index
  2005-06-13 07:18 UTC  Russell Smith <mr-russ@pws.com.au>
` Re: View not using index
  2005-06-13 07:35 UTC  Yves Vindevogel <yves.vindevogel@implements.be>
` Re: View not using index
  2005-06-13 14:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

faster search
  2005-06-10 17:45 UTC  Clark Slater <list@slatech.com>
` Re: faster search
  2005-06-10 17:51 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: faster search
  2005-06-10 18:00 UTC  John A Meinel <john@arbash-meinel.com>
` Re: faster search
  2005-06-10 18:05 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: faster search
  2005-06-10 20:12 UTC  Steve Atkins <steve@blighty.com>
` Re: faster search
  2005-06-11 00:07 UTC  Clark Slater <list@slatech.com>
` Re: faster search
  2005-06-11 00:14 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: faster search
  2005-06-11 00:20 UTC  Clark Slater <list@slatech.com>
` Re: faster search
  2005-06-11 00:46 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: faster search
  2005-06-11 00:48 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: faster search
  2005-06-11 00:51 UTC  John A Meinel <john@arbash-meinel.com>
` Re: faster search
  2005-06-11 00:52 UTC  Clark Slater <list@slatech.com>
` Re: faster search
  2005-06-11 00:55 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: faster search
  2005-06-11 11:05 UTC  Cosimo Streppone <cosimo@streppone.it>
` Re: faster search
  2005-06-11 16:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [15+ messages in thread]

Whence the Opterons?
  2005-05-06 21:39 UTC  Mischa Sandberg <mischa.sandberg@telus.net>
` Re: Whence the Opterons?
  2005-05-06 22:09 UTC  Ian Meyer <ianmmeyer@gmail.com>
` Re: Whence the Opterons?
  2005-05-06 22:29 UTC  Steve Poe <spoe@sfnet.cc>
` Re: Whence the Opterons?
  2005-05-06 22:44 UTC  Gavin M. Roy <gmr@ehpg.net>
` Re: Whence the Opterons?
  2005-05-07 14:57 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Whence the Opterons?
  2005-05-07 21:00 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Whence the Opterons?
  2005-05-08 21:59 UTC  Sam Vilain <sam@vilain.net>
` Re: Whence the Opterons?
  2005-05-08 22:33 UTC  Mischa Sandberg <mischa.sandberg@telus.net>
` Re: Whence the Opterons?
  2005-05-09 02:17 UTC  Geoffrey <esoteric@3times25.net>
` Re: Whence the Opterons?
  2005-05-09 15:05 UTC  Anjan Dave <adave@vantage.com>
` Re: Whence the Opterons?
  2005-05-09 15:18 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Whence the Opterons?
  2005-05-09 15:22 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Whence the Opterons?
  2005-05-09 15:29 UTC  Anjan Dave <adave@vantage.com>
` Re: Whence the Opterons?
  2005-05-09 15:40 UTC  John A Meinel <john@arbash-meinel.com>
` Re: Whence the Opterons?
  2005-05-09 17:08 UTC  Jeff Frost <jeff@frostconsultingllc.com>
` Re: Whence the Opterons?
  2005-05-09 17:23 UTC  William Yu <wyu@talisys.com>
` Re: Whence the Opterons?
  2005-05-09 20:00 UTC  Geoffrey <esoteric@3times25.net>
` Re: Whence the Opterons?
  2005-05-09 20:10 UTC  Anjan Dave <adave@vantage.com>
` Re: Whence the Opterons?
  2005-05-10 03:03 UTC  Andrew Rawnsley <ronz@ravensfield.com>
` Re: Whence the Opterons?
  2005-05-13 21:07 UTC  Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Whence the Opterons?
  2005-05-13 21:22 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: Whence the Opterons?
  2005-06-10 12:34 UTC  Richard Rowell <richard@bowmansystems.com>
` Re: Whence the Opterons?
  2005-06-10 14:59 UTC  Mohan, Ross <RMohan@arbinet.com>
  [23+ messages in thread]

Importing from pg_dump slow, low Disk IO
  2005-06-08 09:09 UTC  Steve Pollard <stevep@hostworks.com.au>
` Re: Importing from pg_dump slow, low Disk IO
  2005-06-09 03:56 UTC  Steve Pollard <stevep@hostworks.com.au>
` Re: Importing from pg_dump slow, low Disk IO
  2005-06-10 06:03 UTC  Steve Pollard <stevep@hostworks.com.au>
` Re: Importing from pg_dump slow, low Disk IO
  2005-06-10 06:46 UTC  Martin Fandel <martin.fandel@alphyra-evs.de>
` Re: Importing from pg_dump slow, low Disk IO
  2005-06-10 10:14 UTC  Martin Fandel <martin.fandel@alphyra-evs.de>
  [5+ messages in thread]

Cleaning bloated pg_attribute
  2005-06-10 09:05 UTC  Michal Taborsky <michal.taborsky@mall.cz>
` Re: Cleaning bloated pg_attribute
  2005-06-10 10:07 UTC  Richard Huxton <dev@archonet.com>
  [2+ messages in thread]

postgresql.conf runtime statistics default
  2005-06-09 10:08 UTC  Yann Michel <yann-postgresql@spline.de>
` Re: postgresql.conf runtime statistics default
  2005-06-09 13:11 UTC  Richard Huxton <dev@archonet.com>
` Re: postgresql.conf runtime statistics default
  2005-06-10 04:57 UTC  Yann Michel <yann-postgresql@spline.de>
` Re: postgresql.conf runtime statistics default
  2005-06-10 07:17 UTC  Richard Huxton <dev@archonet.com>
  [4+ messages in thread]

Help specifying new web server/database machine
  2005-06-08 16:34 UTC  Rory Campbell-Lange <rory@campbell-lange.net>
` Re: Help specifying new web server/database machine
  2005-06-08 16:41 UTC  Bjoern Metzdorf <bm@turtle-entertainment.de>
` Re: Help specifying new web server/database machine
  2005-06-08 16:48 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Help specifying new web server/database machine
  2005-06-08 18:53 UTC  Matthew Nuzum <mattnuzum@gmail.com>
` Re: Help specifying new web server/database machine
  2005-06-08 23:33 UTC  William Yu <wyu@talisys.com>
` Re: Help specifying new web server/database machine
  2005-06-09 16:44 UTC  Rory Campbell-Lange <rory@campbell-lange.net>
` Re: Help specifying new web server/database machine
  2005-06-09 17:18 UTC  Matthew Nuzum <mattnuzum@gmail.com>
` Re: Help specifying new web server/database machine
  2005-06-09 18:00 UTC  Oliver Elphick <olly@lfix.co.uk>
` Re: Help specifying new web server/database machine
  2005-06-09 19:53 UTC  William Yu <wyu@talisys.com>
` Re: Help specifying new web server/database machine
  2005-06-09 21:01 UTC  Rory Campbell-Lange <rory@campbell-lange.net>
` Re: Help specifying new web server/database machine
  2005-06-09 21:27 UTC  Rory Campbell-Lange <rory@campbell-lange.net>
  [11+ messages in thread]

timestamp indexing
  2005-05-30 09:19 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: timestamp indexing
  2005-05-30 13:54 UTC  Michael Fuhr <mike@fuhr.org>
` Re: timestamp indexing
  2005-05-30 17:08 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: timestamp indexing
  2005-05-30 17:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: timestamp indexing
  2005-05-31 02:06 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: timestamp indexing
  2005-05-31 02:20 UTC  Tobias Brox <tobias@nordicbet.com>
` Re: timestamp indexing
  2005-06-09 18:04 UTC  Jim C. Nasby <decibel@decibel.org>
` Re: timestamp indexing
  2005-06-09 19:43 UTC  Tobias Brox <tobias@nordicbet.com>
  [8+ 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