pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Changing the column length
  2004-09-01 06:42 UTC  Michael Ryan S. Puncia <mpuncia@census.gov.ph>
` Re: Changing the column length
  2004-09-01 08:47 UTC  gnari <gnari@simnet.is>
` Re: Changing the column length
  2004-09-01 16:32 UTC  Josh Berkus <josh@agliodbs.com>
  [3+ messages in thread]

slower every day
  2004-09-01 10:06 UTC  G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
` Re: slower every day
  2004-09-01 10:25 UTC  Shridhar Daithankar <shridhar@frodo.hserus.net>
` Re: slower every day
  2004-09-01 10:28 UTC  Peter Eisentraut <peter_e@gmx.net>
` Re: slower every day
  2004-09-01 10:57 UTC  G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
` Re: slower every day
  2004-09-01 11:58 UTC  G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
` Re: [ADMIN] slower every day
  2004-09-01 12:27 UTC  Richard Huxton <dev@archonet.com>
` Re: slower every day
  2004-09-01 14:28 UTC  Michael Paesold <mpaesold@gmx.at>
` Re: slower every day
  2004-09-01 15:07 UTC  G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
  [8+ messages in thread]

Why does a simple query not use an obvious index?
  2004-08-27 17:12 UTC  Jack Kerkhof <jack.kerkhof@guest-tek.com>
` Re: Why does a simple query not use an obvious index?
  2004-08-29 18:04 UTC  Mr Pink <mr_pink_is_the_only_pro@yahoo.com>
` Re: Why does a simple query not use an obvious index?
  2004-08-29 18:28 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: Why does a simple query not use an obvious index?
  2004-08-29 18:57 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Why does a simple query not use an obvious index?
  2004-08-29 21:10 UTC  Greg Stark <gsstark@mit.edu>
` Re: Why does a simple query not use an obvious index?
  2004-08-29 21:12 UTC  Greg Stark <gsstark@mit.edu>
` Re: Why does a simple query not use an obvious index?
  2004-08-29 21:38 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: Why does a simple query not use an obvious index?
  2004-08-29 21:44 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: Why does a simple query not use an obvious index?
  2004-08-29 22:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why does a simple query not use an obvious index?
  2004-08-29 22:04 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Why does a simple query not use an obvious index?
  2004-08-29 22:10 UTC  Greg Stark <gsstark@mit.edu>
` Re: Why does a simple query not use an obvious index?
  2004-08-29 22:18 UTC  Rod Taylor <pg@rbt.ca>
` Re: Why does a simple query not use an obvious index?
  2004-08-30 02:09 UTC  Mr Pink <mr_pink_is_the_only_pro@yahoo.com>
` Re: Why does a simple query not use an obvious index?
  2004-08-30 02:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why does a simple query not use an obvious index?
  2004-08-30 07:38 UTC  Mr Pink <mr_pink_is_the_only_pro@yahoo.com>
` Re: Why does a simple query not use an obvious index?
  2004-08-30 08:19 UTC  Guy Thornley <guy@esphion.com>
` Re: Why does a simple query not use an obvious index?
  2004-08-30 15:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why does a simple query not use an obvious index?
  2004-08-30 15:41 UTC  Greg Stark <gsstark@mit.edu>
` Re: Why does a simple query not use an obvious index?
  2004-08-30 16:02 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Why does a simple query not use an obvious index?
  2004-08-30 16:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why does a simple query not use an obvious index?
  2004-08-30 19:17 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Why does a simple query not use an obvious index?
  2004-08-30 19:21 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Why does a simple query not use an obvious index?
  2004-08-30 19:32 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: Why does a simple query not use an obvious index?
  2004-08-30 19:40 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Why does a simple query not use an obvious index?
  2004-08-30 20:18 UTC  Greg Stark <gsstark@mit.edu>
` Re: Why does a simple query not use an obvious index?
  2004-08-30 21:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why does a simple query not use an obvious index?
  2004-08-31 06:00 UTC  Greg Stark <gsstark@mit.edu>
` Re: Why does a simple query not use an obvious index?
  2004-09-01 12:50 UTC  Mr Pink <mr_pink_is_the_only_pro@yahoo.com>
  [28+ messages in thread]

Query performance issue with 8.0.0beta1
  2004-08-27 06:57 UTC  Stefano Bonnin <stefano.bonnin@comai.to>
` Re: Query performance issue with 8.0.0beta1
  2004-08-27 08:48 UTC  Russell Smith <mr-russ@pws.com.au>
