pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Some very weird behaviour....
  2003-07-09 17:29 UTC  Chris Bowlby <excalibur@hub.org>
` Re: Some very weird behaviour....
  2003-07-09 17:42 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Some very weird behaviour....
  2003-07-10 15:09 UTC  Chris Bowlby <excalibur@hub.org>
  [3+ messages in thread]

Re: substr_count
  2003-07-10 12:55 UTC  Michael Pohl <pgsql@newtopia.com>

Can you help me?
  2003-07-10 01:51 UTC  Chris_Wu <Chris.Wu@Sanmina-SCI.Com>
` Re: Can you help me?
  2003-07-10 08:29 UTC  Oliver Scheit <oliver.scheit@REALGARANT.DE>
  [2+ messages in thread]

plpgsql vs. SQL performance (again)
  2003-07-10 01:48 UTC  Michael Pohl <pgsql@newtopia.com>

Efficiency of timestamps
  2003-07-09 00:27 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: Efficiency of timestamps
  2003-07-09 00:55 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: Efficiency of timestamps
  2003-07-09 01:37 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: Efficiency of timestamps
  2003-07-09 02:49 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: Efficiency of timestamps
  2003-07-09 04:23 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: Efficiency of timestamps
  2003-07-09 05:01 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: Efficiency of timestamps
  2003-07-09 06:51 UTC  Martin Foster <martin@ethereal-realms.org>
  [7+ messages in thread]

Config file problem
  2003-07-08 19:46 UTC  Hilary Forbes <hforbes@dmr.co.uk>
` Re: Config file problem
  2003-07-09 01:13 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [2+ messages in thread]

Strange result: UNIX vs. TCP/IP sockets
  2003-07-04 17:22 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Strange result: UNIX vs. TCP/IP sockets
  2003-07-04 17:35 UTC  The Hermit Hacker <scrappy@postgresql.org>
` Re: Strange result: UNIX vs. TCP/IP sockets
  2003-07-04 17:55 UTC  Vincent van Leeuwen <pgsql.spam@vinz.nl>
` Re: Strange result: UNIX vs. TCP/IP sockets
  2003-07-04 18:07 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Strange result: UNIX vs. TCP/IP sockets
  2003-07-04 21:20 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Strange result: UNIX vs. TCP/IP sockets
  2003-07-04 21:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strange result: UNIX vs. TCP/IP sockets
  2003-07-05 20:58 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Strange result: UNIX vs. TCP/IP sockets
  2003-07-08 20:54 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [8+ messages in thread]

Another POC initdb patch
  2003-07-06 14:10 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Another POC initdb patch
  2003-07-06 15:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Another POC initdb patch
  2003-07-07 06:45 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
  [3+ messages in thread]

PostgreSQL banner
  2003-07-06 13:05 UTC  Cornelia Boenigk <poppcorn@cornelia-boenigk.de>

Re: can multiple vacuums gain speed?
  2003-07-04 13:25 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>

How to optimize monstrous query, sorts instead of using index
  2003-06-25 11:46 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: How to optimize monstrous query, sorts instead of using index
  2003-06-25 11:54 UTC  Rod Taylor <rbt@rbt.ca>
` Re: How to optimize monstrous query, sorts instead of using index
  2003-06-25 12:00 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: How to optimize monstrous query, sorts instead of
  2003-06-25 12:12 UTC  Rod Taylor <rbt@rbt.ca>
` Re: How to optimize monstrous query, sorts instead of
  2003-06-25 12:48 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: How to optimize monstrous query, sorts instead of
  2003-06-25 13:36 UTC  Rod Taylor <rbt@rbt.ca>
` Re: How to optimize monstrous query, sorts instead of
  2003-06-25 14:09 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: How to optimize monstrous query, sorts instead of using index
  2003-06-25 14:15 UTC  SZUCS Gábor <surrano@mailbox.hu>
` Re: How to optimize monstrous query, sorts instead of
  2003-06-25 14:20 UTC  SZUCS Gábor <surrano@mailbox.hu>
` Re: How to optimize monstrous query, sorts instead of
  2003-06-25 14:28 UTC  Rod Taylor <rbt@rbt.ca>
