pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Help with performance problems
  2004-04-23 13:31 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Help with performance problems
  2004-04-23 15:16 UTC  Aaron Werman <awerman2@hotmail.com>
` Re: Help with performance problems
  2004-04-23 16:42 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Help with performance problems
  2004-04-23 17:16 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Help with performance problems
  2004-04-23 17:21 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Help with performance problems
  2004-04-23 17:53 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Help with performance problems
  2004-04-23 18:01 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Help with performance problems
  2004-04-23 18:15 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Help with performance problems
  2004-04-23 18:57 UTC  Ron St-Pierre <rstpierre@syscor.com>
` Re: Help with performance problems
  2004-04-23 19:27 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Help with performance problems
  2004-04-23 19:58 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Help with performance problems
  2004-04-23 21:36 UTC  Ron St-Pierre <rstpierre@syscor.com>
` Re: Help with performance problems
  2004-04-24 02:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help with performance problems
  2004-04-26 17:20 UTC  Chris Hoover <revoohc@sermonaudio.com>
  [14+ messages in thread]

Why will vacuum not end?
  2004-04-20 03:37 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Why will vacuum not end?
  2004-04-20 04:02 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Why will vacuum not end?
  2004-04-20 12:58 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Why will vacuum not end?
  2004-04-20 13:14 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: Why will vacuum not end?
  2004-04-21 01:26 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Why will vacuum not end?
  2004-04-23 18:19 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Why will vacuum not end?
  2004-04-23 18:47 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Why will vacuum not end?
  2004-04-24 14:45 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Why will vacuum not end?
  2004-04-24 15:35 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Why will vacuum not end?
  2004-04-24 17:57 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Why will vacuum not end?
  2004-04-24 19:48 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Why will vacuum not end?
  2004-04-24 19:58 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Why will vacuum not end?
  2004-04-25 00:05 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Why will vacuum not end?
  2004-04-25 00:28 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Why will vacuum not end?
  2004-04-25 01:49 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Why will vacuum not end?
  2004-04-25 13:05 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Why will vacuum not end?
  2004-04-25 20:46 UTC  Manfred Koizar <mkoi-pg@aon.at>
  [17+ messages in thread]

Number of pages in a random sample (was: query slows down with more accurate stats)
  2004-04-25 20:26 UTC  Manfred Koizar <mkoi-pg@aon.at>

Setting Shared Buffers , Effective Cache, Sort Mem Parameters
  2004-04-22 17:51 UTC  Pallav Kalva <pkalva@deg.cc>
` Re: Setting Shared Buffers , Effective Cache, Sort Mem
  2004-04-22 21:16 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Setting Shared Buffers , Effective Cache, Sort Mem Parameters
  2004-04-22 22:50 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Setting Shared Buffers , Effective Cache, Sort Mem Parameters
  2004-04-23 21:44 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Setting Shared Buffers , Effective Cache, Sort Mem
  2004-04-23 22:10 UTC  Ron Mayer <rm_pg@cheapcomplexdevices.com>
` Re: Setting Shared Buffers , Effective Cache, Sort Mem
  2004-04-24 02:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Setting Shared Buffers , Effective Cache, Sort Mem
  2004-04-24 15:37 UTC  Josh Berkus <josh@agliodbs.com>
  [7+ messages in thread]

Looking for ideas on how to speed up warehouse loading
  2004-04-22 21:56 UTC  Sean Shanny <shannyconsulting@earthlink.net>
` Re: Looking for ideas on how to speed up warehouse loading
  2004-04-22 23:05 UTC  CoL <col@mportal.hu>
` Re: Looking for ideas on how to speed up warehouse loading
  2004-04-22 23:30 UTC  Sean Shanny <shannyconsulting@earthlink.net>
` Re: Looking for ideas on how to speed up warehouse loading
  2004-04-23 00:54 UTC  Nicholas Shanny <nshanny@tripadvisor.com>
` Re: Looking for ideas on how to speed up warehouse loading
  2004-04-23 02:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Looking for ideas on how to speed up warehouse loading
  2004-04-23 04:38 UTC  Joe Conway <mail@joeconway.com>
` Re: Looking for ideas on how to speed up warehouse loading
  2004-04-23 12:19 UTC  Aaron Werman <awerman2@hotmail.com>
