pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedNOT 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