` Re: How to optimize monstrous query, sorts instead of using index
  2003-06-25 14:48 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: How to optimize monstrous query, sorts instead of
  2003-06-25 15:09 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: How to optimize monstrous query, sorts instead of
  2003-06-25 15:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to optimize monstrous query, sorts instead of using index
  2003-06-25 16:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to optimize monstrous query, sorts instead of
  2003-07-02 10:24 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: How to optimize monstrous query, sorts instead of
  2003-07-02 10:28 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: How to optimize monstrous query, sorts instead of
  2003-07-02 12:45 UTC  Rod Taylor <rbt@rbt.ca>
` Re: How to optimize monstrous query, sorts instead of
  2003-07-02 12:51 UTC  Rod Taylor <rbt@rbt.ca>
` Re: How to optimize monstrous query, sorts instead of
  2003-07-02 13:46 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: How to optimize monstrous query, sorts instead of
  2003-07-03 12:26 UTC  Rod Taylor <rbt@rbt.ca>
  [20+ messages in thread]

Re: raise or lower transaction timeout?
  2003-07-03 08:47 UTC  Paul Thomas <paul@tmsl.demon.co.uk>

Version 7 question
  2003-07-01 12:10 UTC  Hilary Forbes <hforbes@dmr.co.uk>
` Re: Version 7 question
  2003-07-01 12:17 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: Version 7 question
  2003-07-01 12:52 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: Version 7 question
  2003-07-01 12:55 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Version 7 question
  2003-07-01 13:02 UTC  Michael Mattox <michael.mattox@verideon.com>
` FW: Version 7 question
  2003-07-01 13:06 UTC  Howard Oblowitz <HowardO@LEWIS-STORES.com>
` Re: FW: Version 7 question
  2003-07-01 13:19 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Version 7 question
  2003-07-01 13:55 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: Version 7 question
  2003-07-01 14:19 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Version 7 question
  2003-07-01 14:22 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Version 7 question
  2003-07-01 18:01 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Version 7 question
  2003-07-02 01:37 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [12+ messages in thread]

excessive disk access during query
  2003-07-01 03:19 UTC  Toby Sargeant <sargeant@wehi.edu.au>
` Re: excessive disk access during query
  2003-07-01 13:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

slower with the time
  2003-07-01 07:47 UTC  Juraj Porada <porada@pe-muc.de>
` Re: slower with the time
  2003-07-01 07:48 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: slower with the time
  2003-07-01 08:10 UTC  Juraj Porada <porada@pe-muc.de>
` Re: slower with the time
  2003-07-01 08:17 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
  [4+ messages in thread]

Query planner plans very inefficient plans
  2003-06-30 17:57 UTC  Robert Wille <a2om6sy02@sneakemail.com>
` Re: Query planner plans very inefficient plans
  2003-06-30 19:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query planner plans very inefficient plans
  2003-06-30 21:13 UTC  Sean Chittenden <sean@chittenden.org>
  [3+ messages in thread]

'best practises' to speed up sorting? tuning postgresql.conf
  2003-06-28 11:31 UTC  Chris Hutchinson <chris@hutchinsonsoftware.com>
` Re: 'best practises' to speed up sorting? tuning postgresql.conf
  2003-06-28 11:37 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: 'best practises' to speed up sorting? tuning postgresql.conf
  2003-06-28 11:58 UTC  Arjen van der Meijden <acm@tweakers.net>
  [3+ messages in thread]

Large querie with several EXISTS which will be often runned
  2003-06-27 14:32 UTC  Bruno BAGUETTE <pgsql-ml@baguette.net>
` Re: Large querie with several EXISTS which will be often runned
  2003-06-27 15:41 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Large querie with several EXISTS which will be often runned
  2003-06-28 09:35 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
  [3+ messages in thread]

RE : Large querie with several EXISTS which will be often runned
  2003-06-28 09:17 UTC  Bruno BAGUETTE <pgsql-ml@baguette.net>

problem with pg_statistics
  2003-06-26 13:15 UTC  Andre Schubert <andre@km3.de>
` Re: problem with pg_statistics
  2003-06-26 14:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: problem with pg_statistics
  2003-06-26 15:51 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: problem with pg_statistics
  2003-06-26 16:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: problem with pg_statistics
  2003-06-27 06:07 UTC  Andre Schubert <andre.schubert@km3.de>
` Re: problem with pg_statistics
  2003-06-27 06:13 UTC  Andre Schubert <andre.schubert@km3.de>
