Hi, we have a table with around 1.6 billion rows having quite lot of big binary data toasted.
Today we started getting: WIB > ERROR: invalid page in block 1288868309 of relation base/96031/96201 Which is a toast reltype. I know that zero_damaged_pages and vacuum (or restore the table from backup) will help, but I want to ask if there is a way to identify affected rows/datafiles, so we can 'fix' only the affected data using the backup/source data, instead of restoring the whole table? Thank you Regards P.
