pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
NOT IN query takes forever
  2004-08-03 08:49 UTC  Marius Andreiana <mandreiana@rdslink.ro>
` Re: NOT IN query takes forever
  2004-08-03 12:05 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: NOT IN query takes forever
  2004-08-03 14:03 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: NOT IN query takes forever
  2004-08-03 14:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: NOT IN query takes forever
  2004-08-03 16:02 UTC  Marius Andreiana <mandreiana@rdslink.ro>
` Re: NOT IN query takes forever
  2004-08-03 16:10 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: NOT IN query takes forever
  2004-08-03 17:28 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: NOT IN query takes forever
  2004-08-03 18:26 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: NOT IN query takes forever
  2004-08-04 01:32 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [PERFORM] NOT IN query takes forever
  2004-08-04 05:40 UTC  Marius Andreiana <mandreiana@rdslink.ro>
  [10+ messages in thread]

pg_autovacuum parameters
  2004-08-03 09:09 UTC  Lending, Rune <rune.lending@inpoc.com>
` Re: pg_autovacuum parameters
  2004-08-03 14:19 UTC  Matthew T. O'Connor <matthew@zeut.net>
` Re: pg_autovacuum parameters
  2004-08-03 15:54 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [3+ messages in thread]

my boss want to migrate to ORACLE
  2004-07-28 17:08 UTC  Stephane Tessier <stephane.tessier@abovesecurity.com>
` Re: my boss want to migrate to ORACLE
  2004-07-30 01:21 UTC  Russell Smith <mr-russ@pws.com.au>
` Re: my boss want to migrate to ORACLE
  2004-07-30 02:33 UTC  markir@coretech.co.nz
` Re: my boss want to migrate to ORACLE
  2004-07-30 02:59 UTC  markir@coretech.co.nz
` Re: my boss want to migrate to ORACLE
  2004-07-30 12:33 UTC  Jeff <threshar@torgo.978.org>
` Re: my boss want to migrate to ORACLE
  2004-07-30 13:56 UTC  Stephane Tessier <stephane.tessier@abovesecurity.com>
` Re: my boss want to migrate to ORACLE
  2004-07-30 14:13 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: my boss want to migrate to ORACLE
  2004-07-30 15:14 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: my boss want to migrate to ORACLE
  2004-07-30 17:56 UTC  Matthew T. O'Connor <matthew@zeut.net>
` Re: my boss want to migrate to ORACLE
  2004-07-30 18:11 UTC  Dan Langille <dan@langille.org>
` Re: my boss want to migrate to ORACLE
  2004-07-30 18:29 UTC  Brian Hirt <bhirt@mobygames.com>
` Re: my boss want to migrate to ORACLE
  2004-07-31 01:22 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: my boss want to migrate to ORACLE
  2004-07-31 04:14 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: my boss want to migrate to ORACLE
  2004-08-01 19:13 UTC  Mischa Sandberg <mischa_sandberg@telus.net>
` Re: my boss want to migrate to ORACLE
  2004-08-02 21:18 UTC  Stephane Tessier <stephane.tessier@abovesecurity.com>
` Re: my boss want to migrate to ORACLE
  2004-08-02 21:30 UTC  Stephane Tessier <stephane.tessier@abovesecurity.com>
` Re: my boss want to migrate to ORACLE
  2004-08-02 21:32 UTC  James Thornton <james@jamesthornton.com>
` Re: my boss want to migrate to ORACLE
  2004-08-02 22:47 UTC  markir@coretech.co.nz
` Re: my boss want to migrate to ORACLE
  2004-08-03 00:17 UTC  Scott Marlowe <smarlowe@qwest.net>
  [19+ messages in thread]

Page Miss Hits
  2004-08-02 08:11 UTC  Ioannis Theoharis <theohari@ics.forth.gr>
` Re: Page Miss Hits
  2004-08-02 16:19 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: Page Miss Hits
  2004-08-02 16:43 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: Page Miss Hits
  2004-08-02 20:50 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: Page Miss Hits
  2004-08-02 21:26 UTC  Rod Taylor <pg@rbt.ca>
` Re: Page Miss Hits
  2004-08-02 22:13 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [6+ messages in thread]

What kind of performace can I expect and how to measure?
  2004-08-02 12:21 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: What kind of performace can I expect and how to measure?
  2004-08-02 12:33 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: What kind of performace can I expect and how to measure?
  2004-08-02 12:47 UTC  Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
