pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Poor delete performance AFTER vacuum analyze
  2003-07-19 21:22 UTC  Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
` Re: Poor delete performance AFTER vacuum analyze
  2003-07-20 04:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor delete performance AFTER vacuum analyze
  2003-07-20 05:42 UTC  Dennis Björklund <db@zigo.dhs.org>
` Re: Poor delete performance AFTER vacuum analyze
  2003-07-20 23:51 UTC  Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
` Re: Poor delete performance AFTER vacuum analyze
  2003-07-21 05:09 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

About the default performance
  2003-07-04 16:45 UTC  Kaarel <kaarel@future.ee>
` Re: About the default performance
  2003-07-04 16:56 UTC  Josh Berkus <josh@agliodbs.com>
` Re: About the default performance
  2003-07-07 18:00 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: About the default performance
  2003-07-21 02:49 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [4+ messages in thread]

storing files in Postgres
  2003-07-19 21:21 UTC  Matthew Hixson <hixson@poindextrose.org>

File systems (RE: Sanity check requested)
  2003-07-18 14:31 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: File systems (RE: Sanity check requested)
  2003-07-18 21:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Sanity check requested
  2003-07-14 17:51 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: Sanity check requested
  2003-07-15 05:42 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Sanity check requested
  2003-07-17 15:41 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: Sanity check requested
  2003-07-17 15:57 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Sanity check requested
  2003-07-17 16:11 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: Sanity check requested
  2003-07-17 16:40 UTC  Joe Conway <mail@joeconway.com>
` Re: Sanity check requested
  2003-07-18 06:35 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Sanity check requested
  2003-07-18 07:08 UTC  Ang Chin Han <angch@bytecraft.com.my>
` Re: Sanity check requested
  2003-07-18 15:40 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Sanity check requested
  2003-07-18 16:00 UTC  Vincent van Leeuwen <pgsql.spam@vinz.nl>
` Re: Sanity check requested
  2003-07-18 16:20 UTC  Oliver Scheit <oliver.scheit@REALGARANT.DE>
` Re: Sanity check requested
  2003-07-18 16:28 UTC  Vincent van Leeuwen <pgsql.spam@vinz.nl>
` Re: Sanity check requested
  2003-07-18 16:42 UTC  Oliver Scheit <oliver.scheit@REALGARANT.DE>
` Re: Sanity check requested
  2003-07-18 19:01 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: Sanity check requested
  2003-07-18 19:07 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Sanity check requested
  2003-07-18 19:12 UTC  Rod Taylor <rbt@rbt.ca>
  [16+ messages in thread]

index / sequential scan problem
  2003-07-17 09:01 UTC  Fabian Kreitner <fabian.kreitner@ainea-ag.de>
` Re: index / sequential scan problem
  2003-07-17 09:17 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: index / sequential scan problem
  2003-07-17 10:12 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: index / sequential scan problem
  2003-07-17 11:12 UTC  Fabian Kreitner <fabian.kreitner@ainea-ag.de>
` Re: index / sequential scan problem
  2003-07-17 11:13 UTC  Fabian Kreitner <fabian.kreitner@ainea-ag.de>
` Re: index / sequential scan problem
  2003-07-17 11:18 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: index / sequential scan problem
  2003-07-17 12:34 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: index / sequential scan problem
  2003-07-17 12:50 UTC  Fabian Kreitner <fabian.kreitner@ainea-ag.de>
` Re: index / sequential scan problem
  2003-07-17 12:54 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: index / sequential scan problem
  2003-07-17 14:10 UTC  Jord Tanner <jord@indygecko.com>
` Re: index / sequential scan problem
  2003-07-17 14:38 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: index / sequential scan problem
  2003-07-17 18:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: index / sequential scan problem
  2003-07-17 18:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: index / sequential scan problem
  2003-07-18 04:47 UTC  Fabian Kreitner <fabian.kreitner@ainea-ag.de>
