Re: Correction of RowMark Removal During Sel-Join Elimination

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Richard Guo <guofenglinux(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrei Lepikhov <lepihov(at)gmail(dot)com>, Greg Sabino Mullane <htamfids(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Alexander Lakhin <exclusion(at)gmail(dot)com>
Subject: Re: Correction of RowMark Removal During Sel-Join Elimination
Date: 2025-08-31 00:49:50
Message-ID: CAPpHfds95Y3DGESNwpo=dhpcnM-fECMhiTXj_KTSXmWbgC2BtA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Aug 31, 2025 at 2:51 AM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> On Sun, Aug 31, 2025 at 8:41 AM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> > On Sun, Aug 31, 2025 at 8:12 AM Alexander Korotkov <aekorotkov(at)gmail(dot)com> wrote:
> > > The same patch with a bit revised comment and commit message.
>
> > FWIW, I reported this same issue and proposed the patch last week in
> > Discussion: https://postgr.es/m/CAMbWs48x=GsGan_bvQ+j0rLqYFNi9W725EmJpWUZv1RrmaicZQ@mail.gmail.com
>
> I think it's better to push this patch sooner rather than later, as
> multiple people have encountered the issue in different ways. I'll go
> ahead and push 0001 from my patch set shortly.

I see. You're much farther than I'm. Please, go ahead pushing this.

> I don't think we need
> to backpatch it, since the issue only occurs after commit e2debb643.

I think you're right.

------
Regards,
Alexander Korotkov
Supabase

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Guo 2025-08-31 01:03:44 Re: Correction of RowMark Removal During Sel-Join Elimination
Previous Message Richard Guo 2025-08-30 23:51:24 Re: Correction of RowMark Removal During Sel-Join Elimination