Quick Links

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

Re: [WiP] B-tree page merge during vacuum to reduce index bloat at 2025-08-27 21:06:28 from Peter Geoghegan

Responses

Re: [WiP] B-tree page merge during vacuum to reduce index bloat at 2025-08-31 12:15:32 from Andrey Borodin

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