On Tue, Oct 18, 2022 at 9:15 AM Andy Fan wrote:
> On Mon, Oct 10, 2022 at 10:35 AM Richard Guo
> wrote:
>
>> ... I'm asking because
>> PHVs may imply lateral dependencies which may make us have to use
>> nestloop join.
>>
>
> I thought lateral join imply nestloop join, am I missing something?
Hi Richard:
On Mon, Oct 10, 2022 at 10:35 AM Richard Guo wrote:
> ... I'm asking because
> PHVs may imply lateral dependencies which may make us have to use
> nestloop join.
>
I thought lateral join imply nestloop join, am I missing something? Here
is my simple
testing.
postgres=# explain (c
On Mon, Oct 10, 2022 at 10:35 AM Richard Guo wrote:
> As we know when we pull up a simple subquery, if the subquery is within
> the nullable side of an outer join, lateral references to non-nullable
> items may have to be turned into PlaceHolderVars. I happened to wonder
> what should we do about
Hi hackers,
As we know when we pull up a simple subquery, if the subquery is within
the nullable side of an outer join, lateral references to non-nullable
items may have to be turned into PlaceHolderVars. I happened to wonder
what should we do about the PHVs if the outer join is reduced to inner
j
