pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Join optimisation Quandry
  2004-01-14 23:10 UTC  Ceri Storey <cez@necrofish.org.uk>
` Re: Join optimisation Quandry
  2004-01-16 18:17 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Join optimisation Quandry
  2004-01-17 01:03 UTC  Ceri Storey <cez@necrofish.org.uk>
` Re: Join optimisation Quandry
  2004-01-17 06:05 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Join optimisation Quandry
  2004-01-17 10:40 UTC  Ceri Storey <cez@necrofish.org.uk>
` Re: Join optimisation Quandry
  2004-01-17 11:58 UTC  Ceri Storey <cez-misc.pgsql-perf@necrofish.org.uk>
` Re: Join optimisation Quandry
  2004-01-19 02:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [7+ messages in thread]

Idle postmaster taking up a lot of CPU
  2004-01-17 15:34 UTC  John Siracusa <siracusa@mindspring.com>
` Re: Idle postmaster taking up a lot of CPU
  2004-01-17 17:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Idle postmaster taking up a lot of CPU
  2004-01-17 21:33 UTC  John Siracusa <siracusa@mindspring.com>
  [3+ messages in thread]

Potential Problem with PostgeSQL performance on SuSE Linux 9.0
  2004-01-16 20:37 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [PERFORM] Potential Problem with PostgeSQL performance on SuSE
  2004-01-16 22:11 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Potential Problem with PostgeSQL performance on SuSE
  2004-01-17 01:13 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Potential Problem with PostgeSQL performance on SuSE
  2004-01-17 01:51 UTC  Mark Kirkwood <markir@paradise.net.nz>
  [4+ messages in thread]

Question about space usage:
  2004-01-15 16:37 UTC  Jeremy M. Guthrie <jeremy.guthrie@berbee.com>
` Re: Question about space usage:
  2004-01-16 19:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

subquery and table join, index not use for table
  2004-01-14 13:35 UTC  CoL <col@mportal.hu>
` Re: subquery and table join, index not use for table
  2004-01-16 17:48 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [2+ messages in thread]

shared_buffer value
  2004-01-15 22:49 UTC  Anjan Dave <adave@vantage.com>
` Re: shared_buffer value
  2004-01-16 00:17 UTC  Richard Huxton <dev@archonet.com>
` Re: shared_buffer value
  2004-01-16 00:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: shared_buffer value
  2004-01-16 15:29 UTC  Anjan Dave <adave@vantage.com>
` Re: shared_buffer value
  2004-01-16 17:20 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [5+ messages in thread]

100 simultaneous connections, critical limit?
  2004-01-14 12:42 UTC  Jón Ragnarsson <jonr@vortex.is>
` 100 simultaneous connections, critical limit?
  2004-01-14 12:48 UTC  Jón Ragnarsson <jonr@physicallink.com>
` Re: 100 simultaneous connections, critical limit?
  2004-01-14 13:01 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: 100 simultaneous connections, critical limit?
  2004-01-14 13:27 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: 100 simultaneous connections, critical limit?
  2004-01-14 13:44 UTC  Jón Ragnarsson <jonr@physicallink.com>
` Re: 100 simultaneous connections, critical limit?
  2004-01-14 14:00 UTC  Nick Barr <nick.barr@webbased.co.uk>
` Re: 100 simultaneous connections, critical limit?
  2004-01-14 15:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 100 simultaneous connections, critical limit?
  2004-01-14 17:09 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: 100 simultaneous connections, critical limit?
  2004-01-14 18:10 UTC  Adam Alkins <postgresql@rasadam.com>
` Re: 100 simultaneous connections, critical limit?
  2004-01-14 18:36 UTC  Evil Azrael <evilazrael@evilazrael.de>
` Re: 100 simultaneous connections, critical limit?
  2004-01-14 21:35 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: 100 simultaneous connections, critical limit?
  2004-01-15 01:28 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: 100 simultaneous connections, critical limit?
  2004-01-15 02:57 UTC  Andrew McMillan <andrew@catalyst.net.nz>
` Re: 100 simultaneous connections, critical limit?
  2004-01-16 06:24 UTC  Thomas Swan <tswan@idigx.com>
  [14+ messages in thread]

IDE/SCSI disk tools to turn off write caching
  2004-01-16 02:29 UTC  Syd <569170@aliencamel.com>

insert speed - Mac OSX vs Redhat
  2004-01-15 13:56 UTC  Syd <569170@aliencamel.com>
` Re: insert speed - Mac OSX vs Redhat
  2004-01-15 14:17 UTC  Matt Clark <matt@ymogen.net>
` Re: insert speed - Mac OSX vs Redhat
  2004-01-15 15:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: insert speed - Mac OSX vs Redhat
  2004-01-15 21:17 UTC  Syd <569170@aliencamel.com>
  [4+ messages in thread]

Weird query speed
  2004-01-15 16:02 UTC  Rigmor Ukuhe <rigmor.ukuhe@finestmedia.com>
` Re: Weird query speed
  2004-01-15 16:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

freebsd 5.2 and max_connections
  2004-01-13 16:04 UTC  David Hill <davidh@wmis.net>
` Re: freebsd 5.2 and max_connections
  2004-01-13 17:13 UTC  Richard Huxton <dev@archonet.com>
  [2+ messages in thread]

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]


[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