ll in shock)
>
> Mike Mascari
> [EMAIL PROTECTED]
>
> -Original Message-
> From: Tom Lane [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 25, 2001 12:42 PM
> To: [EMAIL PROTECTED]
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: [HACKERS] Any opti
: Wednesday, April 25, 2001 12:42 PM
To: [EMAIL PROTECTED]
Cc: '[EMAIL PROTECTED]'
Subject: Re: [HACKERS] Any optimizations to the join code in 7.1?
Mike Mascari <[EMAIL PROTECTED]> writes:
> I have a particular query which performs a 15-way join;
You should read
http:/
Mike Mascari <[EMAIL PROTECTED]> writes:
> I have a particular query which performs a 15-way join;
You should read
http://www.postgresql.org/devel-corner/docs/postgres/explicit-joins.html
regards, tom lane
---(end of broadcast)---
Hello.
I have a particular query which performs a 15-way join; I believe in
normalization ;-). Under 7.0.3, using the defaults where GEQO is
enabled after 11, the query (which returns 1 row) takes 10 seconds.
With GEQO turned off, it takes 18 seconds. Naturally I intend to
upgrade as soon as