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

Richard Guo <guofenglinux@gmail.com>

From: Richard Guo <guofenglinux@gmail.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Robert Haas <robertmhaas@gmail.com>, Peter Eisentraut <peter@eisentraut.org>, David Rowley <dgrowleyml@gmail.com>, Tender Wang <tndrwang@gmail.com>, Pg Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-05-28T09:28:42Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix misuse of Relids for storing attribute numbers
- 2d756ebbe857 19 (unreleased) landed
Reduce "Var IS [NOT] NULL" quals during constant folding
- e2debb64380e 19 (unreleased) landed
Centralize collection of catalog info needed early in the planner
- 904f6a593a06 19 (unreleased) landed
Expand virtual generated columns before sublink pull-up
- e0d05295268e 19 (unreleased) landed
Expand virtual generated columns in the planner
- 1e4351af329f 18.0 cited

Attachments

v5-0001-Expand-virtual-generated-columns-before-sublink-p.patch (application/octet-stream) patch v5-0001
v5-0002-Centralize-collection-of-catalog-info-needed-earl.patch (application/octet-stream) patch v5-0002
v5-0003-Reduce-Var-IS-NOT-NULL-quals-during-constant-fold.patch (application/octet-stream) patch v5-0003

On Thu, May 22, 2025 at 11:51 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> BTW, in my mind the current thread is certainly v19 material,
> so I have not looked at Richard's patch yet.

Yeah, this patchset is targeted for v19.  Maybe we could be more
aggressive and have 0001 and 0002 in v18?  (no chance for 0003 though)

This patchset does not apply anymore due to 2c0ed86d3.  Here is a new
rebase.

Thanks
Richard