pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
optimizer picks smaller table to drive nested loops?
  2003-07-07 18:22 UTC  Greg Stark <gsstark@mit.edu>
` Re: optimizer picks smaller table to drive nested loops?
  2003-07-07 20:58 UTC  Randy Neumann <Randy_Neumann@centralref.com>
` Re: optimizer picks smaller table to drive nested loops?
  2003-07-14 18:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizer picks smaller table to drive nested loops?
  2003-07-14 18:40 UTC  Greg Stark <gsstark@mit.edu>
` Re: optimizer picks smaller table to drive nested loops?
  2003-07-14 20:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizer picks smaller table to drive nested loops?
  2003-07-14 22:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

Java Out-of-memory errors on attempts to read tables with  millions of rows
  2003-07-14 16:53 UTC  Rich Cullingford <rculling@sysd.com>
` Re: Java Out-of-memory errors on attempts to read tables with millions of rows
  2003-07-14 17:07 UTC  Evil Azrael <evilazrael@evilazrael.de>
  [2+ messages in thread]

Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 06:35 UTC  Balazs Wellisch <balazs@neusolutions.com>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 10:21 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 17:30 UTC  Joe Conway <mail@joeconway.com>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 19:30 UTC  Balazs Wellisch <balazs@neusolutions.com>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 19:42 UTC  Balazs Wellisch <balazs@neusolutions.com>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 19:51 UTC  Balazs Wellisch <balazs@neusolutions.com>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 20:04 UTC  Balazs Wellisch <balazs@neusolutions.com>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 20:25 UTC  Joe Conway <mail@joeconway.com>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-13 22:32 UTC  Jim C. Nasby <jim@nasby.net>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-14 06:37 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-14 11:44 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-14 11:45 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
  2003-07-14 14:06 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
  [13+ messages in thread]

Replacing a simple nested query?
  2003-07-13 21:50 UTC  Steve Wampler <swampler@noao.edu>
` Re: Replacing a simple nested query?
  2003-07-13 22:01 UTC  Joe Conway <mail@joeconway.com>
` Re: [SQL] Replacing a simple nested query?
  2003-07-14 13:38 UTC  Steve Wampler <swampler@noao.edu>
  [3+ messages in thread]

How to configure the postgresql.conf files
  2003-07-14 03:26 UTC  Chris_Wu <Chris.Wu@Sanmina-SCI.Com>
` Re: How to configure the postgresql.conf files
  2003-07-14 03:35 UTC  Rudi Starcevic <rudi@oasis.net.au>
` Re: How to configure the postgresql.conf files
  2003-07-14 03:46 UTC  Rudi Starcevic <rudi@oasis.net.au>
  [3+ messages in thread]

Improving a simple query?
  2003-07-13 18:05 UTC  Steve Wampler <swampler@noao.edu>
` Re: Improving a simple query?
  2003-07-13 19:09 UTC  Richard Huxton <dev@archonet.com>
` Re: Improving a simple query?
  2003-07-13 19:54 UTC  nolan@celery.tssi.com
` Re: Improving a simple query?
  2003-07-13 20:46 UTC  Steve Wampler <swampler@noao.edu>
` Re: Improving a simple query?
  2003-07-13 23:58 UTC  Hannu Krosing <hannu@tm.ee>
` Re: Improving a simple query?
  2003-07-14 01:23 UTC  nolan@celery.tssi.com
` Re: Improving a simple query?
  2003-07-14 02:31 UTC  Chris Bowlby <chris@pgsql.com>
` Re: Improving a simple query?
  2003-07-14 02:33 UTC  Chris Bowlby <excalibur@hub.org>
  [8+ messages in thread]

[OT] Such incredible h/w (was Re: Dual Xeon + HW RAID question)
  2003-07-12 21:09 UTC  Ron Johnson <ron.l.johnson@cox.net>

force the use of a particular index
  2003-07-10 15:18 UTC  Scott Cain <cain@cshl.org>
` Re: force the use of a particular index
  2003-07-11 10:51 UTC  Rod Taylor <rbt@rbt.ca>
` Re: force the use of a particular index
  2003-07-11 13:17 UTC  Scott Cain <cain@cshl.org>
` Re: force the use of a particular index
  2003-07-11 13:38 UTC  Rod Taylor <rbt@rbt.ca>
` Re: force the use of a particular index
  2003-07-11 15:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: force the use of a particular index
  2003-07-11 15:36 UTC  Scott Cain <cain@cshl.org>
` Re: force the use of a particular index
  2003-07-11 15:38 UTC  Scott Cain <cain@cshl.org>
` Re: force the use of a particular index
  2003-07-11 15:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: force the use of a particular index
  2003-07-11 16:20 UTC  Rod Taylor <rbt@rbt.ca>
` Re: force the use of a particular index
  2003-07-11 17:20 UTC  Scott Cain <cain@cshl.org>
` Re: force the use of a particular index
  2003-07-11 18:14 UTC  Rod Taylor <rbt@rbt.ca>
` Re: force the use of a particular index
  2003-07-11 18:23 UTC  Scott Cain <cain@cshl.org>
  [12+ messages in thread]

pre-Vacuum statistics
  2003-07-10 18:19 UTC  Rich Cullingford <rculling@sysd.com>
` Re: pre-Vacuum statistics
  2003-07-11 10:57 UTC  Rod Taylor <rbt@rbt.ca>
  [2+ messages in thread]

Postgresql General Bits issue
  2003-07-11 10:32 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>

Extreme high load averages
  2003-07-06 04:54 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [PERFORM] Extreme high load averages
  2003-07-06 07:49 UTC  Richard Huxton <dev@archonet.com>
` Re: Extreme high load averages
  2003-07-06 09:44 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Extreme high load averages
  2003-07-06 10:26 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [PERFORM] Extreme high load averages
  2003-07-06 10:31 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: Extreme high load averages
  2003-07-06 10:34 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: [PERFORM] Extreme high load averages
  2003-07-06 15:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Extreme high load averages
  2003-07-06 20:16 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [PERFORM] Extreme high load averages
  2003-07-06 20:28 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [PERFORM] Extreme high load averages
  2003-07-07 04:21 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [PERFORM] Extreme high load averages
  2003-07-07 09:07 UTC  Dennis Björklund <db@zigo.dhs.org>
` Re: Extreme high load averages
  2003-07-07 19:35 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Extreme high load averages
  2003-07-07 23:29 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: Extreme high load averages
  2003-07-08 00:47 UTC  Matthew Nuzum <cobalt@bearfruit.org>
` Re: Extreme high load averages
  2003-07-08 15:26 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: [PERFORM] Extreme high load averages
  2003-07-10 05:37 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [NOVICE] Extreme high load averages
  2003-07-10 06:30 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: [NOVICE] Extreme high load averages
  2003-07-10 06:43 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [NOVICE] Extreme high load averages
  2003-07-10 07:11 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: [PERFORM] Extreme high load averages
  2003-07-10 20:22 UTC  Sean Chittenden <sean@chittenden.org>
` Re: [NOVICE] Extreme high load averages
  2003-07-11 00:23 UTC  Martin Foster <martin@ethereal-realms.org>
` Re: [NOVICE] Extreme high load averages
  2003-07-11 06:09 UTC  Martin Foster <martin@ethereal-realms.org>
  [22+ messages in thread]

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]


[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