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