pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedJoin 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