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

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Peter Geoghegan <pg(at)bowt(dot)ie>, boekewurm+postgres(at)gmail(dot)com
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Kirk Wolak <wolakk(at)gmail(dot)com>, Nikolay Samokhvalov <nik(at)postgres(dot)ai>
Subject: Re: [WiP] B-tree page merge during vacuum to reduce index bloat
Date: 2025-08-29 08:39:48
Message-ID: 3F0FC1DC-3653-4F61-A46F-46FF81C14915@yandex-team.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter, Matthias, many thanks for your input!

> On 28 Aug 2025, at 01:06, Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
>
> Have you benchmarked it?

Kind of. Here are bloat charts from random production clusters:

Attachment Content-Type Size
image/jpeg 35.2 KB
unknown_filename text/plain 1 byte
image/jpeg 37.8 KB
unknown_filename text/plain 1.4 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message shveta malik 2025-08-29 08:44:38 Re: POC: enable logical decoding when wal_level = 'replica' without a server restart
Previous Message Matthias van de Meent 2025-08-29 08:38:39 Re: Adding skip scan (including MDAM style range skip scan) to nbtree