pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Performance related to size of tables
  2003-12-12 18:04 UTC  nbarraza@uolsinectis.com.ar
` Re: Performance related to size of tables
  2003-12-12 21:11 UTC  Mark Kirkwood <markir@paradise.net.nz>
  [2+ messages in thread]

ODBC Driver generates a too big "windows swap file" and it's too slow
  2003-12-12 12:39 UTC  Rhaoni Chiu Pereira <rhaoni@sistemica.info>
` Re: ODBC Driver generates a too big "windows swap file" and
  2003-12-12 15:48 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [2+ messages in thread]

Measuring execution time for sql called from PL/pgSQL
  2003-12-12 01:17 UTC  Aram Kananov <aram@kananov.com>
` Re: Measuring execution time for sql called from PL/pgSQL
  2003-12-12 01:50 UTC  David Shadovitz <david@www.shadovitz.com>
` Re: Measuring execution time for sql called from PL/pgSQL
  2003-12-12 07:46 UTC  Tomasz Myrta <jasiek@klaster.net>
  [3+ messages in thread]

Performance problems with a higher number of clients
  2003-12-11 04:13 UTC  Alfranio Correia Junior <alfranio@lsd.di.uminho.pt>
` Re: Performance problems with a higher number of clients
  2003-12-11 06:36 UTC  Shridhar Daithankar <shridhar_daithankar@myrealbox.com>
` Re: Performance problems with a higher number of clients
  2003-12-11 13:28 UTC  Jeff <threshar@torgo.978.org>
` Re: Performance problems with a higher number of clients
  2003-12-11 14:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance problems with a higher number of clients
  2003-12-12 02:35 UTC  Alfranio Tavares Correia Junior <alfranio@lsd.di.uminho.pt>
  [5+ messages in thread]

hints in Postgres?
  2003-12-11 16:00 UTC  sandra ruiz <mileruiz@hotmail.com>
` Re: hints in Postgres?
  2003-12-11 16:22 UTC  Pavel Stehule <stehule@kix.fsv.cvut.cz>
` Re: hints in Postgres?
  2003-12-11 16:31 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: hints in Postgres?
  2003-12-11 20:27 UTC  Bruno Wolff III <bruno@wolff.to>
  [4+ messages in thread]

Command
  2003-12-11 16:45 UTC  nbarraza@uolsinectis.com.ar

Solaris Performance (Again)
  2003-12-10 05:56 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Solaris Performance (Again)
  2003-12-10 13:53 UTC  Jeff <threshar@torgo.978.org>
` Re: Solaris Performance (Again)
  2003-12-10 19:15 UTC  Neil Conway <neilc@samurai.com>
` Re: Solaris Performance (Again)
  2003-12-11 06:04 UTC  Mark Kirkwood <markir@paradise.net.nz>
` Re: Solaris Performance (Again)
  2003-12-11 06:09 UTC  Mark Kirkwood <markir@paradise.net.nz>
  [5+ messages in thread]

(no subject)
  2003-12-10 19:29 UTC  nbarraza@uolsinectis.com.ar
` Re:
  2003-12-10 20:35 UTC  Stephan Szabo <sszabo@megazone.bigpanda.com>
  [2+ messages in thread]

tuning questions
  2003-12-04 16:06 UTC  Jack Coates <jack@lyris.com>
` Re: tuning questions
  2003-12-04 16:59 UTC  Josh Berkus <josh@agliodbs.com>
` Re: tuning questions
  2003-12-04 16:59 UTC  Jeff <threshar@torgo.978.org>
` Re: tuning questions
  2003-12-04 17:13 UTC  Rob Fielding <rob@dsvr.net>
` Re: tuning questions
  2003-12-04 17:26 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: tuning questions
  2003-12-04 17:57 UTC  Dror Matalon <dror@zapatec.com>
` Re: tuning questions
  2003-12-04 18:03 UTC  Josh Berkus <josh@agliodbs.com>
` Re: tuning questions
  2003-12-04 18:07 UTC  Jord Tanner <jord@indygecko.com>
` Re: tuning questions
  2003-12-04 18:11 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: tuning questions
  2003-12-04 18:12 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: tuning questions
  2003-12-04 19:16 UTC  Jack Coates <jack@lyris.com>
` Re: tuning questions
  2003-12-04 19:17 UTC  Eric Soroos <eric-psql@soroos.net>
` Re: tuning questions
  2003-12-04 19:20 UTC  Josh Berkus <josh@agliodbs.com>
