Re: Any optimizations to the join code in 7.1?

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(at)mascari(dot)com
>
> -----Original Message-----
> From: Tom Lane [SMTP:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Wednesday, April 25, 2001 12:42 PM
> To: mascarm(at)mascari(dot)com
> Cc: 'pgsql-hackers(at)postgresql(dot)org'
> Subject: Re: [HACKERS] Any optimizations to the join code in 7.1?
>
> Mike Mascari <mascarm(at)mascari(dot)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(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026