` Re: What kind of performace can I expect and how to measure?
  2004-08-02 14:14 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: What kind of performace can I expect and how to
  2004-08-02 16:11 UTC  Scott Marlowe <smarlowe@qwest.net>
  [5+ messages in thread]

No index usage with "left join"
  2004-08-02 12:08 UTC  mailing@impactmedia.de
` Re: No index usage with "left join"
  2004-08-02 12:16 UTC  Leeuw van der, Tim <tim.leeuwvander@nl.unisys.com>
` Re: No index usage with "left join"
  2004-08-02 12:45 UTC  Rod Taylor <pg@rbt.ca>
` Re: No index usage with "left join"
  2004-08-02 14:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: No index usage with "left join"
  2004-08-02 16:08 UTC  Scott Marlowe <smarlowe@qwest.net>
  [5+ messages in thread]

SSD Drives
  2004-08-01 11:42 UTC  Greg Stark <gsstark@mit.edu>
` Re: SSD Drives
  2004-08-02 15:02 UTC  jason.servetar@ccgenesis.com
  [2+ messages in thread]

Re: No index usage with
  2004-08-02 12:38 UTC  G u i d o B a r o s i o <gbarosio@uolsinectis.com.ar>
` Re: No index usage with
  2004-08-02 12:47 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [2+ messages in thread]

Optimizer refuses to hash join
  2004-07-27 19:38 UTC  Stan Bielski <bielski@ece.cmu.edu>
` Re: Optimizer refuses to hash join
  2004-07-29 16:08 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Optimizer refuses to hash join
  2004-07-29 17:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimizer refuses to hash join
  2004-07-30 16:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

Index works with foo.val=bar.val but not foo.val<=bar.val
  2004-07-29 21:04 UTC  8lhhxba02@sneakemail.com

best way to fetch next/prev record based on index
  2004-07-27 13:07 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: best way to fetch next/prev record based on index
  2004-07-27 14:13 UTC  Markus Schaber <schabios@logi-track.com>
` Re: best way to fetch next/prev record based on index
  2004-07-27 14:21 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: best way to fetch next/prev record based on index
  2004-07-27 14:36 UTC  Rod Taylor <pg@rbt.ca>
` Re: best way to fetch next/prev record based on index
  2004-07-27 14:50 UTC  Markus Schaber <schabios@logi-track.com>
` Re: best way to fetch next/prev record based on index
  2004-07-27 15:03 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: best way to fetch next/prev record based on index
  2004-07-27 15:14 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: best way to fetch next/prev record based on index
  2004-07-27 15:29 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: best way to fetch next/prev record based on index
  2004-07-27 15:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: best way to fetch next/prev record based on index
  2004-07-27 15:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: best way to fetch next/prev record based on index
  2004-07-27 16:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: best way to fetch next/prev record based on index
  2004-07-27 16:02 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: best way to fetch next/prev record based on index
  2004-07-27 17:12 UTC  Greg Stark <gsstark@mit.edu>
` Re: best way to fetch next/prev record based on index
  2004-07-27 17:28 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: best way to fetch next/prev record based on index
  2004-07-27 17:37 UTC  andrew@pillette.com
` best way to fetch next/prev record based on index
  2004-07-27 18:17 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: best way to fetch next/prev record based on index
  2004-07-27 18:38 UTC  Greg Stark <gsstark@mit.edu>
` Re: best way to fetch next/prev record based on index
  2004-07-27 19:20 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: best way to fetch next/prev record based on index
  2004-07-28 03:45 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: best way to fetch next/prev record based on index
  2004-07-28 05:53 UTC  Greg Stark <gsstark@mit.edu>
` Re: best way to fetch next/prev record based on index
  2004-07-28 07:14 UTC  Greg Stark <gsstark@mit.edu>
` Re: best way to fetch next/prev record based on index
  2004-07-28 12:47 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: best way to fetch next/prev record based on index
  2004-07-28 14:07 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: best way to fetch next/prev record based on index
  2004-07-28 15:38 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: best way to fetch next/prev record based on index
  2004-07-28 16:00 UTC  Greg Stark <gsstark@mit.edu>
` Re: best way to fetch next/prev record based on index
  2004-07-28 16:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: best way to fetch next/prev record based on index
  2004-07-28 22:54 UTC  Greg Stark <gsstark@mit.edu>
