pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
failures on machines using jfs
  2004-01-07 23:06 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: failures on machines using jfs
  2004-01-08 18:52 UTC  Josh Berkus <josh@agliodbs.com>
` Re: failures on machines using jfs
  2004-01-10 03:28 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: failures on machines using jfs
  2004-01-11 02:08 UTC  Christopher Browne <cbbrowne@libertyrms.info>
` Re: failures on machines using jfs
  2004-01-11 16:21 UTC  Spiegelberg, Greg <gspiegelberg@cranel.com>
` Re: failures on machines using jfs
  2004-01-11 17:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: failures on machines using jfs
  2004-01-12 16:12 UTC  Hannu Krosing <hannu@tm.ee>
` Re: failures on machines using jfs
  2004-01-12 17:03 UTC  Greg Spiegelberg <gspiegelberg@cranel.com>
` Re: failures on machines using jfs
  2004-01-13 12:46 UTC  Hannu Krosing <hannu@tm.ee>
` Re: failures on machines using jfs
  2004-01-13 12:59 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: failures on machines using jfs
  2004-01-13 15:04 UTC  Greg Spiegelberg <gspiegelberg@cranel.com>
  [11+ messages in thread]

Ignore Some Updates
  2004-01-13 03:07 UTC  cnliou <cnliou@so-net.net.tw>
` Re: Ignore Some Updates
  2004-01-13 04:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

annoying query/planner choice
  2004-01-12 03:05 UTC  Andrew Rawnsley <ronz@ravensfield.com>
` Re: annoying query/planner choice
  2004-01-12 03:50 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: annoying query/planner choice
  2004-01-12 03:56 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: annoying query/planner choice
  2004-01-12 04:05 UTC  Andrew Rawnsley <ronz@ravensfield.com>
` Re: annoying query/planner choice
  2004-01-12 05:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: annoying query/planner choice
  2004-01-12 15:02 UTC  Andrew Rawnsley <ronz@ravensfield.com>
  [6+ messages in thread]

Explain not accurate
  2004-01-09 14:12 UTC  Richard van den Berg <richard.vandenberg@trust-factory.com>
` Re: Explain not accurate
  2004-01-11 19:55 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: Explain not accurate
  2004-01-12 00:24 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Explain not accurate
  2004-01-12 02:55 UTC  Greg Stark <gsstark@mit.edu>
  [4+ messages in thread]

Postgresql on Quad CPU machine
  2004-01-11 15:53 UTC  D. Dante Lorenso <dante@lorenso.com>
` Re: Postgresql on Quad CPU machine
  2004-01-11 16:07 UTC  Doug McNaught <doug@mcnaught.org>
  [2+ messages in thread]

Slow query problem
  2004-01-08 05:52 UTC  Bradley Tate <btate@objectmastery.com>
` Re: Slow query problem
  2004-01-09 03:27 UTC  Mike Glover <mpg4@duluoz.net>
` Re: Slow query problem
  2004-01-09 04:23 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Slow query problem
  2004-01-09 05:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query problem
  2004-01-09 07:29 UTC  Dennis Björklund <db@zigo.dhs.org>
` Re: Slow query problem
  2004-01-09 08:54 UTC  Richard Huxton <dev@archonet.com>
` Re: Slow query problem
  2004-01-09 08:57 UTC  Dennis Björklund <db@zigo.dhs.org>
` Re: Slow query problem
  2004-01-09 09:19 UTC  Richard Huxton <dev@archonet.com>
` Re: Slow query problem
  2004-01-09 14:53 UTC  Bradley Tate <btate@objectmastery.com>
` Re: Slow query problem
  2004-01-09 15:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query problem
  2004-01-09 15:38 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [11+ messages in thread]

optimizing Postgres queries
  2004-01-05 11:28 UTC  David Teran <david.teran@cluster9.com>
` Re: optimizing Postgres queries
  2004-01-05 11:35 UTC  Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
` Re: optimizing Postgres queries
  2004-01-05 12:05 UTC  David Teran <david.teran@cluster9.com>
` Re: optimizing Postgres queries
  2004-01-05 12:10 UTC  Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
` Re: optimizing Postgres queries
  2004-01-05 12:18 UTC  David Teran <david.teran@cluster9.com>
` Re: optimizing Postgres queries
  2004-01-05 12:37 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: optimizing Postgres queries
  2004-01-05 15:15 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: optimizing Postgres queries
  2004-01-05 15:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizing Postgres queries
  2004-01-05 18:47 UTC  David Teran <david.teran@cluster9.com>
` Re: optimizing Postgres queries
  2004-01-05 18:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizing Postgres queries
  2004-01-05 19:02 UTC  David Teran <david.teran@cluster9.com>
` Re: optimizing Postgres queries
  2004-01-05 19:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizing Postgres queries
  2004-01-05 19:20 UTC  David Teran <david.teran@cluster9.com>
` Re: optimizing Postgres queries
  2004-01-05 19:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizing Postgres queries
  2004-01-05 19:57 UTC  David Teran <david.teran@cluster9.com>
