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




view thread (22+ messages)  latest in thread

Message-ID: <3E14B1C7.9040007@joeconway.com>
Permalink:  ../3E14B1C7.9040007@joeconway.com/
Also on:    postgresql.org/message-id/3E14B1C7.9040007@joeconway.com

 · 

reply

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