pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
slow plan for min/max
  2003-09-07 18:04 UTC  Pailloncy Jean-Gérard <pailloncy@ifrance.com>
` Re: slow plan for min/max
  2003-09-08 15:56 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: slow plan for min/max
  2003-09-08 18:49 UTC  Neil Conway <neilc@samurai.com>
` Re: slow plan for min/max
  2003-09-08 19:32 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: slow plan for min/max
  2003-09-08 20:37 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: slow plan for min/max
  2003-09-08 21:26 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow plan for min/max
  2003-09-08 21:41 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: slow plan for min/max
  2003-09-08 22:07 UTC  Greg Stark <gsstark@mit.edu>
` Re: slow plan for min/max
  2003-09-08 22:40 UTC  Josh Berkus <josh@agliodbs.com>
` Re: slow plan for min/max
  2003-09-08 23:17 UTC  Matt Clark <matt@ymogen.net>
` Re: slow plan for min/max
  2003-09-08 23:38 UTC  Matt Clark <matt@ymogen.net>
` Re: slow plan for min/max
  2003-09-08 23:42 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow plan for min/max
  2003-09-09 00:42 UTC  Matt Clark <matt@ymogen.net>
` Re: slow plan for min/max
  2003-09-09 02:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow plan for min/max
  2003-09-09 13:36 UTC  Pailloncy Jean-Gérard <pailloncy@ifrance.com>
` Re: slow plan for min/max
  2003-09-09 17:14 UTC  Josh Berkus <josh@agliodbs.com>
` Re: slow plan for min/max
  2003-09-09 18:49 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: slow plan for min/max
  2003-09-09 19:06 UTC  Thomas Swan <tswan@idigx.com>
` Re: slow plan for min/max
  2003-09-09 19:34 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: slow plan for min/max
  2003-09-10 00:22 UTC  Matt Clark <matt@ymogen.net>
  [20+ messages in thread]

increase performancr with "noatime"?
  2003-09-09 08:12 UTC  JM <jerome@gmanmi.tv>
` Re: increase performancr with "noatime"?
  2003-09-09 12:37 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: increase performancr with "noatime"?
  2003-09-09 12:44 UTC  Bill Moran <wmoran@potentialtech.com>
` Re: increase performancr with "noatime"?
  2003-09-09 16:08 UTC  Vivek Khera <khera@kcilink.com>
  [4+ messages in thread]

Quick question
  2003-09-09 03:02 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Quick question
  2003-09-09 03:14 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

(no subject)
  2003-09-09 00:38 UTC  Odiel León <odiel@jagua.cfg.sld.cu>

Explain Doc
  2003-09-08 14:29 UTC  Rhaoni Chiu Pereira <rhaoni@sistemica.info>
` Re: [PERFORM] Explain Doc
  2003-09-08 22:04 UTC  Alberto Caso <alberto.caso@adaptia.net>
  [2+ messages in thread]

Serious issues with CPU usage
  2003-09-05 21:58 UTC  andris@neti.ee
` Re: Serious issues with CPU usage
  2003-09-06 00:05 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Serious issues with CPU usage
  2003-09-06 09:10 UTC  Hannu Krosing <hannu@tm.ee>
` Re: Serious issues with CPU usage
  2003-09-08 10:50 UTC  Andri Saar <andris@estpak.ee>
` Re: Serious issues with CPU usage
  2003-09-08 11:14 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Serious issues with CPU usage
  2003-09-08 11:53 UTC  Manfred Koizar <mkoi-pg@aon.at>
` Re: Serious issues with CPU usage
  2003-09-08 14:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Serious issues with CPU usage
  2003-09-08 14:31 UTC  Andri Saar <andris@estpak.ee>
` Re: Serious issues with CPU usage
  2003-09-08 14:50 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
  [9+ messages in thread]

Poor pg_dump performance
  2003-09-07 05:23 UTC  Jim C. Nasby <jim@nasby.net>