` Re: optimizing Postgres queries
  2004-01-06 05:25 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: optimizing Postgres queries
  2004-01-09 03:16 UTC  Rod Taylor <pg@rbt.ca>
  [17+ messages in thread]

Index creation
  2004-01-07 17:08 UTC  Eric Jain <Eric.Jain@isb-sib.ch>
` Re: Index creation
  2004-01-07 17:20 UTC  Jeff <threshar@torgo.978.org>
` Re: Index creation
  2004-01-07 19:51 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [3+ messages in thread]

RAID array stripe sizes
  2004-01-07 19:45 UTC  Greg Stark <gsstark@mit.edu>

Find original number of rows before applied LIMIT/OFFSET?
  2004-01-07 16:57 UTC  D. Dante Lorenso <dante@lorenso.com>
` Re: [PERFORM] Find original number of rows before applied LIMIT/OFFSET?
  2004-01-07 19:41 UTC  Greg Stark <gsstark@mit.edu>
  [2+ messages in thread]

Select max(foo) and select count(*) optimization
  2004-01-05 19:03 UTC  John Siracusa <siracusa@mindspring.com>
` Re: Select max(foo) and select count(*) optimization
  2004-01-05 19:52 UTC  Rod Taylor <pg@rbt.ca>
` Re: Select max(foo) and select count(*) optimization
  2004-01-05 20:01 UTC  John Siracusa <siracusa@mindspring.com>
` Re: Select max(foo) and select count(*) optimization
  2004-01-05 20:23 UTC  Neil Conway <neilc@samurai.com>
` Re: Select max(foo) and select count(*) optimization
  2004-01-05 20:26 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Select max(foo) and select count(*) optimization
  2004-01-06 00:24 UTC  Paul Tuckfield <paul@tuckfield.com>
` Re: Select max(foo) and select count(*) optimization
  2004-01-06 00:29 UTC  Doug McNaught <doug@mcnaught.org>
` Re: Select max(foo) and select count(*) optimization
  2004-01-06 01:46 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Select max(foo) and select count(*) optimization
  2004-01-06 02:31 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Select max(foo) and select count(*) optimization
  2004-01-06 06:31 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Select max(foo) and select count(*) optimization
  2004-01-06 06:42 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Select max(foo) and select count(*) optimization
  2004-01-06 11:51 UTC  CoL <col@mportal.hu>
` Re: Select max(foo) and select count(*) optimization
  2004-01-06 12:18 UTC  D'Arcy J.M. Cain <darcy@druid.net>
` Re: Select max(foo) and select count(*) optimization
  2004-01-06 12:20 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Select max(foo) and select count(*) optimization
  2004-01-06 16:03 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: Select max(foo) and select count(*) optimization
  2004-01-06 16:31 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Select max(foo) and select count(*) optimization
  2004-01-06 19:28 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Select max(foo) and select count(*) optimization
  2004-01-06 22:57 UTC  D'Arcy J.M. Cain <darcy@druid.net>
` Re: Select max(foo) and select count(*) optimization
  2004-01-06 23:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [19+ messages in thread]

PgAdmin startup query VERY slow
  2004-01-06 20:49 UTC  Michael Shapiro <mshapiro@ncsa.edu>
` Re: PgAdmin startup query VERY slow
  2004-01-06 21:01 UTC  Josh Berkus <josh@agliodbs.com>
` Re: PgAdmin startup query VERY slow
  2004-01-06 21:17 UTC  Josh Berkus <josh@agliodbs.com>
` Re: PgAdmin startup query VERY slow
  2004-01-06 21:31 UTC  Michael Shapiro <mshapiro@ncsa.edu>
` Re: PgAdmin startup query VERY slow
  2004-01-06 23:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

Inefficient SELECT with OFFSET and LIMIT
  2004-01-06 15:40 UTC  Clive Page <cgp@leicester.ac.uk>
` Re: Inefficient SELECT with OFFSET and LIMIT
  2004-01-06 18:12 UTC  Greg Stark <gsstark@mit.edu>
` Re: Inefficient SELECT with OFFSET and LIMIT
  2004-01-06 18:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

deferred foreign keys
  2003-12-29 20:33 UTC  Vivek Khera <khera@kcilink.com>
` Re: deferred foreign keys
  2003-12-31 17:17 UTC  Vivek Khera <khera@kcilink.com>
` Re: deferred foreign keys
  2004-01-02 04:57 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: deferred foreign keys
  2004-01-05 16:33 UTC  Vivek Khera <khera@kcilink.com>
` Re: deferred foreign keys
  2004-01-05 18:38 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: deferred foreign keys
  2004-01-05 18:57 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: deferred foreign keys
  2004-01-05 18:57 UTC  Vivek Khera <khera@kcilink.com>
` Re: deferred foreign keys
  2004-01-05 19:02 UTC  Vivek Khera <khera@kcilink.com>
` Re: deferred foreign keys
  2004-01-05 19:48 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: deferred foreign keys
  2004-01-05 20:14 UTC  Rod Taylor <pg@rbt.ca>
` Re: deferred foreign keys
  2004-01-05 22:33 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [11+ messages in thread]

Use my (date) index, darn it!
  2004-01-04 23:36 UTC  John Siracusa <siracusa@mindspring.com>
` Re: Use my (date) index, darn it!
  2004-01-05 06:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Use my (date) index, darn it!
  2004-01-05 16:19 UTC  John Siracusa <siracusa@mindspring.com>
` Re: Use my (date) index, darn it!
  2004-01-05 16:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Use my (date) index, darn it!
  2004-01-05 16:45 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Use my (date) index, darn it!
  2004-01-05 18:15 UTC  John Siracusa <siracusa@mindspring.com>
` Re: Use my (date) index, darn it!
  2004-01-05 20:27 UTC  Christopher Browne <cbbrowne@acm.org>
  [7+ messages in thread]

Indexing a Boolean or Null column?
  2004-01-04 01:18 UTC  D. Dante Lorenso <dante@lorenso.com>
` Re: Indexing a Boolean or Null column?
  2004-01-04 04:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Indexing a Boolean or Null column?
  2004-01-04 04:32 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Indexing a Boolean or Null column?
  2004-01-04 05:24 UTC  D. Dante Lorenso <dante@lorenso.com>
` Re: Indexing a Boolean or Null column?
  2004-01-04 07:21 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Indexing a Boolean or Null column?
  2004-01-04 07:22 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Indexing a Boolean or Null column?
  2004-01-04 07:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Indexing a Boolean or Null column?
  2004-01-04 21:39 UTC  Christopher Browne <cbbrowne@acm.org>
  [8+ messages in thread]

"fun with multipart primary keys" hobby kit
  2004-01-03 05:37 UTC  Chris Trawick <ctrawick@cultured.net>
` Re: "fun with multipart primary keys" hobby kit
  2004-01-03 05:57 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: "fun with multipart primary keys" hobby kit
  2004-01-03 06:07 UTC  Chris Trawick <ctrawick@cultured.net>
  [3+ messages in thread]

Tuning Techniques To Avoid?
  2004-01-02 12:33 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Tuning Techniques To Avoid?
  2004-01-03 02:18 UTC  Greg Stark <gsstark@mit.edu>
  [2+ messages in thread]

Why memory is not used ? Why vacuum so slow ?
  2004-01-02 09:42 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Why memory is not used ? Why vacuum so slow ?
  2004-01-02 14:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why memory is not used ? Why vacuum so slow ?
  2004-01-02 15:18 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Why memory is not used ? Why vacuum so slow ?
  2004-01-02 15:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

Very slow update + not using clustered index
  2004-01-02 03:34 UTC  Mike Glover <mpg4@duluoz.net>
` Re: Very slow update + not using clustered index
  2004-01-02 04:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very slow update + not using clustered index
  2004-01-02 06:16 UTC  Mike Glover <mpg4@duluoz.net>
` Re: Very slow update + not using clustered index
  2004-01-02 15:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

pg_restore makes disk busy
  2004-01-01 17:14 UTC  cnliou <cnliou@so-net.net.tw>

DELETE ... WHERE ctid IN (...) vs. Iteration
  2003-12-30 16:32 UTC  Jonathan Gardner <jgardner@jonathangardner.net>

Question about difference in performance of 2 queries on large table
  2003-12-29 16:35 UTC  Sean Shanny <shannyconsulting@earthlink.net>
` Re: Question about difference in performance of 2 queries on large table
  2003-12-29 16:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question about difference in performance of 2 queries
  2003-12-29 16:48 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: Question about difference in performance of 2 queries
  2003-12-29 17:44 UTC  Sean Shanny <shannyconsulting@earthlink.net>
` Re: Question about difference in performance of 2 queries
  2003-12-29 18:46 UTC  Sean Shanny <shannyconsulting@earthlink.net>
` Re: Question about difference in performance of 2 queries
  2003-12-29 19:25 UTC  Sean Shanny <shannyconsulting@earthlink.net>
` Re: Question about difference in performance of 2 queries
  2003-12-29 19:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question about difference in performance of 2 queries
  2003-12-29 19:52 UTC  Sean Shanny <shannyconsulting@earthlink.net>
` Re: Question about difference in performance of 2 queries
  2003-12-30 15:00 UTC  Nicholas Shanny <nshanny@tripadvisor.com>
  [9+ messages in thread]

What's faster?
  2003-12-27 00:11 UTC  Keith Bottner <kbottner@comcast.net>
` Re: What's faster?
  2003-12-27 00:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: What's faster?
  2003-12-27 01:06 UTC  Mike Nolan <nolan@gw.tssi.com>
` Re: What's faster?
  2003-12-27 04:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: What's faster?
  2003-12-27 10:52 UTC  D'Arcy J.M. Cain <darcy@druid.net>
` Re: What's faster?
  2003-12-27 18:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

(no subject)
  2003-12-24 16:25 UTC  Michael Rothschild <michael.r@corigin.co.il>
` Re:
  2003-12-25 02:47 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re:
  2003-12-25 16:28 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [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