| From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Andy Fan <zhihuifan1213(at)163(dot)com>, wenhui qiu <qiuwenhuifx(at)gmail(dot)com> |
| Subject: | Re: Pathify RHS unique-ification for semijoin planning |
| Date: | 2025-07-16 02:30:35 |
| Message-ID: | CAMbWs48vr3VkUOmy-2_Skapk8RTHYuGngAhEQdGVyPO2PQ+x2g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Jul 4, 2025 at 10:41 AM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> On Thu, Jul 3, 2025 at 7:06 PM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> > This patch does not apply again, so here is a new rebase.
> >
> > This version also fixes an issue related to parameterized paths: if
> > the RHS has LATERAL references to the LHS, unique-ification becomes
> > meaningless because the RHS depends on the LHS, and such paths should
> > not be generated.
> (The cc list is somehow lost; re-ccing.)
The CI reports a test failure related to this patch, although I'm
quite confident it's unrelated to the changes introduced here.
The failure is: recovery/009_twophase time out (After 1000 seconds)
In any case, here's a freshly rebased version.
Hi Tom, I wonder if you've had a chance to look at this patch. It
would be great to have your input.
Thanks
Richard
| Attachment | Content-Type | Size |
|---|---|---|
| v5-0001-Pathify-RHS-unique-ification-for-semijoin-plannin.patch | application/octet-stream | 106.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ajin Cherian | 2025-07-16 03:08:04 | Re: 024_add_drop_pub.pl might fail due to deadlock |
| Previous Message | Richard Guo | 2025-07-16 01:57:51 | Re: Reduce "Var IS [NOT] NULL" quals during constant folding |