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
> mascarm@mascari.com
>
> -----Original Message-----
> From: Tom Lane [SMTP:tgl@sss.pgh.pa.us]
> Sent: Wednesday, April 25, 2001 12:42 PM
> To: mascarm@mascari.com
> Cc: 'pgsql-hackers@postgresql.org'
> Subject: Re: [HACKERS] Any optimizations to the join code in 7.1?
>
> Mike Mascari <mascarm@mascari.com> 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 majordomo@postgresql.org)
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