` Re: best way to fetch next/prev record based on index
  2004-07-28 23:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: best way to fetch next/prev record based on index
  2004-07-29 16:48 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: best way to fetch next/prev record based on index
  2004-07-29 17:57 UTC  Greg Stark <gsstark@mit.edu>
` Re: best way to fetch next/prev record based on index
  2004-07-29 18:23 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: best way to fetch next/prev record based on index
  2004-07-29 18:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: best way to fetch next/prev record based on index
  2004-07-29 18:49 UTC  Greg Stark <gsstark@mit.edu>
` Re: best way to fetch next/prev record based on index
  2004-07-29 20:11 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
  [34+ messages in thread]

Extremely slow query...
  2004-07-29 15:54 UTC  pathat@comcast.net

Correction of best way to fetch next/prev record based on index
  2004-07-27 14:21 UTC  Markus Schaber <schabios@logi-track.com>

Little understanding for tuning ...
  2004-07-27 07:35 UTC  Hervé Piedvache <herve@elma.fr>

arrays and indexes
  2004-07-26 04:57 UTC  Ross J. Reedstrom <reedstrm@rice.edu>
` Re: arrays and indexes
  2004-07-26 06:27 UTC  Greg Stark <gsstark@mit.edu>
` Re: arrays and indexes
  2004-07-26 14:56 UTC  Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: arrays and indexes
  2004-07-26 18:47 UTC  Ross J. Reedstrom <reedstrm@rice.edu>
` Re: arrays and indexes
  2004-07-26 20:35 UTC  Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
` Re: arrays and indexes
  2004-07-26 20:40 UTC  Greg Stark <gsstark@mit.edu>
` Re: arrays and indexes
  2004-07-26 21:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: arrays and indexes
  2004-07-27 04:32 UTC  Greg Stark <gsstark@mit.edu>
  [8+ messages in thread]

Insert are going slower ...
  2004-07-13 16:50 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Insert are going slower ...
  2004-07-13 17:10 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Insert are going slower ...
  2004-07-13 23:42 UTC  Hervé Piedvache <footcow@noos.fr>
` Re: Insert are going slower ...
  2004-07-14 10:06 UTC  gnari <gnari@simnet.is>
` Re: Insert are going slower ...
  2004-07-14 10:13 UTC  Shridhar Daithankar <shridhar@frodo.hserus.net>
` Re: Insert are going slower ...
  2004-07-14 14:08 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Insert are going slower ...
  2004-07-14 14:32 UTC  Shridhar Daithankar <shridhar@frodo.hserus.net>
` Re: Insert are going slower ...
  2004-07-14 16:28 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Insert are going slower ...
  2004-07-14 21:19 UTC  Hervé Piedvache <footcow@noos.fr>
` Re: Insert are going slower ...
  2004-07-14 21:32 UTC  Hervé Piedvache <footcow@noos.fr>
` Re: Insert are going slower ...
  2004-07-15 06:21 UTC  Shridhar Daithankar <shridhar@frodo.hserus.net>
` Re: Insert are going slower ...
  2004-07-15 18:09 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Insert are going slower ...
  2004-07-16 11:17 UTC  Hervé Piedvache <herve@elma.fr>
` Re: Insert are going slower ...
  2004-07-18 17:23 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Insert are going slower ...
  2004-07-26 14:12 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: Insert are going slower ...
  2004-07-26 14:20 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: Insert are going slower ...
  2004-07-26 16:25 UTC  Scott Marlowe <smarlowe@qwest.net>
  [17+ messages in thread]

hardware raid suggestions
  2004-07-15 18:07 UTC  Brian Hirt <bhirt@mobygames.com>
` Re: hardware raid suggestions
  2004-07-16 02:55 UTC  Josh Berkus <josh@agliodbs.com>
` Re: hardware raid suggestions
  2004-07-16 03:25 UTC  Mark Aufflick <mark@pumptheory.com>
` Re: hardware raid suggestions
  2004-07-17 03:20 UTC  Fred Moyer <fred@redhotpenguin.com>
` Re: hardware raid suggestions
  2004-07-26 14:01 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [5+ messages in thread]

Wrong index choosen?
  2004-07-23 08:26 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: Wrong index choosen?
  2004-07-23 12:01 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: Wrong index choosen?
  2004-07-23 14:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [HACKERS] Wrong index choosen?
  2004-07-23 17:41 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: [HACKERS] Wrong index choosen?
  2004-07-23 18:12 UTC  Matthew T. O'Connor <matthew@zeut.net>
