Re: Reduce "Var IS [NOT] NULL" quals during constant folding

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, David Rowley <dgrowleyml(at)gmail(dot)com>, Tender Wang <tndrwang(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Reduce "Var IS [NOT] NULL" quals during constant folding
Date: 2025-07-16 01:57:51
Message-ID: CAMbWs4_Hhpp0WG_82h70OBGYiEYVOh3=9tEsD87E_ghw8YmmJQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jul 9, 2025 at 3:32 PM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> On Mon, Jun 30, 2025 at 4:26 PM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> > On Wed, May 28, 2025 at 6:28 PM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> > > This patchset does not apply anymore due to 2c0ed86d3. Here is a new
> > > rebase.
>
> > This patchset does not apply anymore, due to 5069fef1c this time.
> > Here is a new rebase.
>
> Here is a new rebase. I moved the call to preprocess_relation_rtes to
> a later point within convert_EXISTS_sublink_to_join, so we can avoid
> the work if it turns out that the EXISTS SubLink cannot be flattened.
> Nothing essential has changed.
>
> The NOT-IN pullup work depends on the changes in this patchset (it
> also relies on the not-null information), so I'd like to move it
> forward.
>
> Hi Tom, Robert -- just to be sure, are you planning to take another
> look at it?

I'm aiming to push this patchset next week, barring any objections.

Thanks
Richard

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Guo 2025-07-16 02:30:35 Re: Pathify RHS unique-ification for semijoin planning
Previous Message Fujii Masao 2025-07-16 01:39:07 Re: Document default values for pgoutput options + fix missing initialization for "origin"