SELECT's take a long time compared to other DBMS
  2003-09-04 00:28 UTC  Relaxin <me@yourhouse.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 01:05 UTC  Rod Taylor <rbt@rbt.ca>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 01:06 UTC  Rudi Starcevic <rudi@oasis.net.au>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 01:22 UTC  Relaxin <me@yourhouse.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 01:24 UTC  Relaxin <me@yourhouse.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 01:32 UTC  Rudi Starcevic <rudi@oasis.net.au>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 01:54 UTC  Neil Conway <neilc@samurai.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 03:19 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 03:24 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 04:43 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 05:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 07:48 UTC  Relaxin <noname@spam.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 08:00 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 08:16 UTC  Relaxin <noname@spam.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 11:01 UTC  Hannu Krosing <hannu@tm.ee>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 14:35 UTC  Relaxin <noname@spam.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 15:01 UTC  Jean-Luc Lachance <jllachan@nsd.ca>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 15:05 UTC  Relaxin <noname@spam.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 16:30 UTC  Hannu Krosing <hannu@tm.ee>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 16:52 UTC  Relaxin <noname@spam.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 17:44 UTC  William Yu <wyu@talisys.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 22:28 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 22:58 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-04 23:14 UTC  Relaxin <noname@spam.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-05 00:45 UTC  Relaxin <noname@spam.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-05 01:26 UTC  Christopher Browne <cbbrowne@acm.org>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-05 02:13 UTC  Relaxin <noname@spam.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-05 02:32 UTC  Neil Conway <neilc@samurai.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-05 04:54 UTC  Eirik Oeverby <ltning@anduin.net>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-05 04:59 UTC  Relaxin <noname@spam.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-05 15:05 UTC  Patrick Hatcher <PHatcher@macys.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-05 18:18 UTC  Relaxin <noname@spam.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-05 21:09 UTC  Neil Conway <neilc@samurai.com>
` Re: SELECT's take a long time compared to other DBMS
  2003-09-06 00:55 UTC  Relaxin <noname@spam.com>
  [34+ messages in thread]

Seq scan of table?
  2003-09-05 06:08 UTC  Bjorn T Johansen <btj@havleik.no>
` Re: Seq scan of table?
  2003-09-05 06:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Seq scan of table?
  2003-09-05 06:57 UTC  Bjorn T Johansen <btj@havleik.no>
` Re: Seq scan of table?
  2003-09-05 08:47 UTC  Bjorn T Johansen <btj@havleik.no>
` Re: [PERFORM] Seq scan of table?
  2003-09-05 10:07 UTC  Richard Huxton <dev@archonet.com>
` Re: [PERFORM] Seq scan of table?
  2003-09-05 13:23 UTC  Bjørn T Johansen <btj@havleik.no>
` Re: Seq scan of table?
  2003-09-05 14:39 UTC  Jonathan Bartlett <johnnyb@eskimo.com>
` Re: [PERFORM] Seq scan of table?
  2003-09-05 16:09 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: [PERFORM] Seq scan of table?
  2003-09-05 18:20 UTC  Neil Conway <neilc@samurai.com>
` Re: [PERFORM] Seq scan of table?
  2003-09-05 19:37 UTC  Richard Huxton <dev@archonet.com>
` Re: [PERFORM] Seq scan of table?
  2003-09-05 21:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [11+ messages in thread]

Performance problems on a fairly big table with two key columns.
  2003-09-04 22:53 UTC  Rasmus Aveskogh <rasmus@defero.se>
` Re: Performance problems on a fairly big table with two key columns.
  2003-09-05 08:34 UTC  Richard Huxton <dev@archonet.com>
` Re: Performance problems on a fairly big table with two
  2003-09-05 15:36 UTC  Rasmus Aveskogh <rasmus@defero.se>
` Re: Performance problems on a fairly big table with two
  2003-09-05 16:39 UTC  Richard Huxton <dev@archonet.com>
  [4+ messages in thread]

checkpoints too frequent
  2003-09-05 15:17 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: checkpoints too frequent
  2003-09-05 15:41 UTC  Vivek Khera <khera@kcilink.com>
  [2+ messages in thread]

RE : Seq scan of table?
  2003-09-05 06:34 UTC  Bruno BAGUETTE <pgsql-ml@baguette.net>