` Re: Looking for ideas on how to speed up warehouse loading
  2004-04-23 16:25 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [8+ messages in thread]

Re: 225 times slower
  2004-04-20 17:10 UTC  Pailloncy Jean-Gérard <pailloncy@ifrance.com>
` Re: 225 times slower
  2004-04-22 04:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 225 times slower
  2004-04-22 18:46 UTC  Pailloncy Jean-Gérard <pailloncy@ifrance.com>
  [3+ messages in thread]

order by index, and inheritance
  2004-04-19 11:30 UTC  Michiel Meeuwissen <Michiel.Meeuwissen@omroep.nl>
` Re: order by index, and inheritance
  2004-04-22 11:02 UTC  Michiel Meeuwissen <Michiel.Meeuwissen@omroep.nl>
` Re: order by index, and inheritance
  2004-04-22 13:46 UTC  Rod Taylor <pg@rbt.ca>
` Re: order by index, and inheritance
  2004-04-22 14:40 UTC  Michiel Meeuwissen <Michiel.Meeuwissen@omroep.nl>
` Re: order by index, and inheritance
  2004-04-22 14:46 UTC  Rod Taylor <pg@rbt.ca>
  [5+ messages in thread]

Moving postgres to FC disks
  2004-04-20 20:20 UTC  Anjan Dave <adave@vantage.com>
` Re: Moving postgres to FC disks
  2004-04-21 00:27 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Moving postgres to FC disks
  2004-04-21 02:14 UTC  Aaron Werman <awerman2@hotmail.com>
` Re: Moving postgres to FC disks
  2004-04-21 21:50 UTC  Cott Lang <cott@internetstaff.com>
  [4+ messages in thread]

Help understanding stat tables
  2004-04-21 15:34 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Help understanding stat tables
  2004-04-21 16:24 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Help understanding stat tables
  2004-04-21 19:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

slow seqscan
  2004-04-21 07:17 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: slow seqscan
  2004-04-21 07:47 UTC  Nick Barr <nicky@chuckie.co.uk>
` Re: slow seqscan
  2004-04-21 07:52 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: slow seqscan
  2004-04-21 08:34 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: slow seqscan
  2004-04-21 08:53 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: slow seqscan
  2004-04-21 09:41 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: slow seqscan
  2004-04-21 10:10 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: slow seqscan
  2004-04-21 10:15 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: slow seqscan
  2004-04-21 11:50 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: slow seqscan
  2004-04-21 14:31 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: slow seqscan
  2004-04-21 16:23 UTC  Edoardo Ceccarelli <eddy@axa.it>
` Re: slow seqscan
  2004-04-21 18:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [12+ messages in thread]

pgbench written in Pro*C
  2004-04-20 15:48 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: pgbench written in Pro*C
  2004-04-21 02:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pgbench written in Pro*C
  2004-04-21 03:31 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [3+ messages in thread]

Use of subquery causes seq scan???
  2004-04-20 14:20 UTC  Chris Hoover <revoohc@sermonaudio.com>
` Re: Use of subquery causes seq scan???
  2004-04-20 17:56 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Use of subquery causes seq scan???
  2004-04-20 21:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

seeking consultant for high performance, complex searching with Postgres web app
  2004-04-19 20:42 UTC  Mark Stosberg <mark@summersault.com>
` Re: seeking consultant for high performance, complex searching
  2004-04-20 16:18 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
  [2+ messages in thread]

Persistent Connections
  2004-01-24 17:32 UTC  postgres@countup.de
` Re: Persistent Connections
  2004-01-25 11:28 UTC  Nick Barr <nicky@chuckie.co.uk>
` Re: Persistent Connections
  2004-01-26 06:35 UTC  Randolf Richardson <rr@8x.ca>
` Re: Persistent Connections
  2004-04-20 15:49 UTC  Thomas Swan <tswan@idigx.com>
  [4+ messages in thread]

Toooo many context switches (maybe SLES8?)
  2004-04-15 12:10 UTC  Dirk Lutzebäck <lutzeb@aeccom.com>
` Re: Toooo many context switches (maybe SLES8?)
  2004-04-15 16:01 UTC  Joe Conway <mail@joeconway.com>
` Re: Toooo many context switches (maybe SLES8?)
  2004-04-15 16:29 UTC  Dirk Lutzebäck <lutzeb@aeccom.com>
` Re: Toooo many context switches (maybe SLES8?)
  2004-04-15 16:38 UTC  Joe Conway <mail@joeconway.com>
