On 2026-Jan-16, Japin Li wrote:
> Thanks for the test. After rethinking, I agree — that BRIN/GIST index-type
> check is useless.
>
> OTOH, why don't we just do it the same way as the btree index functions?
>
> brin_page_items(relname text, blkno bigint);
Operational usefulness. If you have a corrupt page in a production, you
can extract it from there with get_raw_page() and move it to another
system to do low-level investigation. If you only have the interface
you suggest, you force the researcher to access the production system
(and run potentially dangerous tools), which may be best avoided.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
