pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
factoring problem with view in 7.3.3
  2003-07-23 10:21 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: factoring problem with view in 7.3.3
  2003-07-23 14:13 UTC  Richard Huxton <dev@archonet.com>
` Re: factoring problem with view in 7.3.3
  2003-07-23 15:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

Performance hit of foreign key constraints?
  2003-07-23 07:05 UTC  Jean-Christian Imbeault <jc@mega-bucks.co.jp>
` Re: Performance hit of foreign key constraints?
  2003-07-23 09:54 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Performance hit of foreign key constraints?
  2003-07-23 14:49 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Performance hit of foreign key constraints?
  2003-07-23 15:02 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [4+ messages in thread]

One table or many tables for data set
  2003-07-23 00:34 UTC  Castle, Lindsay <lindsay.castle@eds.com>
` Re: One table or many tables for data set
  2003-07-23 00:53 UTC  Rod Taylor <rbt@rbt.ca>
` Re: One table or many tables for data set
  2003-07-23 01:02 UTC  Joe Conway <mail@joeconway.com>
` Re: One table or many tables for data set
  2003-07-23 01:25 UTC  Castle, Lindsay <lindsay.castle@eds.com>
` Re: One table or many tables for data set
  2003-07-23 01:36 UTC  Joe Conway <mail@joeconway.com>
` Re: One table or many tables for data set
  2003-07-23 01:47 UTC  Castle, Lindsay <lindsay.castle@eds.com>
` Re: One table or many tables for data set
  2003-07-23 01:50 UTC  Rod Taylor <rbt@rbt.ca>
` Re: One table or many tables for data set
  2003-07-23 02:10 UTC  Rod Taylor <rbt@rbt.ca>
` Re: One table or many tables for data set
  2003-07-23 02:14 UTC  Castle, Lindsay <lindsay.castle@eds.com>
  [9+ messages in thread]

Dual Xeon + HW RAID question
  2003-07-10 17:43 UTC  alexandre arruda paes :: aldeia digital <alexandre@aldeiadigital.com.br>
` Re: Dual Xeon + HW RAID question
  2003-07-11 10:55 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Dual Xeon + HW RAID question
  2003-07-12 18:25 UTC  Nikolaus Dilger <nikolaus@dilger.cc>
` Re: Dual Xeon + HW RAID question
  2003-07-14 11:19 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Dual Xeon + HW RAID question
  2003-07-21 05:09 UTC  SZUCS Gábor <surrano@mailbox.hu>
` Re: Dual Xeon + HW RAID question
  2003-07-21 18:07 UTC  alexandre paes :: aldeia digital <alexandre@aldeiadigital.com.br>
` Re: Dual Xeon + HW RAID question
  2003-07-21 19:07 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Dual Xeon + HW RAID question
  2003-07-22 07:23 UTC  Mindaugas Riauba <mind@bi.lt>
` Re: Dual Xeon + HW RAID question
  2003-07-22 16:26 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Dual Xeon + HW RAID question
  2003-07-22 17:10 UTC  SZUCS Gábor <surrano@mailbox.hu>
` Re: Dual Xeon + HW RAID question
  2003-07-22 17:35 UTC  Jord Tanner <jord@indygecko.com>
` Re: Dual Xeon + HW RAID question
  2003-07-22 17:38 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Dual Xeon + HW RAID question
  2003-07-22 17:39 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Dual Xeon + HW RAID question
  2003-07-22 17:54 UTC  Jord Tanner <jord@indygecko.com>
` Re: Dual Xeon + HW RAID question
  2003-07-22 18:50 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Dual Xeon + HW RAID question
  2003-07-22 19:18 UTC  Jord Tanner <jord@indygecko.com>
  [16+ messages in thread]

Tunning FreeeBSD and PostgreSQL
  2003-07-14 14:31 UTC  Stephen Howie <showie@centwire.com>
` Re: Tunning FreeeBSD and PostgreSQL
  2003-07-14 16:02 UTC  Richard Huxton <dev@archonet.com>
` Re: Tunning FreeeBSD and PostgreSQL
  2003-07-14 17:23 UTC  Stephen Howie <showie@centwire.com>
` Re: Tunning FreeeBSD and PostgreSQL
  2003-07-14 17:57 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: Tunning FreeeBSD and PostgreSQL
  2003-07-15 16:44 UTC  Vivek Khera <khera@kcilink.com>
` Re: Tunning FreeeBSD and PostgreSQL
  2003-07-15 17:14 UTC  Stephen Howie <showie@centwire.com>
` Re: Tunning FreeeBSD and PostgreSQL
  2003-07-15 18:04 UTC  Vivek Khera <khera@kcilink.com>
` Re: Tunning FreeeBSD and PostgreSQL
  2003-07-21 20:41 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Tunning FreeeBSD and PostgreSQL
  2003-07-22 14:20 UTC  Vivek Khera <khera@kcilink.com>
` Re: Tunning FreeeBSD and PostgreSQL
  2003-07-22 17:29 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Tunning FreeeBSD and PostgreSQL
  2003-07-22 18:18 UTC  Vivek Khera <khera@kcilink.com>
  [11+ messages in thread]

PGAvd
  2003-07-21 20:49 UTC  Josh Berkus <josh@agliodbs.com>
` Re: PGAvd
  2003-07-21 20:54 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: PGAvd
  2003-07-21 22:00 UTC  Christopher Browne <cbbrowne@libertyrms.info>
  [3+ messages in thread]

Commenting postgresql.conf
  2003-07-21 19:51 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Commenting postgresql.conf
  2003-07-21 20:16 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [2+ messages in thread]

Help disk-pages
  2003-07-13 12:18 UTC  lax@interfree.it
` Re: Help disk-pages
  2003-07-21 19:46 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [2+ messages in thread]

Mass file imports
  2003-07-21 18:51 UTC  Greg Spiegelberg <gspiegelberg@cranel.com>

Optimizer differences between 7.2 and 7.3
  2003-07-07 14:17 UTC  Jeff Boes <jboes@nexcerpt.com>
` Re: Optimizer differences between 7.2 and 7.3
  2003-07-07 14:40 UTC  Richard Huxton <dev@archonet.com>
` Re: Optimizer differences between 7.2 and 7.3
  2003-07-21 08:25 UTC  SZUCS Gábor <surrano@mailbox.hu>
` Re: Optimizer differences between 7.2 and 7.3
  2003-07-21 13:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

ugly query slower in 7.3, even slower after vacuum full analyze
  2003-05-22 14:25 UTC  SZŰCS Gábor <surrano@mailbox.hu>
` Re: ugly query slower in 7.3, even slower after vacuum full analyze
  2003-05-22 16:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: ugly query slower in 7.3, even slower after vacuum full analyze
  2003-05-22 16:31 UTC  Josh Berkus <josh@agliodbs.com>
` Re: ugly query slower in 7.3, even slower after vacuum full analyze
  2003-05-22 16:32 UTC  SZŰCS Gábor <surrano@mailbox.hu>
` Re: ugly query slower in 7.3, even slower after vacuum full analyze
  2003-07-21 05:58 UTC  SZŰCS Gábor <surrano@mailbox.hu>
  [5+ messages in thread]

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]


[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