pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL HDD Grow capacity
  2003-08-29 03:44 UTC  Eko Pranoto <kopra@wepeka-it.com>
` Re: PostgreSQL HDD Grow capacity
  2003-08-30 16:47 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [2+ messages in thread]

sourcecode for newly release eRServer?
  2003-08-29 17:19 UTC  george young <gry@ll.mit.edu>
` Re: sourcecode for newly release eRServer?
  2003-08-29 18:51 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: sourcecode for newly release eRServer?
  2003-08-30 04:50 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  [3+ messages in thread]

Tests
  2003-08-21 14:51 UTC  Tomka Gergely <tomka@zeus.gau.hu>
` Re: Tests
  2003-08-21 14:59 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Tests
  2003-08-21 16:27 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: Tests
  2003-08-21 17:55 UTC  Tomka Gergely <tomka@zeus.gau.hu>
` Re: Tests
  2003-08-21 18:16 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: Tests
  2003-08-22 20:47 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: Tests
  2003-08-22 20:54 UTC  Tomka Gergely <tomka@zeus.gau.hu>
` Re: Tests
  2003-08-22 21:00 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: Tests
  2003-08-22 22:17 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Tests
  2003-08-22 22:25 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: Tests
  2003-08-22 23:32 UTC  Paul Thomas <paul@tmsl.demon.co.uk>
` Re: Tests
  2003-08-22 23:55 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: Tests
  2003-08-23 00:00 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Tests
  2003-08-23 05:20 UTC  Tomka Gergely <tomka@zeus.gau.hu>
` Re: Tests
  2003-08-25 15:15 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Tests
  2003-08-25 15:23 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: Tests
  2003-08-25 15:27 UTC  Tomka Gergely <tomka@zeus.gau.hu>
` Re: Tests
  2003-08-27 12:40 UTC  Tomka Gergely <tomka@zeus.gau.hu>
` Re: Tests
  2003-08-28 05:24 UTC  Balazs Wellisch <balazs@neusolutions.com>
` Re: Tests
  2003-08-30 04:25 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [20+ messages in thread]

The results of my PostgreSQL/filesystem performance tests
  2003-08-27 01:47 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: The results of my PostgreSQL/filesystem performance tests
  2003-08-28 05:21 UTC  Balazs Wellisch <balazs@neusolutions.com>
` Re: The results of my PostgreSQL/filesystem performance tests
  2003-08-28 06:45 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: The results of my PostgreSQL/filesystem performance
  2003-08-28 08:11 UTC  Dennis Björklund <db@zigo.dhs.org>
` Re: The results of my PostgreSQL/filesystem performance
  2003-08-28 09:19 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: The results of my PostgreSQL/filesystem performance
  2003-08-28 09:23 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: The results of my PostgreSQL/filesystem performance tests
  2003-08-28 11:48 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: The results of my PostgreSQL/filesystem performance tests
  2003-08-28 12:05 UTC  Ludek Finstrle <ludek.finstrle@pzkagis.cz>
` Re: The results of my PostgreSQL/filesystem performance
  2003-08-28 12:25 UTC  Jeff <threshar@torgo.978.org>
` Re: The results of my PostgreSQL/filesystem performance tests
  2003-08-28 13:44 UTC  Rod Taylor <rbt@rbt.ca>
` Re: The results of my PostgreSQL/filesystem performance
  2003-08-28 13:44 UTC  Tomka Gergely <tomka@zeus.gau.hu>
` Re: The results of my PostgreSQL/filesystem performance
  2003-08-28 13:45 UTC  Tomka Gergely <tomka@zeus.gau.hu>
` Re: The results of my PostgreSQL/filesystem performance tests
  2003-08-28 16:12 UTC  Sean Chittenden <sean@chittenden.org>
` Re: The results of my PostgreSQL/filesystem performance tests
  2003-08-28 18:17 UTC  Al Hulaton <ahulaton@commandprompt.com>
` Re: The results of my PostgreSQL/filesystem performance
  2003-08-28 19:16 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: The results of my PostgreSQL/filesystem performance tests
  2003-08-28 19:31 UTC  Sean Chittenden <sean@chittenden.org>
` Re: The results of my PostgreSQL/filesystem performance tests
  2003-08-28 20:20 UTC  Vivek Khera <khera@kcilink.com>
` Re: The results of my PostgreSQL/filesystem performance tests
  2003-08-28 20:27 UTC  Vivek Khera <khera@kcilink.com>
` Re: The results of my PostgreSQL/filesystem performance
  2003-08-28 20:33 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: The results of my PostgreSQL/filesystem performance tests
  2003-08-28 21:49 UTC  Sean Chittenden <sean@chittenden.org>
