Re: Join Removal/ Vertical Partitioning - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Join Removal/ Vertical Partitioning
Date
Msg-id 12000.1214603444@sss.pgh.pa.us
Whole thread Raw
In response to Re: Join Removal/ Vertical Partitioning  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Join Removal/ Vertical Partitioning
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> On Thu, 2008-06-26 at 13:42 -0400, Tom Lane wrote:
>> It might be possible to treat "ignore the RHS" as a join strategy and
>> try to apply it while forming join relations, which would be late enough
>> to have all the needed info available.

> Oh, actually have a join node that is a no-op, with a path cost of zero?

Not even that: just return the best path(s) for the LHS as the paths for
the joinrel.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: gsoc, text search selectivity and dllist enhancments
Next
From: Jean-Michel Pouré
Date:
Subject: XML index support