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@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