Re: inner join removal

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: inner join removal
Дата
Msg-id 144.1278616723@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: inner join removal  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: inner join removal
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: LLVM / clang