pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgresql performance on Solaris
  2003-04-01 19:31 UTC  Scott Buchan <sbuchan@technicacorp.com>
` Re: Postgresql performance on Solaris
  2003-04-01 20:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgresql performance on Solaris
  2003-04-01 21:42 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [3+ messages in thread]

30-70 seconds query...
  2003-03-31 21:13 UTC  alexandre :: aldeia digital <alepaes@aldeiadigital.com.br>
` Re: 30-70 seconds query...
  2003-03-31 22:15 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: 30-70 seconds query...
  2003-03-31 22:17 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 30-70 seconds query...
  2003-03-31 22:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: 30-70 seconds query...
  2003-03-31 23:44 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: 30-70 seconds query...
  2003-04-01 12:23 UTC  alexandre :: aldeia digital <alepaes@aldeiadigital.com.br>
  [6+ messages in thread]

Index not used, performance problem
  2003-03-29 09:49 UTC  Andreas Kostyrka <andreas@mtg.co.at>
` Re: Index not used, performance problem
  2003-03-29 13:47 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Index not used, performance problem
  2003-03-29 15:34 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Index not used, performance problem
  2003-03-29 16:49 UTC  John K. Herreshoff <jkherr@centurytel.net>
` Re: Index not used, performance problem
  2003-03-29 16:57 UTC  Andreas Kostyrka <andreas@mtg.co.at>
` Re: Index not used, performance problem
  2003-03-29 16:59 UTC  Andreas Kostyrka <andreas@mtg.co.at>
` Re: Index not used, performance problem
  2003-03-29 16:59 UTC  Jord Tanner <jord@indygecko.com>
` Re: Index not used, performance problem
  2003-03-29 17:55 UTC  Matt Mello <alien@spaceship.com>
` Re: Index not used, performance problem
  2003-03-29 23:13 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index not used, performance problem
  2003-03-31 18:21 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Index not used, performance problem
  2003-03-31 18:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [11+ messages in thread]

WAL monitoring and optimizing
  2003-03-31 12:06 UTC  Marco Colombo <marco@esi.it>
` Re: WAL monitoring and optimizing
  2003-03-31 17:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Bad perfomance of pl/pgsql-function on new server
  2003-03-29 21:17 UTC  Wil Peters <info@itaudit.demon.nl>
` Re: Bad perfomance of pl/pgsql-function on new server
  2003-03-29 23:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

slow query - where not in
  2003-03-28 15:38 UTC  Jeremiah Elliott <jelliott@artcobell.com>
` Re: slow query - where not in
  2003-03-28 15:59 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: slow query - where not in
  2003-03-28 16:20 UTC  Greg Stark <gsstark@mit.edu>
` Re: slow query - where not in
  2003-03-28 16:53 UTC  Michael Paesold <mpaesold@gmx.at>
` Re: slow query - where not in
  2003-03-28 17:53 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: slow query - where not in
  2003-03-28 20:58 UTC  Jeremiah Elliott <jelliott@artcobell.com>
  [6+ messages in thread]

calling analyze from a stored procedure in C
  2003-03-28 17:04 UTC  Ulli Mueckstein <ulim@tbi.univie.ac.at>

max_fsm settings
  2003-03-27 16:58 UTC  Robert D Oden <roden@dbasetek.com>
` Re: max_fsm settings
  2003-03-27 21:10 UTC  Robert Treat <xzilla@users.sourceforge.net>
  [2+ messages in thread]

(no subject)
  2003-03-27 00:26 UTC  Abhishek Sharma <abhisheks@dpsl.net>

Adding a foreign key constraint is extremely slow
  2003-03-23 17:58 UTC  bsamwel@xs4all.nl
` Re: Adding a foreign key constraint is extremely slow
  2003-03-23 19:30 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: Adding a foreign key constraint is extremely slow
  2003-03-26 14:17 UTC  Greg Stark <gsstark@mit.edu>
` Re: Adding a foreign key constraint is extremely slow
  2003-03-26 17:08 UTC  Bart Samwel <bsamwel@liacs.nl>
  [4+ messages in thread]

(no subject)
  2003-03-25 20:32 UTC  dharana@gamersmafia.com

What's better: one huge database or several smaller ones?
  2003-03-25 20:31 UTC  dharana <dharana@gamersmafia.com>

Finding the PID keeping a transaction open
  2003-03-25 13:12 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Finding the PID keeping a transaction open
  2003-03-25 14:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Finding the PID keeping a transaction open
  2003-03-25 15:30 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [3+ messages in thread]

