Sorry for the delay in the response. It took be a day to get
everything upgraded to 7.1. To restate the problem - in 7.0 with
GEQO enabled, a 15-way join took 10 seconds. With GEQO disabled it
took 18 seconds. 7.1 out of the box took only 2 seconds! I was amazed
and shocked at this damned impressive improvement in planning
speed....until I actually used the explicit JOIN syntax described in
11.2. Instanteous results! Instantaneous.....
Thanks a bunch,
(still 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 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/devel-corner/docs/postgres/explicit-join
s.html
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