` Re: tuning questions
  2003-12-04 19:50 UTC  Jack Coates <jack@lyris.com>
` Re: tuning questions
  2003-12-04 20:27 UTC  Richard Huxton <dev@archonet.com>
` Re: tuning questions
  2003-12-04 20:37 UTC  Jack Coates <jack@lyris.com>
` Re: tuning questions
  2003-12-04 21:10 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: tuning questions
  2003-12-04 21:24 UTC  Josh Berkus <josh@agliodbs.com>
` Re: tuning questions
  2003-12-04 22:59 UTC  Eric Soroos <eric-psql@soroos.net>
` Re: tuning questions
  2003-12-04 23:16 UTC  Jack Coates <jack@lyris.com>
` Re: tuning questions
  2003-12-04 23:20 UTC  Jack Coates <jack@lyris.com>
` Re: tuning questions
  2003-12-04 23:47 UTC  Richard Huxton <dev@archonet.com>
` Re: tuning questions
  2003-12-05 00:32 UTC  Jack Coates <jack@lyris.com>
` Re: tuning questions
  2003-12-05 04:52 UTC  Eric Soroos <eric-psql@soroos.net>
` Re: tuning questions
  2003-12-05 09:13 UTC  Thierry Missimilly <THIERRY.MISSIMILLY@BULL.NET>
` Re: tuning questions
  2003-12-05 17:26 UTC  Josh Berkus <josh@agliodbs.com>
` Re: tuning questions
  2003-12-06 01:22 UTC  Jack Coates <jack@lyris.com>
` Re: tuning questions
  2003-12-08 17:43 UTC  Jack Coates <jack@lyris.com>
` Re: tuning questions
  2003-12-08 19:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: tuning questions
  2003-12-09 16:57 UTC  Jack Coates <jack@lyris.com>
` Re: tuning questions
  2003-12-09 17:07 UTC  Matt Clark <matt@ymogen.net>
` Re: tuning questions
  2003-12-09 17:35 UTC  Josh Berkus <josh@agliodbs.com>
  [32+ messages in thread]

Problem with insert into select...
  2003-11-20 21:04 UTC  stephen farrell <sfarrell@almaden.ibm.com>
` Problem with insert into select...
  2003-11-20 21:09 UTC  stephen farrell <sfarrell@almaden.ibm.com>
` Re: Problem with insert into select...
  2003-11-20 22:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Problem with insert into select...
  2003-11-21 02:05 UTC  stephen farrell <sfarrell@almaden.ibm.com>
` Re: Problem with insert into select...
  2003-11-24 19:29 UTC  Richard Huxton <dev@archonet.com>
` Re: Problem with insert into select...
  2003-12-09 08:32 UTC  Neil Conway <neilc@samurai.com>
  [6+ messages in thread]

autovacuum daemon stops doing work after about an hour
  2003-12-02 20:37 UTC  Vivek Khera <khera@kcilink.com>
` Re: autovacuum daemon stops doing work after about an	hour
  2003-12-04 05:38 UTC  Matthew T. O'Connor <matthew@zeut.net>
` Re: autovacuum daemon stops doing work after about an	hour
  2003-12-04 16:33 UTC  Vivek Khera <khera@kcilink.com>
` Re: autovacuum daemon stops doing work after about an hour
  2003-12-04 18:35 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: autovacuum daemon stops doing work after about an	hour
  2003-12-04 19:29 UTC  Vivek Khera <khera@kcilink.com>
` Re: autovacuum daemon stops doing work after about an	hour
  2003-12-04 19:44 UTC  Vivek Khera <khera@kcilink.com>
` Re: autovacuum daemon stops doing work after about an	hour
  2003-12-04 20:52 UTC  Matthew T. O'Connor <matthew@zeut.net>
` Re: autovacuum daemon stops doing work after about an	hour
  2003-12-04 21:20 UTC  Vivek Khera <khera@kcilink.com>
` Re: autovacuum daemon stops doing work after about an	hour
  2003-12-04 21:22 UTC  Vivek Khera <khera@kcilink.com>
` Re: autovacuum daemon stops doing work after about an
  2003-12-04 21:25 UTC  Larry Rosenman <ler@lerctr.org>
` Re: autovacuum daemon stops doing work after about an
  2003-12-04 21:37 UTC  Vivek Khera <khera@kcilink.com>
