Re: amcheck: add index-all-keys-match verification for B-Tree

Andrey Borodin <x4mmm@yandex-team.ru>

View thread

From: Andrey Borodin <x4mmm@yandex-team.ru>

To: Zsolt Parragi <zsolt.parragi@percona.com>

Cc: pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2026-02-27T11:21:15Z

Lists: pgsql-hackers

Attachments

v3-0001-amcheck-add-indexallkeysmatch-verification-for-B-.patch (application/octet-stream) patch v3-0001
v3-0003-Document-indexallkeysmatch-parameter-for-amcheck-.patch (application/octet-stream) patch v3-0003
v3-0002-amcheck-report-corruption-when-index-points-to-no.patch (application/octet-stream) patch v3-0002

> On 26 Feb 2026, at 10:28, Andrey Borodin <x4mmm@yandex-team.ru> wrote:
> 
> I have a gut feeling that we might do without snapshot at all...

I decided that it's a good idea to verify only visible tuples.
Mismatch of dead tuples might be bad sign, but it's not a corruption.
So we need a snapshot.

PFA patch with documentation.

Thanks!

Best regards, Andrey Borodin.