` Re: Query performance issue with 8.0.0beta1
  2004-08-27 16:52 UTC  andrew@pillette.com
` Re: Query performance issue with 8.0.0beta1
  2004-08-27 17:14 UTC  Josh Berkus <josh@agliodbs.com>
` Fw: Query performance issue with 8.0.0beta1
  2004-09-01 07:56 UTC  Stefano Bonnin <stefano.bonnin@comai.to>
` Re: Query performance issue with 8.0.0beta1
  2004-09-01 09:18 UTC  Stefano Bonnin <stefano.bonnin@comai.to>
  [6+ messages in thread]

Context Switching issue: Spinlock doesn't fix.
  2004-06-02 19:25 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Context Switching issue: Spinlock doesn't fix.
  2004-08-31 21:20 UTC  jelle <jellej@pacbell.net>
` Re: Context Switching issue: Spinlock doesn't fix.
  2004-08-31 22:03 UTC  Josh Berkus <josh@agliodbs.com>
  [3+ messages in thread]

Optimizing a request
  2004-08-31 18:59 UTC  Jean-Max Reymond <jmreymond@gmail.com>
` Re: Optimizing a request
  2004-08-31 19:15 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Optimizing a request
  2004-08-31 19:19 UTC  Jean-Max Reymond <jmreymond@gmail.com>
` Re: Optimizing a request
  2004-08-31 19:21 UTC  Gary Doades <gpd@gpdnet.co.uk>
` Re: Optimizing a request
  2004-08-31 19:42 UTC  Jean-Max Reymond <jmreymond@gmail.com>
` Re: Optimizing a request
  2004-08-31 20:13 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimizing a request
  2004-08-31 20:16 UTC  Gary Doades <gpd@gpdnet.co.uk>
` Re: Optimizing a request
  2004-08-31 20:24 UTC  Jean-Max Reymond <jmreymond@gmail.com>
` Re: Optimizing a request
  2004-08-31 20:26 UTC  Jean-Max Reymond <jmreymond@gmail.com>
` Re: Optimizing a request
  2004-08-31 20:31 UTC  Gary Doades <gpd@gpdnet.co.uk>
` Re: Optimizing a request
  2004-08-31 20:41 UTC  Hervé Piedvache <footcow@noos.fr>
  [11+ messages in thread]

Performance with Intel Compiler
  2004-08-31 15:27 UTC  Jean-Max Reymond <jmreymond@gmail.com>

Query performance problem in 8.0.0beta1
  2004-08-26 13:36 UTC  Stefano Bonnin <stefano.bonnin@comai.to>
` Re: Query performance problem in 8.0.0beta1
  2004-08-29 22:31 UTC  Russell Smith <mr-russ@pws.com.au>
  [2+ messages in thread]

Performance hit on loading from HD
  2004-08-28 17:41 UTC  Vitaly Belman <vitalyb@gmail.com>
` Re: Performance hit on loading from HD
  2004-08-28 21:34 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

ill-planned queries inside a stored procedure
  2004-08-28 11:14 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: ill-planned queries inside a stored procedure
  2004-08-28 15:13 UTC  andrew@pillette.com
` Re: ill-planned queries inside a stored procedure
  2004-08-28 16:35 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [3+ messages in thread]

Why those queries do not utilize indexes?
  2004-08-27 19:29 UTC  Artimenko Igor <igorart7@yahoo.com>
` Re: Why those queries do not utilize indexes?
  2004-08-27 19:49 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: Why those queries do not utilize indexes?
  2004-08-27 21:08 UTC  Artimenko Igor <igorart7@yahoo.com>
` Re: Why those queries do not utilize indexes?
  2004-08-28 08:50 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [4+ messages in thread]

Anyone familiar with Apple Xserve RAID
  2004-08-25 21:09 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: Anyone familiar with Apple Xserve RAID
  2004-08-25 21:22 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Anyone familiar with Apple Xserve RAID
  2004-08-25 22:52 UTC  Doug McNaught <doug@mcnaught.org>
` Re: Anyone familiar with Apple Xserve RAID
  2004-08-25 22:58 UTC  Ralf Schramm <ralf.schramm@bahn.de>
` Re: Anyone familiar with Apple Xserve RAID
  2004-08-25 23:03 UTC  Ralf Schramm <ralf.schramm@bahn.de>
` Re: Anyone familiar with Apple Xserve RAID
  2004-08-25 23:49 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Anyone familiar with Apple Xserve RAID
  2004-08-26 12:07 UTC  Andrew Rawnsley <ronz@ravensfield.com>
` Re: Anyone familiar with Apple Xserve RAID
  2004-08-26 15:13 UTC  Tore Halset <halset@pvv.ntnu.no>
