pageinspect support for SpGiST

From: Kirill Reshke <reshkekirill(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: pageinspect support for SpGiST
Date: 2026-01-10 18:05:50
Message-ID: CALdSSPhbAQbFtjK0nT8_G5GsXmsSEVx8J735Ga+ZxLp9osHcRA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers!

I am currently working for amcheck & pageinspect support for SpGiST indices.
Here is a patch implementing the pageinspect part.

My current design is two functions, which are

* spgist_page_opaque_info - akin to gin/gist opaque info functions.
* spgist_page_items - function that returns information about tuples
on the SpGiST page. Currently this works only for LEAF pages, Internal
pages to be supported.

Following "Desirability -> Design -> Implement -> Test -> Review ->
Commit" developing process, posting v1 patch with PoC and looking for
Desirability/Design feedback.

PFA (WIP) v1.

--
Best regards,
Kirill Reshke

Attachment Content-Type Size
v1-0001-Add-pageinspect-support-for-SpGiST-indexes.patch application/octet-stream 15.8 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuya Kawata 2026-01-10 18:25:16 Re: [PATCH] Add sampling statistics to autoanalyze log output
Previous Message Mihail Nikalayeu 2026-01-10 17:37:06 Re: Adding REPACK [concurrently]