Re: remove_useless_joins vs. bug #19560

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: Richard Guo <guofenglinux(at)gmail(dot)com>, Thom Brown <thom(at)linux(dot)com>, Jacob Brazeal <jacob(dot)brazeal(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, underdog(at)theori(dot)io
Subject: Re: remove_useless_joins vs. bug #19560
Date: 2026-09-27 16:32:12
Message-ID: 330465.1790526732@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wrote:
> Concretely, about like this. This fixes the given reproducer.
> I've not put thought into what sort of test cases we might want
> to add.

Now with test cases, a commit message explaining why do it like
this, and a bit of additional comment-polishing.

regards, tom lane

Attachment Content-Type Size
v1-0001-Prevent-self-join-elimination-when-RTEs-checkAsUs.patch text/x-diff 10.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey Borodin 2026-09-27 17:16:51 Re: pg_rewind does not rewind diverging timelines
Previous Message shihao zhong 2026-09-27 16:23:20 Re: aio: worker: Free SMGR objects when idle