` Re: problem with pg_statistics
  2003-06-27 08:43 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: problem with pg_statistics
  2003-06-27 09:10 UTC  Andre Schubert <andre@km3.de>
` Re: problem with pg_statistics
  2003-06-27 10:05 UTC  Manfred Koizar <mkoi-pg@aon.at>
  [9+ messages in thread]

Similar querys, better execution time on worst execution plan
  2003-06-25 19:25 UTC  Fernando Papa <fpapa@claxson.com>
` Re: Similar querys, better execution time on worst execution plan
  2003-06-26 10:30 UTC  SZUCS Gábor <surrano@mailbox.hu>
` Re: Similar querys, better execution time on worst execution plan
  2003-06-26 13:33 UTC  Fernando Papa <fpapa@claxson.com>
` Re: Similar querys, better execution time on worst execution plan
  2003-06-26 15:06 UTC  SZUCS Gábor <surrano@mailbox.hu>
  [4+ messages in thread]

Performance advice
  2003-06-24 07:39 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: Performance advice
  2003-06-24 07:59 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Performance advice
  2003-06-24 08:19 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Performance advice
  2003-06-24 09:02 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Performance advice
  2003-06-24 11:33 UTC  Richard Huxton <dev@archonet.com>
` Re: Performance advice
  2003-06-24 12:16 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: Performance advice
  2003-06-24 14:10 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: Performance advice
  2003-06-24 14:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance advice
  2003-06-24 15:47 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: Performance advice
  2003-06-24 16:04 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Performance advice
  2003-06-24 17:00 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Performance advice
  2003-06-25 06:48 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: Performance advice
  2003-06-25 06:51 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Performance advice
  2003-06-25 08:12 UTC  Hilary Forbes <hforbes@dmr.co.uk>
` Re: Performance advice
  2003-06-25 08:58 UTC  Howard Oblowitz <HowardO@LEWIS-STORES.com>
` Re: Performance advice
  2003-06-25 09:47 UTC  Michael Mattox <michael.mattox@verideon.com>
` Re: Performance advice
  2003-06-25 09:58 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Performance advice
  2003-06-25 11:06 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Performance advice
  2003-06-25 11:09 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Performance advice
  2003-06-25 11:52 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: Performance advice
  2003-06-25 13:04 UTC  pgsql@newtopia.com
` Re: Performance advice
  2003-06-25 16:32 UTC  Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: Performance advice
  2003-06-26 12:49 UTC  Manfred Koizar <mkoi-pg@aon.at>
  [23+ messages in thread]

Query running slower than same on Oracle
  2003-06-25 21:33 UTC  Sailer, Denis (YBUSA-CDR) <Denis.Sailer@Yellowbook.com>
` Re: Query running slower than same on Oracle
  2003-06-25 21:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query running slower than same on Oracle
  2003-06-25 21:51 UTC  Josh Berkus <josh@agliodbs.com>
  [3+ messages in thread]

Deleting one record from a table taking 17s.
  2003-06-20 15:53 UTC  Yusuf <yusuf0478@netscape.net>
` Re: Deleting one record from a table taking 17s.
  2003-06-20 16:06 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Deleting one record from a table taking 17s.
  2003-06-20 16:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Deleting one record from a table taking 17s.
  2003-06-20 17:06 UTC  Yusuf <yusuf0478@netscape.net>
` Re: Deleting one record from a table taking 17s.
  2003-06-20 22:04 UTC  Rod Taylor <rbt@rbt.ca>
  [5+ messages in thread]

Recent 7.4 change slowed down a query by a factor of 3
  2003-06-18 15:02 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Recent 7.4 change slowed down a query by a factor of 3
  2003-06-18 15:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Recent 7.4 change slowed down a query by a factor of 3
  2003-06-18 15:43 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Recent 7.4 change slowed down a query by a factor of 3
  2003-06-18 15:45 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Recent 7.4 change slowed down a query by a factor of 3
  2003-06-18 15:53 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Recent 7.4 change slowed down a query by a factor of 3
  2003-06-18 16:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ 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