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