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-22 02:55:14
Message-ID: CAMbWs4-+tm=ueQ71QLvzigUntYSUF1WDVNeCHP_QS5YCRoM4YA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jul 16, 2025 at 10:57 AM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> On Wed, Jul 9, 2025 at 3:32 PM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> > 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.

Hearing nothing, I've gone ahead and pushed the patchset. Thanks for
all the reviews and discussion.

Thanks
Richard

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Guo 2025-07-22 03:12:25 redis_fdw failure on crake
Previous Message David Rowley 2025-07-22 02:25:27 Re: [PATCH] Check for TupleTableSlot nullness before dereferencing