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