pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Pgbench results
  2003-12-06 17:09 UTC  Rob Sell <lists@facnd.com>

Has anyone run on the new G5 yet
  2003-12-03 21:40 UTC  Sean Shanny <shannyconsulting@earthlink.net>
` Re: Has anyone run on the new G5 yet
  2003-12-03 21:54 UTC  Sean Shanny <shannyconsulting@earthlink.net>
` Re: Has anyone run on the new G5 yet
  2003-12-03 22:12 UTC  Eric Soroos <eric-psql@soroos.net>
` Re: Has anyone run on the new G5 yet
  2003-12-03 22:35 UTC  Fred Moyer <fred@redhotpenguin.com>
` Re: Has anyone run on the new G5 yet
  2003-12-03 23:50 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: Has anyone run on the new G5 yet
  2003-12-04 00:24 UTC  Sean Shanny <shannyconsulting@earthlink.net>
` Re: Has anyone run on the new G5 yet
  2003-12-04 08:24 UTC  Paul Tuckfield <paul@tuckfield.com>
` Re: Has anyone run on the new G5 yet
  2003-12-04 17:06 UTC  William Yu <wyu@talisys.com>
` Re: Has anyone run on the new G5 yet
  2003-12-06 13:19 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [9+ messages in thread]

Slightly OT -- Xeon versus Opteron Comparison
  2003-12-05 19:06 UTC  William Yu <wyu@talisys.com>

Index not used. WHY?
  2003-12-04 14:57 UTC  Andrei Bintintan <klodoma@ar-sd.net>
` Re: Index not used. WHY?
  2003-12-04 15:19 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: [ADMIN] Index not used. WHY?
  2003-12-05 08:11 UTC  Andrei Bintintan <klodoma@ar-sd.net>
` Re: [ADMIN] Index not used. WHY?
  2003-12-05 08:39 UTC  Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
` Re: [ADMIN] Index not used. WHY?
  2003-12-05 15:34 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [5+ messages in thread]

Minimum hardware requirements for Postgresql db
  2003-12-03 02:22 UTC  CHEWTC@ap.nec.com.sg
` Re: Minimum hardware requirements for Postgresql db
  2003-12-03 04:44 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Minimum hardware requirements for Postgresql db
  2003-12-03 18:22 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Minimum hardware requirements for Postgresql db
  2003-12-03 19:23 UTC  Greg Stark <gsstark@mit.edu>
` Re: Minimum hardware requirements for Postgresql db
  2003-12-03 19:31 UTC  Al Hulaton <ahulaton@commandprompt.com>
` Re: Minimum hardware requirements for Postgresql db
  2003-12-04 03:09 UTC  CHEWTC@ap.nec.com.sg
` Re: Minimum hardware requirements for Postgresql db
  2003-12-04 13:10 UTC  Christopher Browne <cbbrowne@acm.org>
  [7+ messages in thread]

Async Query Processing on Solaris
  2003-12-04 06:22 UTC  Passynkov, Vadim <Vadim.Passynkov@pathcom.com>
` Async Query Processing on Solaris
  2003-12-04 12:48 UTC  Passynkov, Vadim <Vadim.Passynkov@pathcom.com>
  [2+ messages in thread]

A question on the query planner
  2003-12-01 21:44 UTC  Jared Carr <jared@89glass.com>
` Re: A question on the query planner
  2003-12-02 00:45 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: A question on the query planner
  2003-12-02 17:16 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: A question on the query planner
  2003-12-02 17:55 UTC  Jared Carr <jared@89glass.com>
` Re: A question on the query planner
  2003-12-02 18:59 UTC  Greg Stark <gsstark@mit.edu>
` Re: A question on the query planner
  2003-12-02 19:14 UTC  Jared Carr <jared@89glass.com>
` Re: A question on the query planner
  2003-12-02 20:11 UTC  Greg Stark <gsstark@mit.edu>
` Re: A question on the query planner
  2003-12-02 20:29 UTC  Jared Carr <jared@89glass.com>