Slow update of indexed column with many nulls
  2003-03-23 17:38 UTC  bsamwel@xs4all.nl
` Re: Slow update of indexed column with many nulls
  2003-03-23 21:55 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

Page Size in Future Releases
  2003-03-20 20:45 UTC  Kendrick C. Wilson <kendrick_wilson@hotmail.com>
` Re: Page Size in Future Releases
  2003-03-21 03:39 UTC  Shridhar Daithankar<shridhar_daithankar@persistent.co.in> <shridhar_daithankar@persistent.co.in>
` Re: Page Size in Future Releases
  2003-03-21 03:51 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Page Size in Future Releases
  2003-03-21 04:03 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Page Size in Future Releases
  2003-03-22 00:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Page Size in Future Releases
  2003-03-23 08:46 UTC  Mario Weilguni <mweilguni@sime.com>
  [6+ messages in thread]

Make PGSQL faster
  2003-03-20 18:53 UTC  Torsten Schulz <tsschulz@gmx.net>
` Re: Make PGSQL faster
  2003-03-21 20:06 UTC  Andrew McMillan <andrew@catalyst.net.nz>
  [2+ messages in thread]

postgresql meltdown on PlanetMath.org
  2003-03-16 06:01 UTC  Aaron Krowne <akrowne@vt.edu>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-16 06:12 UTC  Sean Chittenden <sean@chittenden.org>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-16 06:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-16 06:37 UTC  Joe Conway <mail@joeconway.com>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-16 07:52 UTC  Aaron Krowne <akrowne@vt.edu>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-16 08:06 UTC  Aaron Krowne <akrowne@vt.edu>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-16 08:20 UTC  Sean Chittenden <sean@chittenden.org>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-16 08:30 UTC  Aaron Krowne <akrowne@vt.edu>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-16 08:35 UTC  Sean Chittenden <sean@chittenden.org>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-16 08:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-16 11:29 UTC  Joe Conway <mail@joeconway.com>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 02:08 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 06:10 UTC  Sean Chittenden <sean@chittenden.org>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 06:12 UTC  Logan Bowers <logan@datacurrent.com>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 06:18 UTC  Neil Conway <neilc@samurai.com>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 06:29 UTC  Sean Chittenden <sean@chittenden.org>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 06:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 15:58 UTC  Greg Stark <gsstark@mit.edu>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 16:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 17:12 UTC  Chris Sutton <chris@smoothcorp.com>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 18:33 UTC  Max Baker <max@warped.org>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 19:20 UTC  Neil Conway <neilc@samurai.com>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 19:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 19:47 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 20:46 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 22:46 UTC  Kendrick C. Wilson <kendrick_wilson@hotmail.com>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-17 23:15 UTC  Lucas Adamski <ladamski@manageww.com>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-18 01:34 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-18 02:31 UTC  Aaron Krowne <akrowne@vt.edu>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-18 02:41 UTC  Logan Bowers <logan@datacurrent.com>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-18 02:44 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-18 02:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-18 14:59 UTC  Chris Sutton <chris@smoothcorp.com>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-18 15:19 UTC  Kendrick C. Wilson <kendrick_wilson@hotmail.com>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-18 16:26 UTC  Josh Berkus <josh@agliodbs.com>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-19 19:52 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-20 23:01 UTC  Florian Weimer <Weimer@CERT.Uni-Stuttgart.DE>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-21 03:48 UTC  Shridhar Daithankar<shridhar_daithankar@persistent.co.in> <shridhar_daithankar@persistent.co.in>
` Re: postgresql meltdown on PlanetMath.org
  2003-03-21 06:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [39+ messages in thread]

Help with LIKE
  2003-03-20 21:41 UTC  David Olbersen <DOlbersen@stbernard.com>
` Re: Help with LIKE
  2003-03-20 21:55 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Help with LIKE
  2003-03-20 23:19 UTC  David Olbersen <DOlbersen@stbernard.com>
` Re: Help with LIKE
  2003-03-20 23:35 UTC  David Olbersen <DOlbersen@stbernard.com>
` Re: Help with LIKE
  2003-03-21 01:27 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Help with LIKE
  2003-03-21 02:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

just to get some opinion on my configuration
  2003-03-20 21:26 UTC  Guillaume Houssay <ghoussay@noos.fr>

Re: ABOUT YOUR CREDIT......... lquwj
  2003-03-19 02:28 UTC  Lodovico <Credit_Doctor_44@cs.com>

Performance on large data transformations
  2003-03-17 17:38 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Performance on large data transformations
  2003-03-17 20:06 UTC  Ron Mayer <ron@intervideo.com>
  [2+ messages in thread]

