>> 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 bgworker based mode that periodically checks your database? The work along those lines is not included in v4, but if it were part of v5, would you have specific design preferences?
v4-0001-Adding-verify_heapam-to-amcheck-contrib-module.patch
Description: Binary data
— Mark Dilger EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