` Re: index / sequential scan problem
  2003-07-18 05:18 UTC  Fabian Kreitner <fabian.kreitner@ainea-ag.de>
` Re: index / sequential scan problem
  2003-07-18 05:25 UTC  Dennis Björklund <db@zigo.dhs.org>
` Re: index / sequential scan problem
  2003-07-18 13:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: index / sequential scan problem
  2003-07-18 14:09 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: index / sequential scan problem
  2003-07-18 18:43 UTC  Dennis Björklund <db@zigo.dhs.org>
  [19+ messages in thread]

Re: Yet another slow join query.. [ SOLVED ]
  2003-07-18 17:41 UTC  mallah@trade-india.com

Yet another slow join query..
  2003-07-18 12:51 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: Yet another slow join query..
  2003-07-18 16:09 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [2+ messages in thread]

Clearing rows periodically
  2003-07-18 06:55 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: Clearing rows periodically
  2003-07-18 07:42 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: Clearing rows periodically
  2003-07-18 11:34 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Clearing rows periodically
  2003-07-18 13:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

Hardware performance
  2003-07-17 02:57 UTC  Balazs Wellisch <balazs@neusolutions.com>
` Re: Hardware performance
  2003-07-17 04:25 UTC  Roman Fail <rfail@posportal.com>
` Re: Hardware performance
  2003-07-17 04:52 UTC  Joe Conway <mail@joeconway.com>
` Re: Hardware performance
  2003-07-17 07:56 UTC  Hannu Krosing <hannu@tm.ee>
` Re: Hardware performance
  2003-07-17 10:14 UTC  Vincent van Leeuwen <pgsql.spam@vinz.nl>
` Re: Hardware performance
  2003-07-17 14:57 UTC  Joe Conway <mail@joeconway.com>
` Re: Hardware performance
  2003-07-17 15:04 UTC  Adam Witney <awitney@sghms.ac.uk>
` Re: Hardware performance
  2003-07-17 15:09 UTC  Joe Conway <mail@joeconway.com>
` Re: Hardware performance
  2003-07-17 15:20 UTC  Adam Witney <awitney@sghms.ac.uk>
` Re: Hardware performance
  2003-07-17 16:13 UTC  Jean-Luc Lachance <jllachan@nsd.ca>
` Re: Hardware performance
  2003-07-17 16:21 UTC  Joe Conway <mail@joeconway.com>
` Re: Hardware performance
  2003-07-17 16:29 UTC  Joe Conway <mail@joeconway.com>
` Re: Hardware performance
  2003-07-17 16:44 UTC  Jean-Luc Lachance <jllachan@nsd.ca>
` Re: Hardware performance
  2003-07-17 16:54 UTC  Jord Tanner <jord@indygecko.com>
` Re: Hardware performance
  2003-07-17 18:41 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Hardware performance
  2003-07-17 18:55 UTC  Magnus Hagander <mha@sollentuna.net>
` Re: Hardware performance
  2003-07-18 03:23 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: Hardware performance
  2003-07-18 10:14 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: Hardware performance
  2003-07-18 10:18 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: Hardware performance
  2003-07-18 13:25 UTC  Magnus Hagander <mha@sollentuna.net>
  [20+ messages in thread]

Table clustering -- useful, or not?
  2003-07-17 19:10 UTC  Josh Berkus <josh@agliodbs.com>

Relation of indices to ANALYZE
  2003-07-17 14:45 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: Relation of indices to ANALYZE
  2003-07-17 16:14 UTC  Richard Huxton <dev@archonet.com>
` Re: Relation of indices to ANALYZE
  2003-07-17 18:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Relation of indices to ANALYZE
  2003-07-17 18:51 UTC  Bill Moran <wmoran@potentialtech.com>
  [4+ messages in thread]

Bad performance using ODBC
  2003-07-16 14:15 UTC  Albert Cervera Areny <albertca@jazzfree.com>
` Re: [PERFORM] Bad performance using ODBC
  2003-07-16 14:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Bad performance using ODBC
  2003-07-17 16:14 UTC  Albert Cervera Areny <albertca@jazzfree.com>
  [3+ messages in thread]

