>> I wonder if a mode where heapcheck optionally would only checks
>> non-frozen (perhaps also non-all-visible) regions of a table would be a
>> good idea?
Version 4 of this patch now includes boolean options skip_all_frozen and skip_all_visible.
>> Would make it a lot more viable to run this regularly on
>> bigger databases. Even if there's a window to not check some data
>> (because it's frozen before the next heapcheck run).
Do you think it would make sense to have the amcheck contrib module have, in addition to the SQL queriable functions, a
bgworkerbased mode that periodically checks your database? The work along those lines is not included in v4, but if it
werepart of v5, would you have specific design preferences?
—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company