RE: Any optimizations to the join code in 7.1?

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