From: Joe Conway <mail@joeconway.com>
To: Hilmar Lapp <hlapp@gmx.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: join over 12 tables takes 3 secs to plan
Date: Thu, 02 Jan 2003 13:40:23 -0800
Message-ID: <3E14B1C7.9040007@joeconway.com> (raw)
In-Reply-To: <B3DCB6D1-1E95-11D7-9244-000393B4BFF6@gmx.net>
References: <B3DCB6D1-1E95-11D7-9244-000393B4BFF6@gmx.net>
Hilmar Lapp wrote:
> As an added note, appreciating that query optimization is a difficult
> problem, and I do think PostgreSQL is a great product. Having said
> that, I've written 16-table joins for Oracle and always found them to
> plan within a second or two, so that's why I thought there's nothing
> special about the query I posted ... I'm not saying this to be bashful
> about PostgreSQL, but rather to suggest that apparently there are ways
> to do it pretty fast.
I could be wrong, but I believe Oracle uses its rule based optimizer by
default, not its cost based optimizer. A rule based optimizer will be very
quick all the time, but might not pick the best plan all the time, because it
doesn't consider the statistics of the data. Any idea which one you were using
in your Oracle experience?
Joe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: mail@joeconway.com, hlapp@gmx.net, tgl@sss.pgh.pa.us
Subject: Re: join over 12 tables takes 3 secs to plan
In-Reply-To: <3E14B1C7.9040007@joeconway.com>
References: <B3DCB6D1-1E95-11D7-9244-000393B4BFF6@gmx.net> <3E14B1C7.9040007@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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