` Re: Toooo many context switches (maybe SLES8?)
  2004-04-15 17:40 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Toooo many context switches (maybe SLES8?)
  2004-04-15 19:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Toooo many context switches (maybe SLES8?)
  2004-04-15 20:03 UTC  Dirk Lutzebaeck <Dirk.Lutzebaeck@t-online.de>
` Re: Toooo many context switches (maybe SLES8?)
  2004-04-15 20:37 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Toooo many context switches (maybe SLES8?)
  2004-04-18 18:49 UTC  Dave Cramer <pg@fastcrypt.com>
` Re: Toooo many context switches (maybe SLES8?)
  2004-04-20 14:50 UTC  Dave Cramer <pg@fastcrypt.com>
  [10+ messages in thread]

Deleting certain duplicates
  2004-04-12 14:39 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Deleting certain duplicates
  2004-04-12 15:18 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Deleting certain duplicates
  2004-04-13 14:27 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: Deleting certain duplicates
  2004-04-16 17:52 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: Deleting certain duplicates
  2004-04-20 11:15 UTC  Greg Sabino Mullane <greg@turnstep.com>
  [5+ messages in thread]

possible improvement between G4 and G5
  2004-04-06 00:53 UTC  Qing Zhao <qzhao@quotefx.net>
` Re: possible improvement between G4 and G5
  2004-04-06 05:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: possible improvement between G4 and G5
  2004-04-06 15:45 UTC  Aaron Werman <awerman2@hotmail.com>
` Re: possible improvement between G4 and G5
  2004-04-06 15:52 UTC  Jim C. Nasby <jim@nasby.net>
` Re: possible improvement between G4 and G5
  2004-04-06 18:52 UTC  Josh Berkus <josh@agliodbs.com>
` Re: possible improvement between G4 and G5
  2004-04-06 20:22 UTC  Aaron Werman <awerman2@hotmail.com>
` Re: possible improvement between G4 and G5
  2004-04-06 21:41 UTC  Josh Berkus <josh@agliodbs.com>
` Re: possible improvement between G4 and G5
  2004-04-19 17:39 UTC  Vivek Khera <khera@kcilink.com>
` Re: possible improvement between G4 and G5
  2004-04-19 20:41 UTC  Aaron Werman <awerman@hotmail.com>
  [9+ messages in thread]

sunquery and estimated rows
  2004-04-16 21:45 UTC  Litao Wu <litaowu@yahoo.com>
` Re: sunquery and estimated rows
  2004-04-16 23:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: sunquery and estimated rows
  2004-04-18 19:22 UTC  Markus Bertheau <twanger@bluetwanger.de>
` Re: sunquery and estimated rows
  2004-04-18 23:09 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: sunquery and estimated rows
  2004-04-18 23:42 UTC  Rod Taylor <rbt@rbt.ca>
` Re: sunquery and estimated rows
  2004-04-19 02:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: sunquery and estimated rows
  2004-04-19 16:26 UTC  Litao Wu <litaowu@yahoo.com>
  [7+ messages in thread]

query slows down with more accurate stats
  2004-04-13 18:02 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: query slows down with more accurate stats
  2004-04-13 19:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query slows down with more accurate stats
  2004-04-15 23:32 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: query slows down with more accurate stats
  2004-04-16 00:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query slows down with more accurate stats
  2004-04-16 10:16 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: query slows down with more accurate stats
  2004-04-16 14:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: query slows down with more accurate stats
  2004-04-16 15:37 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: query slows down with more accurate stats
  2004-04-16 22:26 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: query slows down with more accurate stats
  2004-04-19 16:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [9+ messages in thread]

very slow simple query - outer join makes it quicker
  2004-04-19 10:59 UTC  Gerard Isdell <gerard.isdell@kinetic.co.uk>
` Re: very slow simple query - outer join makes it quicker
  2004-04-19 12:01 UTC  Rod Taylor <pg@rbt.ca>
` Re: very slow simple query - outer join makes it quicker
  2004-04-19 12:36 UTC  Rod Taylor <pg@rbt.ca>
  [3+ messages in thread]

RESOLVED: Re: Wierd context-switching issue on Xeon
  2004-04-16 13:03 UTC  Dirk Lutzebäck <lutzeb@aeccom.com>
` Re: RESOLVED: Re: Wierd context-switching issue on Xeon
  2004-04-16 13:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: RESOLVED: Re: Wierd context-switching issue on Xeon
  2004-04-16 16:58 UTC  Josh Berkus <josh@agliodbs.com>