` Re: A question on the query planner
  2003-12-02 22:32 UTC  Greg Stark <gsstark@mit.edu>
` Re: A question on the query planner
  2003-12-02 22:43 UTC  Greg Stark <gsstark@mit.edu>
` Re: A question on the query planner
  2003-12-02 23:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: A question on the query planner
  2003-12-03 01:33 UTC  Greg Stark <gsstark@mit.edu>
` Re: A question on the query planner
  2003-12-03 03:53 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: A question on the query planner
  2003-12-03 17:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: A question on the query planner
  2003-12-03 18:27 UTC  Jared Carr <jared@89glass.com>
` Re: A question on the query planner
  2003-12-03 19:32 UTC  Greg Stark <gsstark@mit.edu>
` Re: A question on the query planner
  2003-12-03 23:17 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: A question on the query planner
  2003-12-03 23:21 UTC  Jared Carr <jared@89glass.com>
` Re: A question on the query planner
  2003-12-03 23:54 UTC  Gaetano Mendola <mendola@bigfoot.com>
  [19+ messages in thread]

sequence overhead
  2003-12-03 22:32 UTC  Robert Treat <xzilla@users.sourceforge.net>

Re: Update performance ... Recommended configuration changes?
  2003-12-03 21:22 UTC  erik@norvelle.net
` Re: Update performance ... Recommended configuration
  2003-12-03 21:33 UTC  Rod Taylor <pg@rbt.ca>
  [2+ messages in thread]

Slow UPDATE, INSERT OK
  2003-12-03 18:29 UTC  Ivar Zarans <iff@alcaron.ee>

cross table indexes or something?
  2003-11-26 20:14 UTC  Jeremiah Jahn <jeremiah@cs.earlham.edu>
` Re: cross table indexes or something?
  2003-11-26 22:23 UTC  Marc A. Leith <marc@redboxdata.com>
` Re: cross table indexes or something?
  2003-11-26 22:32 UTC  Hannu Krosing <hannu@tm.ee>
` Re: cross table indexes or something?
  2003-12-01 14:29 UTC  Jeremiah Jahn <jeremiah@cs.earlham.edu>
` Re: cross table indexes or something?
  2003-12-01 15:59 UTC  Richard Huxton <dev@archonet.com>
` Re: cross table indexes or something?
  2003-12-01 16:24 UTC  Arjen van der Meijden <acmmailing@vulcanus.its.tudelft.nl>
` Re: cross table indexes or something?
  2003-12-01 19:47 UTC  Josh Berkus <josh@agliodbs.com>
` Re: cross table indexes or something?
  2003-12-02 19:08 UTC  Jeremiah Jahn <jeremiah@cs.earlham.edu>
` Re: cross table indexes or something?
  2003-12-02 19:27 UTC  Josh Berkus <josh@agliodbs.com>
` Re: cross table indexes or something?
  2003-12-02 21:57 UTC  Neil Conway <neilc@samurai.com>
` Re: cross table indexes or something?
  2003-12-02 23:04 UTC  Josh Berkus <josh@agliodbs.com>
` Re: cross table indexes or something?
  2003-12-02 23:37 UTC  Neil Conway <neilc@samurai.com>
` Re: cross table indexes or something?
  2003-12-03 01:50 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: cross table indexes or something?
  2003-12-03 02:04 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [14+ messages in thread]

Re: [linux-lvm] RE: [PERFORM] backup/restore - another
  2003-10-30 17:28 UTC  CLeon@phs.org
` Re: [linux-lvm] RE: [PERFORM] backup/restore - another
  2003-12-02 18:11 UTC  Murthy Kambhampaty <murthy.kambhampaty@goeci.com>
  [2+ messages in thread]

Update performance ... is 200, 000 updates per hour what I should expect?
  2003-12-02 15:53 UTC  Erik Norvelle <erik@norvelle.net>
` Re: Update performance ... is 200,000 updates per hour
  2003-12-02 16:29 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Update performance ... is 200, 000 updates per hour what I should expect?
  2003-12-02 16:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Update performance ... is 200, 000 updates per hour what I should expect?
  2003-12-02 16:40 UTC  Greg Stark <gsstark@mit.edu>
  [4+ messages in thread]