` Re: Anyone familiar with Apple Xserve RAID
  2004-08-26 17:40 UTC  Andrew Rawnsley <ronz@ravensfield.com>
` Re: Anyone familiar with Apple Xserve RAID
  2004-08-26 19:06 UTC  Kevin Barnard <kbarnard@speedfc.com>
` Re: Anyone familiar with Apple Xserve RAID
  2004-08-26 19:54 UTC  Doug McNaught <doug@mcnaught.org>
` Re: Anyone familiar with Apple Xserve RAID
  2004-08-26 20:01 UTC  Alan Stange <stange@rentec.com>
` Re: Anyone familiar with Apple Xserve RAID
  2004-08-26 20:12 UTC  Andrew Rawnsley <ronz@ravensfield.com>
` Re: Anyone familiar with Apple Xserve RAID
  2004-08-27 20:34 UTC  Vivek Khera <khera@kcilink.com>
  [14+ messages in thread]

postgresql performance with multimedia
  2004-08-18 00:44 UTC  my thi ho <mthoatbanjo@yahoo.com>
` Re: postgresql performance with multimedia
  2004-08-18 13:10 UTC  Jan Wieck <JanWieck@Yahoo.com>
` Re: postgresql performance with multimedia
  2004-08-24 05:08 UTC  my ho <mthoatbanjo@yahoo.com>
` Re: postgresql performance with multimedia
  2004-08-24 12:00 UTC  Jan Wieck <JanWieck@Yahoo.com>
` Re: postgresql performance with multimedia
  2004-08-25 06:54 UTC  my ho <mthoatbanjo@yahoo.com>
` Re: postgresql performance with multimedia
  2004-08-25 07:14 UTC  Gregory S. Williamson <gsw@globexplorer.com>
` Re: postgresql performance with multimedia
  2004-08-25 11:03 UTC  Jan Wieck <JanWieck@Yahoo.com>
` Re: postgresql performance with multimedia
  2004-08-27 06:27 UTC  my ho <mthoatbanjo@yahoo.com>
  [8+ messages in thread]

Disabling transaction/outdated-tuple behaviour
  2004-08-26 18:02 UTC  Neil Cooper <Neil.Cooper@scigames.com>
` Re: Disabling transaction/outdated-tuple behaviour
  2004-08-26 18:18 UTC  Matt Clark <matt@ymogen.net>
` Re: Disabling transaction/outdated-tuple behaviour
  2004-08-26 18:20 UTC  Josh Berkus <josh@agliodbs.com>
  [3+ messages in thread]

Optimizer Selecting Incorrect Index
  2004-08-25 15:07 UTC  David Price <dprice@dentfirst.com>
` Re: Optimizer Selecting Incorrect Index
  2004-08-25 15:47 UTC  Richard Huxton <dev@archonet.com>
` Re: Optimizer Selecting Incorrect Index
  2004-08-25 19:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimizer Selecting Incorrect Index
  2004-08-26 06:15 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: Optimizer Selecting Incorrect Index
  2004-08-26 10:17 UTC  Richard Huxton <dev@archonet.com>
` Re: Optimizer Selecting Incorrect Index
  2004-08-26 11:05 UTC  David Price <dprice@dentfirst.com>
  [6+ messages in thread]

What is the best way to do attribute/values?
  2004-08-19 18:03 UTC  Daniel Ceregatti <vi@sh.nu>
` Re: What is the best way to do attribute/values?
  2004-08-24 20:30 UTC  Josh Berkus <josh@agliodbs.com>
` Re: What is the best way to do attribute/values?
  2004-08-24 21:00 UTC  Richard Huxton <dev@archonet.com>
` Re: What is the best way to do attribute/values?
  2004-08-25 08:22 UTC  Mark Kirkwood <markir@coretech.co.nz>
` Re: What is the best way to do attribute/values?
  2004-08-25 12:36 UTC  Jeff <threshar@torgo.978.org>
` Re: What is the best way to do attribute/values?
  2004-08-25 13:05 UTC  Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>
` Re: What is the best way to do attribute/values?
  2004-08-25 16:59 UTC  Josh Berkus <josh@agliodbs.com>