` Re: RESOLVED: Re: Wierd context-switching issue on Xeon
  2004-04-19 07:27 UTC  Dirk Lutzebäck <lutzeb@aeccom.com>
  [4+ messages in thread]

Poor performance of group by query
  2004-04-16 15:17 UTC  Jim C. Nasby <jim@nasby.net>
` Re: Poor performance of group by query
  2004-04-16 16:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor performance of group by query
  2004-04-16 22:57 UTC  Greg Stark <gsstark@mit.edu>
` Re: Poor performance of group by query
  2004-04-18 03:35 UTC  Mark Kirkwood <markir@paradise.net.nz>
  [4+ messages in thread]

Re: [ SOLVED ] select count(*)  very slow on an already
  2004-04-15 10:59 UTC  pginfo <pginfo@t1.unisoftbg.com>
` Re: [ SOLVED ] select count(*)  very slow on an already
  2004-04-15 11:35 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: [ SOLVED ] select count(*)  very slow on an already
  2004-04-15 13:36 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: [ SOLVED ] select count(*)  very slow on an already
  2004-04-15 16:19 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: [ SOLVED ] select count(*)  very slow on an already
  2004-04-15 17:44 UTC  Richard Huxton <dev@archonet.com>
` Re: [ SOLVED ] select count(*)  very slow on an already
  2004-04-15 18:29 UTC  Mark Lubratt <mark.lubratt@indeq.com>
` Re: [ SOLVED ] select count(*)  very slow on an already
  2004-04-15 18:48 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: [ SOLVED ] select count(*)  very slow on an already
  2004-04-15 19:24 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: [ SOLVED ] select count(*)  very slow on an already
  2004-04-15 20:13 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: [ SOLVED ] select count(*)  very slow on an already
  2004-04-16 08:23 UTC  Rajesh Kumar Mallah <mallah@trade-india.com>
` Re: [ SOLVED ] select count(*)  very slow on an already
  2004-04-16 13:40 UTC  Shea,Dan [CIS] <Dan.Shea@ec.gc.ca>
` Re: [ SOLVED ] select count(*)  very slow on an already
  2004-04-17 14:29 UTC  Jeff <threshar@torgo.978.org>
  [12+ messages in thread]

Index problem
  2003-09-24 10:09 UTC  Rigmor Ukuhe <rigmor.ukuhe@finestmedia.com>
` Re: Index problem
  2003-09-24 17:03 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: Index problem
  2003-09-24 17:35 UTC  Matt Clark <matt@ymogen.net>
` Re: Index problem
  2003-09-25 10:22 UTC  Rigmor Ukuhe <rigmor.ukuhe@finestmedia.com>
` Re: Index problem
  2003-09-25 12:13 UTC  Matt Clark <matt@ymogen.net>
` Re: Index problem
  2003-09-25 13:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Index Problem?
  2004-04-16 16:41 UTC  Ron St-Pierre <rstpierre@syscor.com>
` Re: Index Problem?
  2004-04-16 17:01 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Index Problem?
  2004-04-16 17:55 UTC  Ron St-Pierre <rstpierre@syscor.com>
` Re: Index Problem?
  2004-04-16 19:10 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Index Problem?
  2004-04-16 20:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index Problem?
  2004-04-16 21:54 UTC  Ron St-Pierre <rstpierre@syscor.com>
` Re: Index Problem?
  2004-04-17 12:25 UTC  Jochem van Dieten <jochemd@oli.tudelft.nl>
  [13+ messages in thread]

Long running queries degrade performance
  2004-04-16 15:28 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Long running queries degrade performance
  2004-04-16 15:46 UTC  Mike Nolan <nolan@gw.tssi.com>
` Re: Long running queries degrade performance
  2004-04-16 17:56 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Long running queries degrade performance
  2004-04-16 20:25 UTC  Mike Nolan <nolan@gw.tssi.com>
` Re: Long running queries degrade performance
  2004-04-16 20:51 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Long running queries degrade performance
  2004-04-16 21:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Long running queries degrade performance
  2004-04-16 21:26 UTC  Chris Kratz <chris.kratz@vistashare.com>
` Re: Long running queries degrade performance
  2004-04-17 11:59 UTC  Christopher Browne <cbbrowne@acm.org>
  [8+ 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