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

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: amcheck: add index-all-keys-match verification for B-Tree
Date: 2026-02-27 11:21:15
Message-ID: 9A5AEB25-5E58-4657-9064-7D4F8D50A77D@yandex-team.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 26 Feb 2026, at 10:28, Andrey Borodin <x4mmm(at)yandex-team(dot)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.

Attachment Content-Type Size
v3-0001-amcheck-add-indexallkeysmatch-verification-for-B-.patch application/octet-stream 28.1 KB
v3-0003-Document-indexallkeysmatch-parameter-for-amcheck-.patch application/octet-stream 5.8 KB
v3-0002-amcheck-report-corruption-when-index-points-to-no.patch application/octet-stream 2.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Henson Choi 2026-02-27 11:30:57 Re: Row pattern recognition
Previous Message Amit Kapila 2026-02-27 11:07:28 Re: [PATCH] Support automatic sequence replication