On Fri, 16 Jan 2026 at 09:55, Álvaro Herrera <[email protected]> wrote: > 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. >
Sorry, I didn't get your mind. We can still use get_raw_page(). > -- > Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ -- Regards, Japin Li ChengDu WenWu Information Technology Co., Ltd.