Query Optimisation
  2003-07-15 15:59 UTC  psql-mail@freeuk.com
` Re: [GENERAL] Query Optimisation
  2003-07-15 16:09 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Query Optimisation
  2003-07-15 16:21 UTC  Jonathan Bartlett <johnnyb@eskimo.com>
` Re: Query Optimisation
  2003-07-15 16:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

optimizer picks smaller table to drive nested loops?
  2003-07-07 18:22 UTC  Greg Stark <gsstark@mit.edu>
` Re: optimizer picks smaller table to drive nested loops?
  2003-07-07 20:58 UTC  Randy Neumann <Randy_Neumann@centralref.com>
` Re: optimizer picks smaller table to drive nested loops?
  2003-07-14 18:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizer picks smaller table to drive nested loops?
  2003-07-14 18:40 UTC  Greg Stark <gsstark@mit.edu>
` Re: optimizer picks smaller table to drive nested loops?
  2003-07-14 20:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizer picks smaller table to drive nested loops?
  2003-07-14 22:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

Java Out-of-memory errors on attempts to read tables with  millions of rows
  2003-07-14 16:53 UTC  Rich Cullingford <rculling@sysd.com>
` Re: Java Out-of-memory errors on attempts to read tables with millions of rows
  2003-07-14 17:07 UTC  Evil Azrael <evilazrael@evilazrael.de>
  [2+ messages in thread]

Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 06:35 UTC  Balazs Wellisch <balazs@neusolutions.com>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 10:21 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 17:30 UTC  Joe Conway <mail@joeconway.com>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 19:30 UTC  Balazs Wellisch <balazs@neusolutions.com>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 19:42 UTC  Balazs Wellisch <balazs@neusolutions.com>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 19:51 UTC  Balazs Wellisch <balazs@neusolutions.com>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 20:04 UTC  Balazs Wellisch <balazs@neusolutions.com>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 20:25 UTC  Joe Conway <mail@joeconway.com>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 22:32 UTC  Jim C. Nasby <jim@nasby.net>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-14 06:37 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-14 11:44 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-14 11:45 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-14 14:06 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
  [13+ messages in thread]

Replacing a simple nested query?
  2003-07-13 21:50 UTC  Steve Wampler <swampler@noao.edu>
` Re: Replacing a simple nested query?
  2003-07-13 22:01 UTC  Joe Conway <mail@joeconway.com>
` Re: [SQL] Replacing a simple nested query?
  2003-07-14 13:38 UTC  Steve Wampler <swampler@noao.edu>
  [3+ messages in thread]

How to configure the postgresql.conf files
  2003-07-14 03:26 UTC  Chris_Wu <Chris.Wu@Sanmina-SCI.Com>
` Re: How to configure the postgresql.conf files
  2003-07-14 03:35 UTC  Rudi Starcevic <rudi@oasis.net.au>
` Re: How to configure the postgresql.conf files
  2003-07-14 03:46 UTC  Rudi Starcevic <rudi@oasis.net.au>
  [3+ messages in thread]

Improving a simple query?
  2003-07-13 18:05 UTC  Steve Wampler <swampler@noao.edu>
` Re: Improving a simple query?
  2003-07-13 19:09 UTC  Richard Huxton <dev@archonet.com>
` Re: Improving a simple query?
  2003-07-13 19:54 UTC  nolan@celery.tssi.com
` Re: Improving a simple query?
  2003-07-13 20:46 UTC  Steve Wampler <swampler@noao.edu>
` Re: Improving a simple query?
  2003-07-13 23:58 UTC  Hannu Krosing <hannu@tm.ee>
` Re: Improving a simple query?
  2003-07-14 01:23 UTC  nolan@celery.tssi.com
` Re: Improving a simple query?
  2003-07-14 02:31 UTC  Chris Bowlby <chris@pgsql.com>
