Re: inner join removal - Mailing list pgsql-hackers

From Tom Lane
Subject Re: inner join removal
Date
Msg-id 144.1278616723@sss.pgh.pa.us
Whole thread Raw
In response to Re: inner join removal  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Thu, Jul 8, 2010 at 3:05 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Right, but look for example at the logic involved with the current outer
>> join transformation identity #3, which can't be applied unless the join
>> predicate is strict for the left-hand side. �We avoid doing the dogwork
>> to test that more than once.

> Uh... where exactly is that logic?  I've been looking for it for 2
> years and haven't found it yet.

Look at the code that deals with SpecialJoinInfo.lhs_strict.  There
isn't very much of it (which is precisely my point ...)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: inner join removal
Next
From: Peter Eisentraut
Date:
Subject: Re: LLVM / clang