Is clustering possible to enhance the performance?
  2003-12-01 22:27 UTC  LIANHE SHAO <lshao2@jhmi.edu>
` Re: Is clustering possible to enhance the performance?
  2003-12-01 22:37 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [2+ messages in thread]

Followup - expression (functional) index use in joins
  2003-11-26 18:39 UTC  Roger Ging <rging@paccomsys.com>
` Re: Followup - expression (functional) index use in joins
  2003-11-26 19:12 UTC  Richard Huxton <dev@archonet.com>
` Re: Followup - expression (functional) index use in joins
  2003-11-26 21:29 UTC  Roger Ging <rging@paccomsys.com>
` Re: Followup - expression (functional) index use in joins
  2003-11-27 00:09 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Followup - expression (functional) index use in joins
  2003-12-01 17:14 UTC  Roger Ging <roger@musicreports.com>
` Re: Followup - expression (functional) index use in joins
  2003-12-01 17:31 UTC  Roger Ging <rging@paccomsys.com>
` Re: Followup - expression (functional) index use in joins
  2003-12-01 18:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [7+ messages in thread]

Dump restoration via archive files
  2003-12-01 10:17 UTC  Kamalraj Singh Madhan <kamalr@networkprograms.com>
` Re: Dump restoration via archive files
  2003-12-01 14:16 UTC  Jeff <threshar@torgo.978.org>
` Re: Dump restoration via archive files
  2003-12-01 15:23 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [3+ messages in thread]

My indexes aren't being used (according to EXPLAIN)
  2003-12-01 13:40 UTC  Erik Norvelle <erik@norvelle.net>
` Re: My indexes aren't being used (according to EXPLAIN)
  2003-12-01 14:04 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: My indexes aren't being used (according to EXPLAIN)
  2003-12-01 15:11 UTC  Erik Norvelle <erik@norvelle.net>
  [3+ messages in thread]

Various Questions
  2003-12-01 13:01 UTC  Evil Azrael <root@evilazrael.ath.cx>
` Various Questions
  2003-12-01 13:07 UTC  Evil Azrael <evilazrael@evilazrael.de>
` Re: Various Questions
  2003-12-01 13:26 UTC  Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
` Re: Various Questions
  2003-12-01 14:00 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [4+ messages in thread]

For full text indexing, which is better, tsearch2 or fulltextindex
  2003-11-26 20:06 UTC  LIANHE SHAO <lshao2@jhmi.edu>
` Re: For full text indexing, which is better, tsearch2 or
  2003-11-27 00:51 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: For full text indexing, which is better, tsearch2 or
  2003-11-27 01:03 UTC  Dror Matalon <dror@zapatec.com>
` Re: For full text indexing, which is better, tsearch2 or
  2003-11-27 03:28 UTC  Steve Atkins <steve@blighty.com>
` Re: For full text indexing, which is better, tsearch2 or
  2003-11-27 04:41 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: For full text indexing, which is better, tsearch2 or
  2003-11-27 05:12 UTC  Steve Atkins <steve@blighty.com>
` Re: For full text indexing, which is better, tsearch2 or
  2003-11-28 05:04 UTC  Steve Atkins <steve@blighty.com>
` Re: For full text indexing, which is better, tsearch2 or
  2003-11-28 05:18 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: For full text indexing, which is better, tsearch2 or
  2003-11-28 05:26 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: For full text indexing, which is better, tsearch2 or
  2003-11-28 20:37 UTC  Steve Atkins <steve@blighty.com>
` Re: For full text indexing, which is better, tsearch2 or
  2003-11-30 09:46 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [11+ messages in thread]

simple left join slows query more than expected
  2003-11-28 05:58 UTC  Jonathan Knopp <jknopp@delegated.net>
` Re: simple left join slows query more than expected
  2003-11-28 17:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Impossibly slow DELETEs
  2003-11-25 21:56 UTC  Stefan Champailler <schampailler@easynet.be>
` Re: Impossibly slow DELETEs
  2003-11-25 23:45 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: Impossibly slow DELETEs
  2003-11-25 23:55 UTC  Neil Conway <neilc@samurai.com>