` Re: What is the best way to do attribute/values?
  2004-08-26 00:38 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: What is the best way to do attribute/values?
  2004-08-26 04:51 UTC  Mark Kirkwood <markir@coretech.co.nz>
  [9+ messages in thread]

Query kills machine.
  2004-08-24 08:32 UTC  Stef <svb@ucs.co.za>
` Re: Query kills machine.
  2004-08-24 09:08 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Query kills machine.
  2004-08-24 13:30 UTC  Stef <svb@ucs.co.za>
` Re: Query kills machine.
  2004-08-24 14:08 UTC  Magnus Naeslund(t) <mag@fbab.net>
` Re: Query kills machine.
  2004-08-24 14:15 UTC  Magnus Naeslund(pg) <mag-pg@fbab.net>
` Re: Query kills machine.
  2004-08-24 15:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query kills machine.
  2004-08-25 14:30 UTC  Stef <svb@ucs.co.za>
  [7+ messages in thread]

OT: Network config (WAS: RE: postgresql performance with multimedia)
  2004-08-25 11:26 UTC  Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>

[FUN] Performance increase?
  2004-08-24 16:17 UTC  Gaetano Mendola <mendola@bigfoot.com>

How do I see what triggers are called on cascade?
  2004-08-24 00:02 UTC  andrew@pillette.com
` Re: How do I see what triggers are called on cascade?
  2004-08-24 02:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

postgresql 8.0 beta - fail to collect statsistic
  2004-08-23 14:33 UTC  my thi ho <mthoatbanjo@yahoo.com>
` Re: postgresql 8.0 beta - fail to collect statsistic
  2004-08-23 19:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgresql 8.0 beta - fail to collect statsistic
  2004-08-23 21:52 UTC  Steve Bergman <steve@rueb.com>
` Re: postgresql 8.0 beta - fail to collect statsistic
  2004-08-23 22:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

using an index worst performances
  2004-08-19 17:26 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: using an index worst performances
  2004-08-19 18:09 UTC  Richard Huxton <dev@archonet.com>
` Re: using an index worst performances
  2004-08-19 19:56 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: using an index worst performances
  2004-08-20 01:39 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: using an index worst performances
  2004-08-20 09:37 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: using an index worst performances
  2004-08-20 12:55 UTC  Rod Taylor <pg@rbt.ca>
` Re: using an index worst performances
  2004-08-20 15:52 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: using an index worst performances
  2004-08-20 16:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: using an index worst performances
  2004-08-20 19:43 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: using an index worst performances
  2004-08-20 20:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: using an index worst performances
  2004-08-22 10:08 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [11+ messages in thread]

I could not get postgres to utilizy indexes
  2004-08-17 14:22 UTC  Igor Artimenko <iartimenko@bluecatnetworks.com>
` Re: I could not get postgres to utilizy indexes
  2004-08-18 17:12 UTC  Thomas Swan <tswan@idigx.com>
` Re: I could not get postgres to utilizy indexes
  2004-08-18 17:26 UTC  gnari <gnari@simnet.is>
` Re: I could not get postgres to utilizy indexes
  2004-08-18 17:31 UTC  gnari <gnari@simnet.is>
` Re: I could not get postgres to utilizy indexes
  2004-08-19 07:54 UTC  Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>
` Re: I could not get postgres to utilizy indexes
  2004-08-20 13:37 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: I could not get postgres to utilizy indexes
  2004-08-20 13:45 UTC  Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>
  [7+ messages in thread]

pg_restore very slow in 8.0.0beta1
  2004-08-20 12:59 UTC  Bonnin S. <shpr@libero.it>

Help specifying new machine
  2004-08-09 16:56 UTC  Rory Campbell-Lange <rory@campbell-lange.net>
` Re: Help specifying new machine
  2004-08-09 20:08 UTC  Bill Montgomery <billm@lulu.com>
` Re: Help specifying new machine
  2004-08-12 22:12 UTC  William Yu <wyu@talisys.com>
` Re: Help specifying new machine
  2004-08-13 06:29 UTC  Raoul Buzziol <raoulus@libero.it>
` Re: Help specifying new machine
  2004-08-15 20:17 UTC  William Yu <wyu@talisys.com>
` Re: Help specifying new machine
  2004-08-18 15:18 UTC  Raoul Buzziol <raoulus@libero.it>
` Re: Help specifying new machine
  2004-08-18 16:12 UTC  Rod Taylor <pg@rbt.ca>
` Re: Help specifying new machine
  2004-08-19 04:26 UTC  William Yu <wyu@talisys.com>
` Re: Help specifying new machine
  2004-08-19 05:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help specifying new machine
  2004-08-19 16:18 UTC  Josh Berkus <josh@agliodbs.com>
  [10+ 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