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.