Re: Adding further hardening to nbtree page deletion

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Subject: Re: Adding further hardening to nbtree page deletion
Date: 2023-06-21 01:28:58
Message-ID: CAH2-WznUSCDFPv29GxTr=Hk0_A5wHp+s2X4W2fO=uHwjsHV6vA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jun 16, 2023 at 2:15 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> Attached patch adds additional hardening to nbtree page deletion. It
> makes nbtree VACUUM tolerate a certain sort of cross-page
> inconsistencies in the structure of an index (corruption). VACUUM can
> press on, avoiding an eventual wraparound/xidStopLimit failure in
> environments where nobody notices the problem for an extended period.

My current plan is to commit this in the next couple of days. I'll
backpatch all the way, like last time.

--
Peter Geoghegan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Smith 2023-06-21 02:31:46 Re: Consistent coding for the naming of LR workers
Previous Message Michael Paquier 2023-06-21 01:21:04 Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX