Re: WIP Join Removal

Simon Riggs <[email protected]> Tue, 02 Sep 2008 17:15:27 +0100

Newsgroups	gmane.comp.db.postgresql.devel.patches
Message-ID	<[email protected]>

On Tue, 2008-09-02 at 12:02 -0400, Tom Lane wrote:
> Simon Riggs <[email protected]> writes:
> >> Oh. How does the query look like after removing the join, then?
> 
> > Same answer, just slower. Removing the join makes the access to a into a
> > SeqScan, whereas it was a two-table index plan when both tables present.
> 
> I don't really believe this...

Yes, this will be changed. No need to review further at this stage.

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


-- 
Sent via pgsql-patches mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches