pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Proposal: relaxing link between explicit JOINs and execution order
  2003-01-22 23:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Proposal: relaxing link between explicit JOINs and execution order
  2003-01-22 23:59 UTC  Sean Chittenden <sean@chittenden.org>
` Re: [PERFORM] Proposal: relaxing link between explicit JOINs and execution order
  2003-01-23 00:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Proposal: relaxing link between explicit JOINs and execution order
  2003-01-23 00:17 UTC  Josh Berkus <josh@agliodbs.com>
` Re: [PERFORM] Proposal: relaxing link between explicit JOINs and execution order
  2003-01-23 00:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Proposal: relaxing link between explicit JOINs and execution order
  2003-01-26 05:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

WEIRD CRASH?!?!
  2003-01-24 23:59 UTC  Noah Silverman <noah@allresearch.com>
` Re: WEIRD CRASH?!?!
  2003-01-25 00:03 UTC  Josh Berkus <josh@agliodbs.com>
` Re: WEIRD CRASH?!?!
  2003-01-25 00:08 UTC  Noah Silverman <noah@allresearch.com>
` Re: WEIRD CRASH?!?!
  2003-01-25 00:13 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: WEIRD CRASH?!?!
  2003-01-25 00:15 UTC  Josh Berkus <josh@agliodbs.com>
` Re: WEIRD CRASH?!?!
  2003-01-25 00:17 UTC  Noah Silverman <noah@allresearch.com>
` Re: WEIRD CRASH?!?!
  2003-01-25 00:27 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: WEIRD CRASH?!?!
  2003-01-25 01:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: WEIRD CRASH?!?!
  2003-01-25 01:08 UTC  Rod Taylor <rbt@rbt.ca>
` Re: WEIRD CRASH?!?!
  2003-01-25 01:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: WEIRD CRASH?!?!
  2003-01-25 01:14 UTC  Noah Silverman <noah@allresearch.com>
` Re: WEIRD CRASH?!?!
  2003-01-25 01:20 UTC  Rod Taylor <rbt@rbt.ca>
` Re: WEIRD CRASH?!?!
  2003-01-25 01:38 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: WEIRD CRASH?!?!
  2003-01-25 03:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: WEIRD CRASH?!?!
  2003-01-25 18:44 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [15+ messages in thread]

Having trouble with backups (was: Re: Crash Recovery)
  2003-01-24 15:16 UTC  Carlos Moreno <moreno@mochima.com>
` Re: Having trouble with backups (was: Re: Crash Recovery)
  2003-01-24 16:08 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Having trouble with backups (was: Re: Crash Recovery)
  2003-01-24 16:09 UTC  Justin Clift <justin@postgresql.org>
` Re: Having trouble with backups (was: Re: Crash Recovery)
  2003-01-24 16:13 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Having trouble with backups (was: Re: Crash Recovery)
  2003-01-24 21:01 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Having trouble with backups (was: Re: Crash Recovery)
  2003-01-25 00:29 UTC  Carlos Moreno <moreno@mochima.com>
` Re: Having trouble with backups (was: Re: Crash Recovery)
  2003-01-25 01:04 UTC  Kevin Brown <kevin@sysexperts.com>
` Re: Having trouble with backups (was: Re: Crash Recovery)
  2003-01-25 01:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Having trouble with backups (was: Re: Crash Recovery)
  2003-01-25 01:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Having trouble with backups (was: Re: Crash Recovery)
  2003-01-25 04:20 UTC  Curt Sampson <cjs@cynic.net>
` Re: Having trouble with backups (was: Re: Crash Recovery)
  2003-01-25 15:20 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Having trouble with backups (was: Re: Crash Recovery)
  2003-01-25 15:22 UTC  Carlos Moreno <moreno@mochima.com>
` Re: Having trouble with backups (was: Re: Crash Recovery)
  2003-01-25 17:17 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [13+ messages in thread]

Multiple databases one directory
  2003-01-24 22:39 UTC  Noah Silverman <noah@allresearch.com>
` Re: Multiple databases one directory
  2003-01-24 23:22 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Multiple databases one directory
  2003-01-25 00:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Multiple databases one directory
  2003-01-25 00:57 UTC  Noah Silverman <noah@allresearch.com>
  [4+ messages in thread]

Does "correlation" mislead the optimizer on large tables?
  2003-01-24 04:16 UTC  Ron Mayer <ron@intervideo.com>
` Re: Does "correlation" mislead the optimizer on large tables?
  2003-01-24 06:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Does "correlation" mislead the optimizer on large
  2003-01-24 16:27 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: Does "correlation" mislead the optimizer on large
  2003-01-24 19:36 UTC  Ron Mayer <ron@intervideo.com>
` Re: Does "correlation" mislead the optimizer on large
  2003-01-24 20:04 UTC  Ron Mayer <ron@intervideo.com>
` Re: Does "correlation" mislead the optimizer on large
  2003-01-24 20:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Does "correlation" mislead the optimizer on large
  2003-01-24 21:55 UTC  Noah Silverman <noah@allresearch.com>
` Re: Does "correlation" mislead the optimizer on large
  2003-01-24 23:09 UTC  Ron Mayer <ron@intervideo.com>
  [8+ messages in thread]

Crash Recovery, pt 2
  2003-01-24 14:12 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: Crash Recovery, pt 2
  2003-01-24 15:48 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Crash Recovery, pt 2
  2003-01-24 18:46 UTC  Ron Johnson <ron.l.johnson@cox.net>
  [3+ messages in thread]

Crash Recovery
  2003-01-24 03:32 UTC  Noah Silverman <noah@allresearch.com>
` Re: Crash Recovery
  2003-01-24 06:29 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Crash Recovery
  2003-01-24 13:22 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Crash Recovery
  2003-01-24 13:52 UTC  Ron Johnson <ron.l.johnson@cox.net>
  [4+ messages in thread]

Same query, same performance
  2003-01-23 02:26 UTC  alexandre :: aldeia digital <alepaes@aldeiadigital.com.br>
` Re: Same query, same performance
  2003-01-23 08:20 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: Same query, same performance
  2003-01-23 17:00 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Same query, same performance
  2003-01-23 19:49 UTC  alexandre :: aldeia digital <alepaes@aldeiadigital.com.br>
` Re: Same query, same performance
  2003-01-23 20:31 UTC  alexandre :: aldeia digital <alepaes@aldeiadigital.com.br>
  [5+ messages in thread]

types & index usage
  2003-01-23 08:14 UTC  Timur Irmatov <thor@sarkor.com>

Slow query on OS X box
  2003-01-22 18:26 UTC  Patrick Hatcher <PHatcher@macys.com>
` Re: Slow query on OS X box
  2003-01-22 20:02 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Slow query on OS X box
  2003-01-22 20:35 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: Slow query on OS X box
  2003-01-22 20:49 UTC  Patrick Hatcher <PHatcher@macys.com>
` Re: Slow query on OS X box
  2003-01-22 20:58 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: Slow query on OS X box
  2003-01-22 22:03 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query on OS X box
  2003-01-22 22:54 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Slow query on OS X box
  2003-01-23 00:05 UTC  Patrick Hatcher <PHatcher@macys.com>
  [8+ messages in thread]

Performance between triggers/functions written in C  and PL/PGSQL
  2003-01-22 02:50 UTC  Ludwig Lim <lud_nowhere_man@yahoo.com>
` Re: Performance between triggers/functions written in C and PL/PGSQL
  2003-01-22 18:57 UTC  Josh Berkus <josh@agliodbs.com>
  [2+ messages in thread]

x86-64 and PostgreSQL
  2003-01-18 05:29 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: x86-64 and PostgreSQL
  2003-01-18 06:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: x86-64 and PostgreSQL
  2003-01-18 06:55 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: x86-64 and PostgreSQL
  2003-01-18 16:39 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: x86-64 and PostgreSQL
  2003-01-20 06:29 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: x86-64 and PostgreSQL
  2003-01-20 09:52 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: x86-64 and PostgreSQL
  2003-01-20 09:59 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: x86-64 and PostgreSQL
  2003-01-20 12:06 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: x86-64 and PostgreSQL
  2003-01-20 12:11 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: x86-64 and PostgreSQL
  2003-01-21 08:21 UTC  James H. Cloos Jr. <cloos@jhcloos.com>
  [10+ messages in thread]

Very large caches (was Re: 7.3.1 New install, large queries are slow)
  2003-01-20 09:41 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: Very large caches (was Re: 7.3.1 New install, large queries are slow)
  2003-01-20 15:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Strange Join question
  2003-01-17 17:28 UTC  Noah Silverman <noah@allresearch.com>
` Re: Strange Join question
  2003-01-17 17:38 UTC  Patrick Hatcher <PHatcher@macys.com>
  [2+ messages in thread]

Implicit casting and JOIN syntax constraints
  2003-01-17 14:48 UTC  Roman Fail <rfail@posportal.com>
` Re: Implicit casting and JOIN syntax constraints
  2003-01-17 15:41 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [2+ messages in thread]

schema/db design wrt performance
  2003-01-16 13:51 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: schema/db design wrt performance
  2003-01-16 14:07 UTC  Fernando Papa <fpapa@claxson.com>
` Re: schema/db design wrt performance
  2003-01-16 14:20 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: schema/db design wrt performance
  2003-01-16 14:34 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: schema/db design wrt performance
  2003-01-16 15:39 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: schema/db design wrt performance
  2003-01-16 15:50 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: schema/db design wrt performance
  2003-01-16 16:02 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: schema/db design wrt performance
  2003-01-16 16:05 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: schema/db design wrt performance
  2003-01-16 16:25 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: schema/db design wrt performance
  2003-01-16 16:38 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: schema/db design wrt performance
  2003-01-16 16:46 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: schema/db design wrt performance
  2003-01-16 17:24 UTC  Ron Johnson <ron.l.johnson@cox.net>
  [12+ messages in thread]

Re: Sun vs. Mac  - gprof output
  2003-01-15 17:22 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac - gprof output
  2003-01-16 06:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sun vs. Mac - gprof output
  2003-01-16 13:45 UTC  CaptainX0r <captainx0r@yahoo.com>
  [3+ messages in thread]