` Re: [HACKERS] Wrong index choosen?
  2004-07-23 21:51 UTC  Jaime Casanova <systemguards@yahoo.com>
` Re: [HACKERS] Wrong index choosen?
  2004-07-23 22:02 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: [HACKERS] Wrong index choosen?
  2004-07-24 00:07 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: [HACKERS] Wrong index choosen?
  2004-07-24 01:49 UTC  Matthew T. O'Connor <matthew@zeut.net>
  [9+ messages in thread]

variable length - user defined types/storage place
  2004-07-23 21:28 UTC  martin.bokler@web.de

Performance over a LAN
  2004-07-23 05:50 UTC  William Carney <wcarney@sa.quiktrak.com.au>
` Re: Performance over a LAN
  2004-07-23 06:02 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Performance over a LAN
  2004-07-23 06:20 UTC  Mark Aufflick <mark@pumptheory.com>
` Re: Performance over a LAN
  2004-07-23 06:29 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: Performance over a LAN
  2004-07-23 07:57 UTC  William Carney <wcarney@sa.quiktrak.com.au>
` Re: Performance over a LAN
  2004-07-23 11:43 UTC  Rod Taylor <pg@rbt.ca>
` Re: Performance over a LAN
  2004-07-23 12:07 UTC  Jeff <threshar@torgo.978.org>
` Re: Performance over a LAN
  2004-07-23 15:34 UTC  Michael Adler <adler@pobox.com>
` Re: Performance over a LAN
  2004-07-23 16:26 UTC  Gary Cowell <gary_cowell@yahoo.co.uk>
` Re: Performance over a LAN
  2004-07-23 17:09 UTC  Greg Stark <gsstark@mit.edu>
  [10+ messages in thread]

Beowulf Cluster & Postgresql?
  2004-07-21 20:45 UTC  joe <joe@avsupport.com>
` Re: Beowulf Cluster & Postgresql?
  2004-07-21 21:08 UTC  Scott Marlowe <smarlowe@qwest.net>
` Re: Beowulf Cluster & Postgresql?
  2004-07-22 02:47 UTC  Mark Kirkwood <markir@coretech.co.nz>
  [3+ messages in thread]

extrem bad performance
  2004-07-15 10:24 UTC  Stefan <bekraenzter@yahoo.com>
` Re: extrem bad performance
  2004-07-17 02:31 UTC  Rod Taylor <pg@rbt.ca>
` Re: extrem bad performance
  2004-07-21 16:25 UTC  Stefan <bekraenzter@yahoo.com>
  [3+ messages in thread]

Odd sorting behaviour
  2004-07-05 09:18 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Odd sorting behaviour
  2004-07-08 10:19 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Odd sorting behaviour
  2004-07-14 23:11 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Odd sorting behaviour
  2004-07-15 01:41 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Odd sorting behaviour
  2004-07-15 04:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Odd sorting behaviour
  2004-07-15 12:08 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Odd sorting behaviour
  2004-07-15 18:11 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Odd sorting behaviour
  2004-07-15 22:16 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Odd sorting behaviour
  2004-07-20 11:51 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Odd sorting behaviour
  2004-07-20 17:02 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Odd sorting behaviour
  2004-07-20 17:06 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Odd sorting behaviour
  2004-07-20 17:21 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Odd sorting behaviour
  2004-07-21 02:18 UTC  Rod Taylor <pg@rbt.ca>
` Re: Odd sorting behaviour
  2004-07-21 10:04 UTC  Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Odd sorting behaviour
  2004-07-21 14:58 UTC  Rod Taylor <pg@rbt.ca>
  [15+ messages in thread]

Unbearably slow cascading deletes
  2004-07-20 19:19 UTC  andrew@pillette.com
` Re: Unbearably slow cascading deletes
  2004-07-20 19:45 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Unbearably slow cascading deletes
  2004-07-20 19:55 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Unbearably slow cascading deletes
  2004-07-20 19:59 UTC  andrew@pillette.com
` Re: Unbearably slow cascading deletes
  2004-07-20 20:06 UTC  andrew@pillette.com
` Re: Unbearably slow cascading deletes
  2004-07-21 01:37 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [6+ messages in thread]

Re: Réf. : Re: NAS, SAN or any
  2004-07-20 15:28 UTC  Scott Marlowe <smarlowe@qwest.net>


[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