pg_relation_check_pages()

A proposed system function for checking on-disk pages of a relation
This entry relates to a proposed PostgreSQL feature which was withdrawn before becoming available in a public release.

pg_relation_check_pages() is a proposed system function for checking on-disk pages of a relation.

pg_relation_check_pages() was initially added in PostgreSQL 14 but subsequently withdrawn. It's not clear whether a re-worked version will be re-added.

Usage

pg_relation_check_pages() returns a list of tuples consisting of:

  • the physical file where a broken page has been detected
  • the block number of the broken page

No rows are returned if no broken pages are detected.

Change history

Categories

Withdrawn