Re: complicated queries in pl/pgsql
  2003-01-13 18:44 UTC  Josh Berkus <josh@agliodbs.com>
` complicated queries in pl/pgsql
  2003-01-14 10:54 UTC  Tomasz Myrta <jasiek@klaster.net>
` Re: complicated queries in pl/pgsql
  2003-01-14 20:36 UTC  Josh Berkus <josh@agliodbs.com>
` Re: complicated queries in pl/pgsql
  2003-01-15 19:12 UTC  Tomasz Myrta <jasiek@klaster.net>
  [4+ messages in thread]

Sun vs. Mac
  2003-01-14 15:00 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 15:09 UTC  Justin Clift <justin@postgresql.org>
` Re: Sun vs. Mac
  2003-01-14 15:10 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Sun vs. Mac
  2003-01-14 15:18 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 15:41 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 16:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sun vs. Mac
  2003-01-14 16:08 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Sun vs. Mac
  2003-01-14 16:18 UTC  Lee Kindness <lkindness@csl.co.uk>
` Re: Sun vs. Mac
  2003-01-14 16:29 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 16:38 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 16:54 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 17:50 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 17:58 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Sun vs. Mac
  2003-01-14 18:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sun vs. Mac
  2003-01-14 18:26 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Sun vs. Mac
  2003-01-14 18:27 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 18:41 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-14 19:26 UTC  Hannu Krosing <hannu@tm.ee>
` Re: Sun vs. Mac
  2003-01-14 19:38 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac
  2003-01-15 05:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [20+ messages in thread]

Re: Sun vs. Mac - best Postgres platform?
  2003-01-14 18:10 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac - best Postgres platform?
  2003-01-14 18:30 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Sun vs. Mac - best Postgres platform?
  2003-01-14 18:39 UTC  eric soroos <eric-psql@soroos.net>
` Re: Sun vs. Mac - best Postgres platform?
  2003-01-14 19:01 UTC  CaptainX0r <captainx0r@yahoo.com>
` Re: Sun vs. Mac - best Postgres platform?
  2003-01-14 19:18 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Sun vs. Mac - best Postgres platform?
  2003-01-14 23:59 UTC  Justin Clift <justin@postgresql.org>
` Re: Sun vs. Mac - best Postgres platform?
  2003-01-15 00:02 UTC  Andrew Sullivan <andrew@libertyrms.info>
  [7+ messages in thread]

Re: Multiple databases
  2003-01-13 22:32 UTC  Josh Berkus <josh@agliodbs.com>
` Multiple databases
  2003-01-14 20:51 UTC  Noah Silverman <noah@allresearch.com>
` Re: Multiple databases
  2003-01-14 20:54 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Multiple databases
  2003-01-14 20:58 UTC  Noah Silverman <noah@allresearch.com>
  [4+ messages in thread]

How good I can get
  2003-01-14 19:42 UTC  Vernon Wu <vernonw@gatewaytech.com>

Cursor rowcount
  2003-01-13 21:33 UTC  typea@l-i-e.com
` Re: Cursor rowcount
  2003-01-13 22:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Cursor rowcount
  2003-01-14 01:05 UTC  typea@l-i-e.com
` Re: Cursor rowcount
  2003-01-14 04:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Cursor rowcount
  2003-01-14 09:12 UTC  Ron Johnson <ron.l.johnson@cox.net>
  [5+ messages in thread]

Accessing ANALYZE stats
  2003-01-13 18:42 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Accessing ANALYZE stats
  2003-01-13 18:46 UTC  Stephan Szabo <sszabo@megazone23.bigpanda.com>
  [2+ messages in thread]

join over 12 tables takes 3 secs to plan
  2003-01-02 19:42 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 20:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 20:41 UTC  Neil Conway <neilc@samurai.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 21:03 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 21:08 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 21:11 UTC  Neil Conway <neilc@samurai.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 21:21 UTC  Neil Conway <neilc@samurai.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 21:29 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 21:40 UTC  Joe Conway <mail@joeconway.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-02 22:49 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 00:01 UTC  Ron Johnson <ron.l.johnson@cox.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 00:24 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 00:36 UTC  Charles H. Woloszynski <chw@clearmetrix.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 17:01 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 17:12 UTC  Jeff <threshar@torgo.978.org>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 19:38 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 22:09 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: [PERFORM] join over 12 tables takes 3 secs to plan
  2003-01-03 22:16 UTC  Charles H. Woloszynski <chw@clearmetrix.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-03 22:22 UTC  Hilmar Lapp <hlapp@gmx.net>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-12 01:03 UTC  Neil Conway <neilc@samurai.com>
` Re: join over 12 tables takes 3 secs to plan
  2003-01-12 15:52 UTC  Charles H. Woloszynski <chw@clearmetrix.com>
` Re: [PERFORM] join over 12 tables takes 3 secs to plan
  2003-01-13 13:08 UTC  Charles H. Woloszynski <chw@clearmetrix.com>
  [22+ 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