` Re: RE : Seq scan of table?
  2003-09-05 06:55 UTC  Bjorn T Johansen <btj@havleik.no>
  [2+ messages in thread]

PostgreSQL Reliability when fsync = false on Linux-XFS
  2003-09-04 03:04 UTC  Federico Sevilla III <jijo@free.net.ph>
` Re: PostgreSQL Reliability when fsync = false on Linux-XFS
  2003-09-04 03:36 UTC  Rod Taylor <rbt@rbt.ca>
` Re: PostgreSQL Reliability when fsync = false on
  2003-09-04 06:55 UTC  Hannu Krosing <hannu@tm.ee>
` Re: PostgreSQL Reliability when fsync = false on Linux-XFS
  2003-09-04 07:04 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: PostgreSQL Reliability when fsync = false on Linux-XFS
  2003-09-04 07:27 UTC  Sean Chittenden <sean@chittenden.org>
` Re: PostgreSQL Reliability when fsync = false on Linux-XFS
  2003-09-04 13:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL Reliability when fsync = false on Linux-XFS
  2003-09-04 22:35 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [7+ messages in thread]

Re: FreeBSD page size
  2003-09-03 19:16 UTC  Vivek Khera <khera@kcilink.com>
` Re: FreeBSD page size
  2003-09-03 19:35 UTC  Sean Chittenden <sean@chittenden.org>
` Re: FreeBSD page size
  2003-09-03 19:41 UTC  Vivek Khera <khera@kcilink.com>
` Re: FreeBSD page size
  2003-09-03 20:32 UTC  Marc G. Fournier <scrappy@hub.org>
` Re: FreeBSD page size
  2003-09-03 23:29 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: FreeBSD page size
  2003-09-03 23:49 UTC  Rod Taylor <rbt@rbt.ca>
` Re: FreeBSD page size
  2003-09-04 00:04 UTC  Marc G. Fournier <scrappy@hub.org>
` Re: FreeBSD page size
  2003-09-04 00:36 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: FreeBSD page size
  2003-09-04 16:09 UTC  Vivek Khera <khera@kcilink.com>
` Re: FreeBSD page size
  2003-09-04 18:17 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: FreeBSD page size
  2003-09-04 20:56 UTC  Vivek Khera <khera@kcilink.com>
` Re: FreeBSD page size
  2003-09-04 22:12 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: FreeBSD page size
  2003-09-04 22:13 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [13+ messages in thread]

FreeBSD page size (was Re: The results of my PostgreSQL/filesystem performance tests)
  2003-09-03 15:48 UTC  Vivek Khera <khera@kcilink.com>
` Re: FreeBSD page size (was Re: The results of my
  2003-09-04 21:56 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [2+ messages in thread]

Query on Postgresql performance
  2003-09-03 19:32 UTC  Naveen Palavalli <palavall@ISI.EDU>
` Re: Query on Postgresql performance
  2003-09-04 02:01 UTC  Neil Conway <neilc@samurai.com>
` Re: Query on Postgresql performance
  2003-09-04 10:40 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [3+ messages in thread]

Re: Selecting random rows efficiently
  2003-08-30 13:08 UTC  Jeff <threshar@torgo.978.org>
` Selecting random rows efficiently
  2003-08-30 13:09 UTC  Richard Jones <rj@last.fm>
` Re: Selecting random rows efficiently
  2003-08-30 14:01 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Selecting random rows efficiently
  2003-08-30 14:04 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: Selecting random rows efficiently
  2003-08-30 14:25 UTC  Richard Jones <rj@last.fm>
` Re: Selecting random rows efficiently
  2003-08-30 14:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Selecting random rows efficiently
  2003-08-30 15:14 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Selecting random rows efficiently
  2003-08-30 16:18 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: Selecting random rows efficiently
  2003-08-30 17:43 UTC  Russell Garrett <rg@tcslon.com>
` Re: Selecting random rows efficiently
  2003-09-04 00:09 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [10+ messages in thread]

SQL slower when running for the second time
  2003-09-03 19:15 UTC  Rhaoni Chiu Pereira <rhaoni@sistemica.info>
` Re: SQL slower when running for the second time
  2003-09-03 20:03 UTC  Peter Eisentraut <peter_e@gmx.net>
` Re: [ADMIN] SQL slower when running for the second time
  2003-09-03 20:44 UTC  Rhaoni Chiu Pereira <rhaoni@sistemica.info>
` Re: SQL slower when running for the second time
  2003-09-03 20:49 UTC  Ron Johnson <ron.l.johnson@cox.net>
  [4+ messages in thread]

PostgreSQL is slow...HELP
  2003-09-03 13:08 UTC  Azlin Ghazali <azlin_ghazali@yahoo.com>
` Re: PostgreSQL is slow...HELP
  2003-09-03 13:14 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: PostgreSQL is slow...HELP
  2003-09-03 14:10 UTC  Nick Fankhauser <nickf@ontko.com>
` Re: PostgreSQL is slow...HELP
  2003-09-03 14:38 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: PostgreSQL is slow...HELP
  2003-09-03 14:39 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

" ... though the pgsql version performance is not very great."
  2003-09-03 13:59 UTC  Justin Clift <justin@postgresql.org>

Use of to_timestamp causes full scan
  2003-09-02 17:50 UTC  Zaremba, Don <dzaremba@ellacoya.com>
` Re: Use of to_timestamp causes full scan
  2003-09-02 18:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

opinion on RAID choice
  2003-08-28 21:16 UTC  Vivek Khera <khera@kcilink.com>
` Re: opinion on RAID choice
  2003-08-28 21:26 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: opinion on RAID choice
  2003-08-29 02:00 UTC  Vivek Khera <khera@kcilink.com>
` Re: opinion on RAID choice
  2003-08-29 04:22 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: opinion on RAID choice
  2003-09-02 16:14 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: opinion on RAID choice
  2003-09-02 16:24 UTC  Larry Rosenman <ler@lerctr.org>
` Re: opinion on RAID choice
  2003-09-02 16:33 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: opinion on RAID choice
  2003-09-02 16:36 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: opinion on RAID choice
  2003-09-02 16:47 UTC  Greg Spiegelberg <gspiegelberg@cranel.com>
` Re: opinion on RAID choice
  2003-09-02 17:33 UTC  Ron Johnson <ron.l.johnson@cox.net>
  [10+ messages in thread]

How to force Nested Loop plan?
  2003-08-30 13:16 UTC  Rob Nagler <nagler@bivio.biz>
` Re: How to force Nested Loop plan?
  2003-08-30 15:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to force Nested Loop plan?
  2003-08-30 15:47 UTC  Rob Nagler <nagler@bivio.biz>
` Re: How to force Nested Loop plan?
  2003-08-30 16:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to force Nested Loop plan?
  2003-08-30 16:33 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: How to force Nested Loop plan?
  2003-08-30 20:42 UTC  Rob Nagler <nagler@bivio.biz>
` Re: How to force Nested Loop plan?
  2003-08-30 21:28 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: How to force Nested Loop plan?
  2003-08-30 22:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to force Nested Loop plan?
  2003-08-30 23:59 UTC  Rob Nagler <nagler@bivio.biz>
` Re: How to force Nested Loop plan?
  2003-08-31 00:08 UTC  Rob Nagler <nagler@bivio.biz>
` Re: How to force Nested Loop plan?
  2003-08-31 23:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to force Nested Loop plan?
  2003-09-01 15:22 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: How to force Nested Loop plan?
  2003-09-01 21:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [13+ messages in thread]

SQL performance problems
  2003-08-29 20:59 UTC  Rhaoni Chiu Pereira <rhaoni@sistemica.info>
` Re: SQL performance problems
  2003-08-29 22:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL performance problems
  2003-08-31 22:16 UTC  Alberto Caso <alberto.caso@adaptia.net>
` Re: SQL performance problems
  2003-09-01 12:11 UTC  Alberto Caso <alberto.caso@adaptia.net>
  [4+ messages in thread]

Mail Test
  2003-09-01 01:45 UTC  F Brown <fred.brown@maps.lss.bc.ca>


[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