Re: [WiP] B-tree page merge during vacuum to reduce index bloat - Mailing list pgsql-hackers

From Madhav Madhusoodanan
Subject Re: [WiP] B-tree page merge during vacuum to reduce index bloat
Date
Msg-id CAKw2Pb2ga_MKhc4HsfiO9xKNcCUv2H=wg3zxMR4=EBPDNWEcfA@mail.gmail.com
Whole thread
In response to Re: [WiP] B-tree page merge during vacuum to reduce index bloat  (Matthias van de Meent <boekewurm+postgres@gmail.com>)
List pgsql-hackers
On Tue, Mar 10, 2026 at 5:23 PM Matthias van de Meent
<boekewurm+postgres@gmail.com> wrote:
>
> They're exclusively for btree code's use; extensions (*) must not add
> to (or change the meaning of) those bits, lest they create a forward
> incompatibility with core PostgreSQL btree code in newer major
> versions; it would cause corrupted binary upgraded databases.
> But patches against core btree code can use those bits, because
> forward compatibility is less of an issue there - we don't really
> support binary upgrades manually patched systems, especially if they
> have incompatible on-disk data.

Noted, I'm looking at it from the core btree code side of things.
I'm unable to see a way where scans or VACUUM calls can recognise
transient merge states if we implement merging as an extension.

Madhav



pgsql-hackers by date:

Previous
From: Jim Jones
Date:
Subject: Re: Add XMLNamespaces to XMLElement
Next
From: Shiju Sivadazz
Date:
Subject: Question about heap_inplace_update and VACUUM behavior