Re: nbtree VACUUM's REDO routine doesn't clear page's VACUUM cycle ID - Mailing list pgsql-hackers

From Andrey M. Borodin
Subject Re: nbtree VACUUM's REDO routine doesn't clear page's VACUUM cycle ID
Date
Msg-id 81659D22-A31A-4866-A124-4E55E382E5D0@yandex-team.ru
Whole thread Raw
List pgsql-hackers

> On 15 Nov 2024, at 21:33, Peter Geoghegan <pg@bowt.ie> wrote:
>
> Attached patch teaches btree_xlog_vacuum, nbtree VACUUM's REDO
> routine, to reset the target page's opaque->btpo_cycleid to 0. This
> makes the REDO routine match original execution, which seems like a
> good idea on consistency grounds.
>
> I propose this for the master branch only.

The change seems correct to me: anyway cycle must be less than cycle of any future vacuum after promotion. I cannot say
anythingabout beauty of resetting or not resetting the field. 
I'd suggest renaming the field into something like "btpo_split_vaccycleid". I was aware of index vacuum backtracking,
butit took me a while to build context again. 


Best regards, Andrey Borodin.


pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: A way to build PSQL 17.1 source on AIX platform
Next
From: Amit Langote
Date:
Subject: Re: doc fail about ALTER TABLE ATTACH re. NO INHERIT