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