Michael Paquier <[email protected]> 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 (SELECT relname,
(pg_catalog.pg_relation_check_pages(oid)).* FROM pg_class WHERE relkind in
('r','i', 'm') AND oid >= 16384) AS s
regards, tom lane