Re: Do we need to pass down nonnullable_vars when reducing outer joins?

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: Do we need to pass down nonnullable_vars when reducing outer joins?
Дата
Msg-id CAMbWs4-gXvaZp-EubSAK0-wJosXCSYm+s=W3mNAVR2nP7uERmw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Do we need to pass down nonnullable_vars when reducing outer joins?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

On Sun, Nov 6, 2022 at 4:00 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Richard Guo <guofenglinux@gmail.com> writes:
> AFAICS, the Vars forced nonnullable by given clause are only used to
> check if we can reduce JOIN_LEFT to JOIN_ANTI, and it is checking the
> join's own quals there. It seems to me we do not need to pass down
> nonnullable_vars by upper quals to the children of a join.

Hmm, you are right, we are not doing anything useful with that data.
I can't remember if I had a concrete plan for doing something with it
or not, but we sure aren't using it now.  So pushed.
 
Thanks for pushing it!

Thanks
Richard

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

Предыдущее
От: Richard Guo
Дата:
Сообщение: Re: Check SubPlan clause for nonnullable rels/Vars
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: Perform streaming logical transactions by background workers and parallel apply