Re: NOT IN subquery optimization

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: NOT IN subquery optimization
Дата
Msg-id CAN_9JTweDc4uu2dDGB4tngoUc9Ouc7xOyGpd+s_Bz+5dAmprQg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: NOT IN subquery optimization  ("Li, Zheng" <zhelli@amazon.com>)
Ответы Re: NOT IN subquery optimization
Список pgsql-hackers
Дерево обсуждения


On Tue, Feb 26, 2019 at 6:51 AM Li, Zheng <zhelli@amazon.com> wrote:
Resend the patch with a whitespace removed so that "git apply patch" works directly.



Hi Zheng,

I have reviewed your patch. Good job except two issues I can find:

1. The patch would give wrong results when the inner side is empty. In this
case, the whole data from outer side should be in the outputs. But with the
patch, we will lose the NULLs from outer side.

2. Because of the new added predicate 'OR (var is NULL)', we cannot use hash
join or merge join to do the ANTI JOIN.  Nested loop becomes the only choice,
which is low-efficency.

Thanks
Richard

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Nikita Glukhov
Дата:
Сообщение: Fix memleaks and error handling in jsonb_plpython
Следующее
От: Michael Paquier
Дата:
Сообщение: Tighten error control for OpenTransientFile/CloseTransientFile