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