Re: pgsql: Avoid improbable PANIC during heap_update. - Mailing list pgsql-committers

From Peter Geoghegan
Subject Re: pgsql: Avoid improbable PANIC during heap_update.
Date
Msg-id CAH2-Wzmb3ENhfaLVv=+TwQyHSbUxvhsOPWo7Lsw7o-1kUbpzXw@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Avoid improbable PANIC during heap_update.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgsql: Avoid improbable PANIC during heap_update.
List pgsql-committers
On Fri, Sep 30, 2022 at 2:56 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > FWIW it seems possible that the Postgres 15 vacuumlazy.c work that
> > added lazy_scan_noprune() made this scenario more likely in practice
> > -- even compared to Postgres 14.
>
> Could be, because we haven't seen field reports of this in v14 yet.

I would be more confident here were it not for the recent
heap_delete() issue reported by one of my AWS colleagues (and fixed by
another, Jeff Davis). See commit 163b0993 if you missed it before now.

> And there's still no hard evidence of a bug pre-14.  Nonetheless,
> I'm inclined to backpatch to v12 as 34f581c39 was.

+1

-- 
Peter Geoghegan



pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Avoid improbable PANIC during heap_update.
Next
From: Tom Lane
Date:
Subject: pgsql: Avoid improbable PANIC during heap_update, redux.