| 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-09 06:32:47 |
| Message-ID: | CAMbWs49tV54J7WD5EtaLabmROXeECx8-Os+yfaLk0Ywqpc_Tbw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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?
Thanks
Richard
| Attachment | Content-Type | Size |
|---|---|---|
| v7-0001-Expand-virtual-generated-columns-before-sublink-p.patch | application/octet-stream | 9.6 KB |
| v7-0002-Centralize-collection-of-catalog-info-needed-earl.patch | application/octet-stream | 15.7 KB |
| v7-0003-Reduce-Var-IS-NOT-NULL-quals-during-constant-fold.patch | application/octet-stream | 31.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sundayjiang (蒋浩天) | 2025-07-09 06:38:51 | 回复：[Internet]Re: [PATCH] Prevent replacement of a function if it's used in an index expression and is not IMMUTABLE |
| Previous Message | Dilip Kumar | 2025-07-09 06:13:48 | Re: A recent message added to pg_upgade |