` Re: Improving a simple query?
  2003-07-14 02:33 UTC  Chris Bowlby <excalibur@hub.org>
  [8+ messages in thread]

[OT] Such incredible h/w (was Re: Dual Xeon + HW RAID question)
  2003-07-12 21:09 UTC  Ron Johnson <ron.l.johnson@cox.net>

force the use of a particular index
  2003-07-10 15:18 UTC  Scott Cain <cain@cshl.org>
` Re: force the use of a particular index
  2003-07-11 10:51 UTC  Rod Taylor <rbt@rbt.ca>
` Re: force the use of a particular index
  2003-07-11 13:17 UTC  Scott Cain <cain@cshl.org>
` Re: force the use of a particular index
  2003-07-11 13:38 UTC  Rod Taylor <rbt@rbt.ca>
` Re: force the use of a particular index
  2003-07-11 15:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: force the use of a particular index
  2003-07-11 15:36 UTC  Scott Cain <cain@cshl.org>
` Re: force the use of a particular index
  2003-07-11 15:38 UTC  Scott Cain <cain@cshl.org>
` Re: force the use of a particular index
  2003-07-11 15:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: force the use of a particular index
  2003-07-11 16:20 UTC  Rod Taylor <rbt@rbt.ca>
` Re: force the use of a particular index
  2003-07-11 17:20 UTC  Scott Cain <cain@cshl.org>
` Re: force the use of a particular index
  2003-07-11 18:14 UTC  Rod Taylor <rbt@rbt.ca>
` Re: force the use of a particular index
  2003-07-11 18:23 UTC  Scott Cain <cain@cshl.org>
  [12+ messages in thread]

pre-Vacuum statistics
  2003-07-10 18:19 UTC  Rich Cullingford <rculling@sysd.com>
` Re: pre-Vacuum statistics
  2003-07-11 10:57 UTC  Rod Taylor <rbt@rbt.ca>
  [2+ messages in thread]

Postgresql General Bits issue
  2003-07-11 10:32 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>

Extreme high load averages
  2003-07-06 04:54 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [PERFORM] Extreme high load averages
  2003-07-06 07:49 UTC  Richard Huxton <dev@archonet.com>
` Re: Extreme high load averages
  2003-07-06 09:44 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Extreme high load averages
  2003-07-06 10:26 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [PERFORM] Extreme high load averages
  2003-07-06 10:31 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: Extreme high load averages
  2003-07-06 10:34 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: [PERFORM] Extreme high load averages
  2003-07-06 15:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Extreme high load averages
  2003-07-06 20:16 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [PERFORM] Extreme high load averages
  2003-07-06 20:28 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [PERFORM] Extreme high load averages
  2003-07-07 04:21 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [PERFORM] Extreme high load averages
  2003-07-07 09:07 UTC  Dennis Björklund <db@zigo.dhs.org>
` Re: Extreme high load averages
  2003-07-07 19:35 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Extreme high load averages
  2003-07-07 23:29 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: Extreme high load averages
  2003-07-08 00:47 UTC  Matthew Nuzum <cobalt@bearfruit.org>
` Re: Extreme high load averages
  2003-07-08 15:26 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: [PERFORM] Extreme high load averages
  2003-07-10 05:37 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [NOVICE] Extreme high load averages
  2003-07-10 06:30 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: [NOVICE] Extreme high load averages
  2003-07-10 06:43 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [NOVICE] Extreme high load averages
  2003-07-10 07:11 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: [PERFORM] Extreme high load averages
  2003-07-10 20:22 UTC  Sean Chittenden <sean@chittenden.org>
` Re: [NOVICE] Extreme high load averages
  2003-07-11 00:23 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [NOVICE] Extreme high load averages
  2003-07-11 06:09 UTC  Martin Foster <martin@ethereal-realms.org>
  [22+ 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