` Re: autovacuum daemon stops doing work after about an
  2003-12-07 21:16 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: autovacuum daemon stops doing work after about an hour
  2003-12-08 00:46 UTC  Gaetano Mendola <mendola@bigfoot.com>
` Re: autovacuum daemon stops doing work after about an hour
  2003-12-08 01:17 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: autovacuum daemon stops doing work after about an hour
  2003-12-08 05:27 UTC  Matthew T. O'Connor <matthew@zeut.net>
` Re: autovacuum daemon stops doing work after about an hour
  2003-12-08 18:41 UTC  Vivek Khera <khera@kcilink.com>
  [16+ messages in thread]

Help tracking down problem with inserts slowing down...
  2003-12-05 21:51 UTC  Steve Wampler <swampler@noao.edu>
` Re: Help tracking down problem with inserts slowing
  2003-12-05 23:38 UTC  Neil Conway <neilc@samurai.com>
` Re: Help tracking down problem with inserts slowing down...
  2003-12-06 02:54 UTC  Robert Treat <xzilla@users.sourceforge.net>
` Re: Help tracking down problem with inserts slowing down...
  2003-12-07 14:28 UTC  Steve Wampler <swampler@noao.edu>
` Re: Help tracking down problem with inserts slowing down...
  2003-12-07 14:52 UTC  Steve Wampler <swampler@noao.edu>
` Re: Help tracking down problem with inserts slowing down...
  2003-12-07 16:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help tracking down problem with inserts slowing
  2003-12-07 17:28 UTC  Steve Wampler <swampler@noao.edu>
` Re: Help tracking down problem with inserts slowing
  2003-12-08 15:14 UTC  Steve Wampler <swampler@noao.edu>
` Re: Help tracking down problem with inserts slowing
  2003-12-08 15:35 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [9+ messages in thread]

Slow UPADTE, compared to INSERT
  2003-12-04 18:57 UTC  Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
  2003-12-04 19:23 UTC  Jeff <threshar@torgo.978.org>
` Re: Slow UPADTE, compared to INSERT
  2003-12-04 19:51 UTC  Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
  2003-12-04 19:59 UTC  William Yu <wyu@talisys.com>
` Re: Slow UPADTE, compared to INSERT
  2003-12-04 20:23 UTC  Richard Huxton <dev@archonet.com>
` Re: Slow UPADTE, compared to INSERT
  2003-12-04 20:43 UTC  Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
  2003-12-04 22:13 UTC  Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
  2003-12-04 22:37 UTC  Richard Huxton <dev@archonet.com>
` Re: Slow UPADTE, compared to INSERT
  2003-12-04 22:45 UTC  Richard Huxton <dev@archonet.com>
` Re: Slow UPADTE, compared to INSERT
  2003-12-05 01:45 UTC  Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
  2003-12-05 02:07 UTC  Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
  2003-12-05 02:15 UTC  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Slow UPADTE, compared to INSERT
  2003-12-05 10:08 UTC  Richard Huxton <dev@archonet.com>
` Re: Slow UPADTE, compared to INSERT
  2003-12-05 12:38 UTC  Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
  2003-12-05 12:49 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Slow UPADTE, compared to INSERT
  2003-12-05 13:13 UTC  Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
  2003-12-05 13:23 UTC  Richard Huxton <dev@archonet.com>
` Re: Slow UPADTE, compared to INSERT
  2003-12-05 13:51 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Slow UPADTE, compared to INSERT
  2003-12-05 16:47 UTC  Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
  2003-12-05 16:52 UTC  Ivar Zarans <iff@alcaron.ee>
` Re: Slow UPADTE, compared to INSERT
  2003-12-05 17:05 UTC  Mike C. Fletcher <mcfletch@rogers.com>
` Re: Slow UPADTE, compared to INSERT
  2003-12-05 17:12 UTC  Mike C. Fletcher <mcfletch@rogers.com>
` Re: Slow UPADTE, compared to INSERT
  2003-12-05 17:28 UTC  Greg Stark <gsstark@mit.edu>
` Re: Slow UPADTE, compared to INSERT
  2003-12-06 19:54 UTC  Neil Conway <neilc@samurai.com>
  [24+ messages in thread]

query using cpu nearly 100%, why?
  2003-12-05 21:03 UTC  LIANHE SHAO <lshao2@jhmi.edu>
` Re: query using cpu nearly 100%, why?
  2003-12-06 17:46 UTC  Richard Huxton <dev@archonet.com>
` Re: query using cpu nearly 100%, why?
  2003-12-06 19:41 UTC  Neil Conway <neilc@samurai.com>
  [3+ messages in thread]

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]


[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