Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Avoid mislabeling of lateral references when pulling up a subque - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Avoid mislabeling of lateral references when pulling up a subque
Date
Msg-id 1822436.1733242832@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql: Avoid mislabeling of lateral references when pulling up a subque  (Andrei Lepikhov <lepihov@gmail.com>)
List pgsql-committers
Tree view 
Andrei Lepikhov <lepihov@gmail.com> writes:
> Pardon the noise, but I'm curious why the optimiser must choose NestLoop 
> in the case of lateral reference.

To pass down the current outer row's value of the lateral reference.

> It would be nice to provide alternatives. Because now we have some 
> corner cases.

That's a fairly bizarre case, and I'm not at all convinced that
the old plan was correct.

            regards, tom lane

pgsql-committers by date:

Previous
From: Álvaro Herrera
Date:
Subject: pgsql: Drop "Lock" suffix from LWLock wait event names
Next
From: Álvaro Herrera
Date:
Subject: pgsql: Fix synchronized_standby_slots GUC check hook