Re: Do we need to pass down nonnullable_vars when reducing outer joins? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Do we need to pass down nonnullable_vars when reducing outer joins?
Date
Msg-id 2767582.1667678447@sss.pgh.pa.us
Whole thread Raw
In response to Do we need to pass down nonnullable_vars when reducing outer joins?  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: Do we need to pass down nonnullable_vars when reducing outer joins?
List pgsql-hackers
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.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal: possibility to read dumped table's name from file
Next
From: Nathan Bossart
Date:
Subject: Re: archive modules