Re: pgsql: Add pg_relation_check_pages() to check on-disk pages of a relati - Mailing list pgsql-committers

Michael Paquier <michael@paquier.xyz> writes:
> Add pg_relation_check_pages() to check on-disk pages of a relation

Seems to have some issues according to florican:

2020-10-28 00:04:40.336 EDT [27040:3] 022_page_check.pl LOG:  statement: SELECT relname, failed_block_num FROM (SELECT
relname,(pg_catalog.pg_relation_check_pages(oid)).*   FROM pg_class    WHERE relkind in ('r','i', 'm') AND oid >=
16384)AS s 
2020-10-28 00:04:53.191 EDT [27031:4] LOG:  server process (PID 27040) was terminated by signal 11: Segmentation fault
2020-10-28 00:04:53.191 EDT [27031:5] DETAIL:  Failed process was running: SELECT relname, failed_block_num FROM
(SELECTrelname, (pg_catalog.pg_relation_check_pages(oid)).*   FROM pg_class    WHERE relkind in ('r','i', 'm') AND oid
>=16384) AS s 

            regards, tom lane