` Re: The results of my PostgreSQL/filesystem performance
  2003-08-29 01:19 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: The results of my PostgreSQL/filesystem performance
  2003-08-29 01:40 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: The results of my PostgreSQL/filesystem performance tests
  2003-08-29 01:59 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: The results of my PostgreSQL/filesystem performance
  2003-08-29 02:15 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: The results of my PostgreSQL/filesystem performance tests
  2003-08-30 02:32 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: The results of my PostgreSQL/filesystem performance tests
  2003-08-30 02:34 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [26+ messages in thread]

2.4 v/s 2.6 again.
  2003-08-29 16:29 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>

PL/pgSQL functions - text / varchar - havy performance issue?!
  2003-08-29 13:54 UTC  Oliver Siegmar <o.siegmar@vitrado.de>
` Re: PL/pgSQL functions - text / varchar - havy performance
  2003-08-29 14:46 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: PL/pgSQL functions - text / varchar - havy performance issue?!
  2003-08-29 15:01 UTC  Oliver Siegmar <o.siegmar@vitrado.de>
` Re: PL/pgSQL functions - text / varchar - havy performance
  2003-08-29 15:01 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: PL/pgSQL functions - text / varchar - havy performance
  2003-08-29 15:34 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: PL/pgSQL functions - text / varchar - havy performance
  2003-08-29 15:54 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: PL/pgSQL functions - text / varchar - havy performance
  2003-08-29 16:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [7+ messages in thread]

Force table to be permanently in cache?
  2003-08-29 12:52 UTC  Fabian Kreitner <fabian.kreitner@ainea-ag.de>
` Re: Force table to be permanently in cache?
  2003-08-29 14:26 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [2+ messages in thread]

Queries sometimes take 1000 times the normal time
  2003-08-27 23:07 UTC  Anders K. Pedersen <akp@cohaesio.com>
` Re: Queries sometimes take 1000 times the normal time
  2003-08-27 23:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries sometimes take 1000 times the normal time
  2003-08-28 01:14 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Queries sometimes take 1000 times the normal time
  2003-08-28 06:49 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Queries sometimes take 1000 times the normal time
  2003-08-28 09:02 UTC  Russell Garrett <rg@tcslon.com>
` Re: Queries sometimes take 1000 times the normal time
  2003-08-28 09:10 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Queries sometimes take 1000 times the normal time
  2003-08-28 09:28 UTC  Russell Garrett <rg@tcslon.com>
` Re: Queries sometimes take 1000 times the normal time
  2003-08-28 17:59 UTC  Anders K. Pedersen <akp@cohaesio.com>
` Re: Queries sometimes take 1000 times the normal time
  2003-08-28 18:16 UTC  Anders K. Pedersen <akp@cohaesio.com>
` Re: Queries sometimes take 1000 times the normal time
  2003-08-28 18:23 UTC  Anders K. Pedersen <akp@cohaesio.com>
` Re: Queries sometimes take 1000 times the normal time
  2003-08-28 18:33 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Queries sometimes take 1000 times the normal time
  2003-08-28 18:57 UTC  Anders K. Pedersen <akp@cohaesio.com>
` Re: Queries sometimes take 1000 times the normal time
  2003-08-28 20:39 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Queries sometimes take 1000 times the normal time
  2003-08-29 00:49 UTC  Anders K. Pedersen <akp@cohaesio.com>
` Re: Queries sometimes take 1000 times the normal time
  2003-08-29 08:30 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
  [15+ messages in thread]

bad estimates / non-scanning aggregates
  2003-08-29 00:10 UTC  Ken Geis <kgeis@speakeasy.org>
` Re: bad estimates / non-scanning aggregates
  2003-08-29 02:50 UTC  Ken Geis <kgeis@speakeasy.org>
` Re: bad estimates / non-scanning aggregates
  2003-08-29 02:51 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: bad estimates / non-scanning aggregates
  2003-08-29 03:00 UTC  Ken Geis <kgeis@speakeasy.org>
` Re: bad estimates / non-scanning aggregates
  2003-08-29 03:01 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: bad estimates / non-scanning aggregates
  2003-08-29 03:38 UTC  Bruno Wolff III <bruno@wolff.to>
  [6+ messages in thread]

Replication Ideas
  2003-08-24 04:27 UTC  Chris Travers <chris@travelamericas.com>
` Re: Replication Ideas
  2003-08-24 06:13 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: Replication Ideas
  2003-08-25 17:06 UTC  Chris Travers <chris@travelamericas.com>
` Re: Replication Ideas
  2003-08-25 17:38 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: Replication Ideas
  2003-08-25 18:24 UTC  Alvaro Herrera <alvherre@dcc.uchile.cl>
` Re: Replication Ideas
  2003-08-25 18:36 UTC  Chris Travers <chris@travelamericas.com>
