: 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://www.postgresql.org
]
-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 optimizations to the join code in 7.1?
Mike Mascari [EMAIL PROTECTED] writes:
I have
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
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
