pgsql: nbtree VACUUM: Cope with buggy opclasses.

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: nbtree VACUUM: Cope with buggy opclasses.
Date: 2021-03-23 23:11:27
Message-ID: E1lOqBL-0000mr-17@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

nbtree VACUUM: Cope with buggy opclasses.

Teach nbtree VACUUM to press on with vacuuming in the event of a page
deletion attempt that fails to "re-find" a downlink for its child/target
page.

There is no good reason to treat this as an irrecoverable error. But
there is a good reason not to: pressing on at this point removes any
question of VACUUM not making progress solely due to misbehavior from
user-defined operator class code.

Discussion: https://postgr.es/m/CAH2-Wzma5G9CTtMjbrXTwOym+U=aWg-R7=-htySuztgoJLvZXg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/5b861baa550a369e04bf67fbe83f3a5a8c742fb4

Modified Files
--------------
src/backend/access/nbtree/nbtpage.c | 18 +++++++++++++++++-
1 file changed, 17 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tomas Vondra 2021-03-24 00:19:24 pgsql: Allow composite types in catalog bootstrap
Previous Message Tom Lane 2021-03-23 21:12:29 Re: pgsql: Add a new GUC and a reloption to enable inserts in parallel-mode