` Re: Replication Ideas
  2003-08-25 21:09 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Replication Ideas
  2003-08-25 22:15 UTC  Chris Travers <chris@travelamericas.com>
` Re: Replication Ideas
  2003-08-25 22:28 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: Replication Ideas
  2003-08-26 06:01 UTC  Marc G. Fournier <scrappy@hub.org>
` Re: Replication Ideas
  2003-08-27 01:43 UTC  Jan Wieck <JanWieck@Yahoo.com>
` Re: [GENERAL] Replication Ideas
  2003-08-27 03:25 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: [GENERAL] Replication Ideas
  2003-08-27 03:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] Replication Ideas
  2003-08-27 03:57 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: Replication Ideas
  2003-08-27 04:33 UTC  Dennis Gearon <gearond@fireserve.net>
` Re: Replication Ideas
  2003-08-27 08:12 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: Replication Ideas
  2003-08-27 19:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Replication Ideas
  2003-08-28 07:07 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Replication Ideas
  2003-08-28 21:00 UTC  Jan Wieck <JanWieck@Yahoo.com>
` Re: Replication Ideas
  2003-08-28 22:04 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: Replication Ideas
  2003-08-28 22:52 UTC  Dennis Gearon <gearond@fireserve.net>
` Re: Replication Ideas
  2003-08-29 03:20 UTC  Ron Johnson <ron.l.johnson@cox.net>
  [22+ messages in thread]

Taking another shot at the PostgreSQL/filesystem benchmarks
  2003-08-29 01:08 UTC  Bill Moran <wmoran@potentialtech.com>

Simple queries take forever to run
  2003-08-27 13:55 UTC  Michael Guerin <guerin@rentec.com>
` Simple queries take forever to run
  2003-08-27 21:40 UTC  Michael Guerin <guerin@rentec.com>
` Re: Simple queries take forever to run
  2003-08-28 00:11 UTC  Neil Conway <neilc@samurai.com>
` Re: Simple queries take forever to run
  2003-08-28 01:22 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Simple queries take forever to run
  2003-08-28 01:29 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Simple queries take forever to run
  2003-08-28 14:38 UTC  Michael Guerin <guerin@rentec.com>
` Re: Simple queries take forever to run
  2003-08-28 14:45 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Simple queries take forever to run
  2003-08-28 15:19 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Simple queries take forever to run
  2003-08-28 17:42 UTC  Michael Guerin <guerin@rentec.com>
` Re: Simple queries take forever to run
  2003-08-28 18:49 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: Simple queries take forever to run
  2003-08-28 20:07 UTC  Michael Guerin <guerin@rentec.com>
  [11+ messages in thread]

performance of foreign key constraints
  2003-08-28 17:15 UTC  teknokrat <teknokrat@yahoo.com>
` Re: performance of foreign key constraints
  2003-08-28 17:25 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: performance of foreign key constraints
  2003-08-28 17:28 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: performance of foreign key constraints
  2003-08-28 17:54 UTC  teknokrat <teknokrat@yahoo.com>
` Re: performance of foreign key constraints
  2003-08-28 18:51 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: performance of foreign key constraints
  2003-08-28 18:58 UTC  Rod Taylor <rbt@rbt.ca>
` Re: performance of foreign key constraints
  2003-08-28 19:16 UTC  teknokrat <teknokrat@yahoo.com>
  [7+ messages in thread]

pgsql inserts problem
  2003-08-27 12:50 UTC  Tarhon-Onu Victor <mituc@iasi.rdsnet.ro>
` Re: [PERFORM] pgsql inserts problem
  2003-08-28 03:23 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: [PERFORM] pgsql inserts problem
  2003-08-28 04:01 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: pgsql inserts problem
  2003-08-28 06:29 UTC  Tarhon-Onu Victor <mituc@iasi.rdsnet.ro>
` Re: pgsql inserts problem
  2003-08-28 06:52 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: pgsql inserts problem
  2003-08-28 07:34 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: [PERFORM] pgsql inserts problem
  2003-08-28 12:56 UTC  Richard Huxton <dev@archonet.com>
  [7+ messages in thread]

8 way Intel Xeon system
  2003-08-27 04:07 UTC  Castle, Lindsay <lindsay.castle@eds.com>
` Re: 8 way Intel Xeon system
  2003-08-27 07:00 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: 8 way Intel Xeon system
  2003-08-27 08:56 UTC  Tomka Gergely <tomka@zeus.gau.hu>
` Re: 8 way Intel Xeon system
  2003-08-28 02:49 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: 8 way Intel Xeon system
  2003-08-28 06:55 UTC  Tomka Gergely <tomka@zeus.gau.hu>
  [5+ messages in thread]

Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4
  2003-08-27 15:32 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4
  2003-08-27 23:00 UTC  Neil Conway <neilc@samurai.com>
` Re: Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4
  2003-08-28 06:53 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
  [3+ messages in thread]

Sun vs a P2. Interesting results.
  2003-08-26 12:34 UTC  Jeff <threshar@torgo.978.org>
` Re: Sun vs a P2. Interesting results.
  2003-08-26 17:48 UTC  Darcy Buskermolen <darcy@wavefire.com>
` Re: Sun vs a P2. Interesting results.
  2003-08-26 18:03 UTC  Darcy Buskermolen <darcy@wavefire.com>
` Re: Sun vs a P2. Interesting results.
  2003-08-26 18:41 UTC  Jeff <threshar@torgo.978.org>
` Re: Sun vs a P2. Interesting results.
  2003-08-26 19:01 UTC  Darcy Buskermolen <darcy@wavefire.com>
` Re: Sun vs a P2. Interesting results.
  2003-08-26 19:05 UTC  Jeff <threshar@torgo.978.org>
` Re: Sun vs a P2. Interesting results.
  2003-08-26 19:37 UTC  Neil Conway <neilc@samurai.com>
` Re: Sun vs a P2. Interesting results.
  2003-08-27 06:54 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Sun vs a P2. Interesting results.
  2003-08-27 12:33 UTC  Jeff <threshar@torgo.978.org>
` Re: Sun vs a P2. Interesting results.
  2003-08-27 15:51 UTC  Jeff <threshar@torgo.978.org>
` Re: Sun vs a P2. Interesting results.
  2003-08-28 03:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [11+ messages in thread]

Please scan your computer
  2003-08-27 16:57 UTC  Dennis Gearon <gearond@oit.edu>

Improving simple textsearch?
  2003-08-27 14:36 UTC  Fabian Kreitner <fabian.kreitner@ainea-ag.de>

What is the fastest way to get a resultset
  2003-08-25 19:56 UTC  Bupp Phillips <hello@noname.com>
` Re: What is the fastest way to get a resultset
  2003-08-25 20:37 UTC  Magnus Naeslund(f) <mag@fbab.net>
` Re: What is the fastest way to get a resultset
  2003-08-25 20:46 UTC  Jeff <threshar@torgo.978.org>
` Re: What is the fastest way to get a resultset
  2003-08-26 09:18 UTC  Bupp Phillips <hello@noname.com>
` Re: What is the fastest way to get a resultset
  2003-08-26 18:26 UTC  Neil Conway <neilc@samurai.com>
` Re: What is the fastest way to get a resultset
  2003-08-27 05:56 UTC  Bupp Phillips <hello@noname.com>
  [6+ messages in thread]

Best tweak for fast results.. ?
  2003-08-26 13:42 UTC  JM <jerome@gmanmi.tv>
` Re: [PERFORM] Best tweak for fast results.. ?
  2003-08-26 17:11 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: [PERFORM] Best tweak for fast results.. ?
  2003-08-26 17:25 UTC  Dennis Gearon <gearond@fireserve.net>
` Re: Best tweak for fast results.. ?
  2003-08-26 17:44 UTC  Richard Huxton <dev@archonet.com>
` Re: Best tweak for fast results.. ?
  2003-08-26 22:10 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [5+ messages in thread]

Mail delivery failed: returning message to sender
  2003-08-23 07:54 UTC  Mail Delivery System <Mailer-Daemon@lists.sourceforge.net>

Sorting a query on a view ignores an index
  2003-08-21 13:35 UTC  Mathieu De Zutter <mathieu@dezutter.org>
` Re: Sorting a query on a view ignores an index
  2003-08-21 14:59 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sorting a query on a view ignores an index
  2003-08-21 16:24 UTC  Mathieu De Zutter <mathieu@dezutter.org>
` Re: Sorting a query on a view ignores an index
  2003-08-21 17:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sorting a query on a view ignores an index
  2003-08-21 20:11 UTC  Your Name <cbbrowne@cbbrowne.com>
` Re: Sorting a query on a view ignores an index
  2003-08-21 20:56 UTC  Mathieu De Zutter <mathieu@dezutter.org>
` Re: Sorting a query on a view ignores an index
  2003-08-22 10:11 UTC  alvis@piladzi-2.biz
  [7+ messages in thread]

A better look on the same problem (ignored index)
  2003-08-21 14:06 UTC  Mathieu De Zutter <mathieu@dezutter.org>

More connections in Solaris9
  2003-08-21 11:56 UTC  Tam MK <mktam@dg21.com>


[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