Re: amcheck: support for GiST

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: amcheck: support for GiST
Date: 2025-07-11 12:38:36
Message-ID: 41F2A10C-4577-413B-9140-BE81CCE04A60@yandex-team.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 30 Jun 2025, at 16:34, Andrey Borodin <x4mmm(at)yandex-team(dot)ru> wrote:
>
> Please find attached two new steps for amcheck:
> 1. A function to verify GiST integrity. This patch is in decent shape, simply rebased from previous year.
> 2. Support on pg_amcheck's side for this function. This patch did not receive such review attention before. And, perhaps, should be extended to support existing GIN functions.

Here's a version that adds GIN functions to pg_amcheck.
IDK, maybe we should split pg_amcheck part into another thread and add there BRIN too...

Thanks!

Best regards, Andrey Borodin.

Attachment Content-Type Size
v2025-07-11-0003-GIN-in-pg_amcheck.patch application/octet-stream 10.0 KB
v2025-07-11-0001-Add-gist_index_check-function-to-verify-.patch application/octet-stream 34.2 KB
v2025-07-11-0002-Add-GiST-support-to-pg_amcheck.patch application/octet-stream 35.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2025-07-11 13:27:45 Re: [Question] Window Function Results without ORDER BY Clause
Previous Message cca5507 2025-07-11 12:30:25 Re: Small optimization with expanding dynamic hash table