speeding up COUNT and DISTINCT queries
  2003-03-12 22:38 UTC  Max Baker <max@warped.org>
` Re: speeding up COUNT and DISTINCT queries
  2003-03-12 22:52 UTC  Rod Taylor <rbt@rbt.ca>
` Re: speeding up COUNT and DISTINCT queries
  2003-03-12 22:55 UTC  Chad Thompson <chad@weblinkservices.com>
` Re: speeding up COUNT and DISTINCT queries
  2003-03-12 23:40 UTC  Jean-Luc Lachance <jllachan@nsd.ca>
` Re: speeding up COUNT and DISTINCT queries
  2003-03-12 23:48 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: speeding up COUNT and DISTINCT queries
  2003-03-13 01:00 UTC  Max Baker <max@warped.org>
` Re: speeding up COUNT and DISTINCT queries
  2003-03-13 01:55 UTC  Max Baker <max@warped.org>
` Re: speeding up COUNT and DISTINCT queries
  2003-03-13 01:57 UTC  Joe Conway <mail@joeconway.com>
` Re: speeding up COUNT and DISTINCT queries
  2003-03-13 02:05 UTC  Max Baker <max@warped.org>
` Re: speeding up COUNT and DISTINCT queries
  2003-03-13 02:20 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: speeding up COUNT and DISTINCT queries
  2003-03-13 15:42 UTC  Greg Stark <gsstark@mit.edu>
` Re: speeding up COUNT and DISTINCT queries
  2003-03-13 20:05 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: speeding up COUNT and DISTINCT queries
  2003-03-13 20:22 UTC  Max Baker <max@warped.org>
` Re: speeding up COUNT and DISTINCT queries
  2003-03-14 17:10 UTC  Josh Berkus <josh@agliodbs.com>
  [14+ messages in thread]

Large difference between elapsed time and run time for queries
  2003-03-10 18:58 UTC  Scott Buchan <sbuchan@technicacorp.com>
` Re: Large difference between elapsed time and run time for queries
  2003-03-10 20:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Large difference between elapsed time and run time
  2003-03-11 08:46 UTC  Nikk Anderson <Nikk.Anderson@parallel.ltd.uk>
` Re: Large difference between elapsed time and run time
  2003-03-11 14:24 UTC  Jeffrey D. Brower <jeff@pointhere.net>
` Re: Large difference between elapsed time and run time
  2003-03-11 14:30 UTC  Nikk Anderson <Nikk.Anderson@parallel.ltd.uk>
` Re: Large difference between elapsed time and run time
  2003-03-11 14:53 UTC  Jeffrey D. Brower <jeff@pointhere.net>
` Re: Large difference between elapsed time and run time for queries
  2003-03-11 18:23 UTC  Scott Buchan <sbuchan@technicacorp.com>
` Re: Large difference between elapsed time and run time
  2003-03-11 20:50 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [8+ messages in thread]

pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-06 03:16 UTC  Tom Lane <tgl@postgresql.org>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-06 03:30 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-06 03:34 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-06 03:42 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-06 03:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-06 04:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-06 04:33 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-06 09:41 UTC  Sean Chittenden <sean@chittenden.org>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-06 15:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-07 00:36 UTC  Sean Chittenden <sean@chittenden.org>
` Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-07 00:47 UTC  Neil Conway <neilc@samurai.com>
` Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-07 06:04 UTC  Sean Chittenden <sean@chittenden.org>
` Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-07 14:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-07 21:46 UTC  Sean Chittenden <sean@chittenden.org>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-11 02:50 UTC  Marc G. Fournier <scrappy@hub.org>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-11 04:11 UTC  Sean Chittenden <sean@chittenden.org>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-11 04:17 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-11 04:42 UTC  Neil Conway <neilc@samurai.com>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-11 04:53 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-11 04:56 UTC  Sean Chittenden <sean@chittenden.org>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-11 05:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: pgsql-server/ /configure /configure.in rc/incl ...
  2003-03-11 05:30 UTC  Sean Chittenden <sean@chittenden.org>
  [22+ messages in thread]

Index / Performance issues
  2003-03-08 00:15 UTC  Lucas Adamski <ladamski@breakwatersecurity.com>
` Re: Index / Performance issues
  2003-03-08 00:33 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Index / Performance issues
  2003-03-08 02:39 UTC  Greg Stark <gsstark@mit.edu>
` Re: Index / Performance issues
  2003-03-10 16:55 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Index / Performance issues
  2003-03-11 03:44 UTC  Kevin Brown <kevin@sysexperts.com>
  [5+ 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