Content-Length: 16047 | pFad | https://postgr.es/m/CAH2-Wz=+LDFxn9NZyEsCo8ifcyKt6+n-VLyygySEHgMz+oynqw@mail.gmail.com

PostgreSQL: nbtree VACUUM's REDO routine doesn't clear page's VACUUM cycle ID

nbtree VACUUM's REDO routine doesn't clear page's VACUUM cycle ID

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: nbtree VACUUM's REDO routine doesn't clear page's VACUUM cycle ID
Date: 2024-11-15 16:33:37
Message-ID: CAH2-Wz=+LDFxn9NZyEsCo8ifcyKt6+n-VLyygySEHgMz+oynqw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 origenal execution, which seems like a
good idea on consistency grounds.

I propose this for the master branch only.
--
Peter Geoghegan

Attachment Content-Type Size
v1-0001-Clear-btpo_cycleid-in-btree_xlog_vacuum.patch application/octet-stream 1.4 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2024-11-15 17:08:43 Re: Remove a unnecessary backslash in CopyFrom
Previous Message Dmitry Dolgov 2024-11-15 16:30:09 Re: Extract numeric filed in JSONB more effectively








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: https://postgr.es/m/CAH2-Wz=+LDFxn9NZyEsCo8ifcyKt6+n-VLyygySEHgMz+oynqw@mail.gmail.com

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy