You can thank Tom Lane for most/all of our optimization improvements.
> 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])
>
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
