Re: amcheck: support for GiST

Andrey Borodin <x4mmm@yandex-team.ru>

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

To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-07-11T12:38:36Z

Lists: pgsql-hackers

Attachments

v2025-07-11-0003-GIN-in-pg_amcheck.patch (application/octet-stream) patch v2025-0003
v2025-07-11-0001-Add-gist_index_check-function-to-verify-.patch (application/octet-stream) patch v2025-0001
v2025-07-11-0002-Add-GiST-support-to-pg_amcheck.patch (application/octet-stream) patch v2025-0002

> On 30 Jun 2025, at 16:34, Andrey Borodin <x4mmm@yandex-team.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.