Re: Avoid unnecessary wrapping for more complex expressions

Richard Guo <guofenglinux@gmail.com>

From: Richard Guo <guofenglinux@gmail.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2024-12-17T11:09:22Z
Lists: pgsql-hackers
On Wed, Dec 11, 2024 at 4:31 PM Richard Guo <guofenglinux@gmail.com> wrote:
> As mentioned in that thread, I feel that we can apply a similar
> optimization to more complex non-var expressions: if a strict
> expression contains any variables of rels that are under the same
> lowest nulling outer join as the subquery, we can also avoid wrapping
> it.

> Any thoughts?

I’ve gone ahead and pushed this patch.

Thanks
Richard



Commits

  1. Avoid unnecessary wrapping for more complex expressions

  2. Avoid unnecessary wrapping for Vars and PHVs