Re: amcheck: support for GiST

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Miłosz Bieniek <bieniek(dot)milosz(at)proton(dot)me>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: amcheck: support for GiST
Date: 2025-12-16 12:02:52
Message-ID: 932B42FE-318E-4158-8676-43A76FACB75B@yandex-team.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Miłosz and Sergey!

Thanks a lot for reviewing this patch!

> On 9 Dec 2025, at 23:54, Miłosz Bieniek <bieniek(dot)milosz(at)proton(dot)me> wrote:
>
> Hi,
> Together with Sergey we did a review and found a few things that need fixing:
>
> - `contrib/amcheck/amcheck--1.5--1.6.sql:14` - missing space after comma

Fixed.

> - `verify_gist.c` should be the second entry in meson.build, not at the end

Fixed.

> - Some function arguments like `(GistCheckState * check_state, GistScanItem * stack)` have extra spaces after the `*` - should be `(GistCheckState *check_state, GistScanItem *stack)`

Fixed.

> - Missing `#include "access/itup.h"` in `verify_common.h`

I do not understand why. Perhaps, optimizing headers would be a good idea. This file is not included by any of files that include verify_common.h.

> - Missing test file `007verify_gist_.pl` (not sure if should be created)

I don't think we ever had it for gist.

> - `contrib/amcheck/sql/check_gist.sql` - missing cleanup statement `DROP TABLE toast_bug;`

Fixed.

Thanks!

Best regards, Andrey Borodin.

Attachment Content-Type Size
v20251216-0001-Move-normalize-tuple-logic-from-nbtcheck-t.patch application/octet-stream 9.1 KB
v20251216-0003-Address-review-comments-by-Mi-osz-and-Serg.patch application/octet-stream 3.7 KB
v20251216-0002-Add-gist_index_check-function-to-verify-Gi.patch application/octet-stream 33.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2025-12-16 12:18:25 Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)
Previous Message vignesh C 2025-12-16 11:52:36 Re: pg_dump crash due to incomplete ordering of DO_SUBSCRIPTION_REL objects