` Re: Impossibly slow DELETEs
  2003-11-26 00:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Impossibly slow DELETEs
  2003-11-26 17:11 UTC  Greg Stark <gsstark@mit.edu>
` Re: Impossibly slow DELETEs
  2003-11-27 19:57 UTC  Stefan Champailler <schampailler@easynet.be>
  [6+ messages in thread]

Maximum Possible Insert Performance?
  2003-11-24 03:48 UTC  William Yu <wyu@talisys.com>
` Re: Maximum Possible Insert Performance?
  2003-11-24 04:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Maximum Possible Insert Performance?
  2003-11-24 04:29 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Maximum Possible Insert Performance?
  2003-11-24 04:40 UTC  Joe Conway <mail@joeconway.com>
` Re: Maximum Possible Insert Performance?
  2003-11-24 05:50 UTC  Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
` Re: Maximum Possible Insert Performance?
  2003-11-24 13:38 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: Maximum Possible Insert Performance?
  2003-11-24 17:19 UTC  William Yu <wyu@talisys.com>
` Re: Maximum Possible Insert Performance?
  2003-11-24 17:25 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Maximum Possible Insert Performance?
  2003-11-24 17:45 UTC  William Yu <wyu@talisys.com>
` Re: Maximum Possible Insert Performance?
  2003-11-24 18:04 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Maximum Possible Insert Performance?
  2003-11-24 18:23 UTC  William Yu <wyu@talisys.com>
` Re: Maximum Possible Insert Performance?
  2003-11-25 01:16 UTC  Greg Stark <gsstark@mit.edu>
` Re: Maximum Possible Insert Performance?
  2003-11-25 06:06 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Maximum Possible Insert Performance?
  2003-11-25 15:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Maximum Possible Insert Performance?
  2003-11-25 18:59 UTC  Suchandra Thapa <ssthapa@netzero.com>
` Re: Maximum Possible Insert Performance?
  2003-11-26 16:44 UTC  William Yu <wyu@talisys.com>
` Re: Maximum Possible Insert Performance?
  2003-11-26 17:55 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Maximum Possible Insert Performance?
  2003-11-26 18:03 UTC  William Yu <wyu@talisys.com>
` Re: Maximum Possible Insert Performance?
  2003-11-26 18:54 UTC  Dror Matalon <dror@zapatec.com>
  [19+ messages in thread]

expression (functional) index use in joins
  2003-11-26 16:38 UTC  Roger Ging <rging@paccomsys.com>
` Re: expression (functional) index use in joins
  2003-11-26 17:52 UTC  Richard Huxton <dev@archonet.com>
  [2+ messages in thread]

why index scan not working when using 'like'?
  2003-11-25 19:48 UTC  LIANHE SHAO <lshao2@jhmi.edu>
` Re: why index scan not working when using 'like'?
  2003-11-25 19:51 UTC  Josh Berkus <josh@agliodbs.com>
` Re: why index scan not working when using 'like'?
  2003-11-25 19:56 UTC  Dror Matalon <dror@zapatec.com>
` Re: why index scan not working when using 'like'?
  2003-11-25 21:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: why index scan not working when using 'like'?
  2003-11-26 17:33 UTC  Hannu Krosing <hannu@tm.ee>
  [5+ messages in thread]

Re: Optimize
  2003-11-24 20:20 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Optimize
  2003-11-24 20:48 UTC  Torsten Schulz <comic@be-a-part.de>
` Re: Optimize
  2003-11-24 20:56 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: Optimize
  2003-11-24 21:33 UTC  Torsten Schulz <comic@be-a-part.de>
` Re: Optimize
  2003-11-24 21:45 UTC  Dennis Bjorklund <db@zigo.dhs.org>
` Re: Optimize
  2003-11-25 02:24 UTC  Neil Conway <neilc@samurai.com>
` Re: Optimize
  2003-11-25 22:07 UTC  Torsten Schulz <comic@be-a-part.de>
` Re: Optimize
  2003-11-26 06:06 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
  [8+ 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