On Tue, Mar 6, 2012 at 4:06 PM, Simon Riggs <[email protected]> wrote: > On Tue, Mar 6, 2012 at 3:31 PM, Simon Riggs <[email protected]> wrote: > >> I'll keep an open mind for now about database/table level. I'm not >> sure how possible/desirable each is. > > Table level sounds great, but how will it work with recovery? We don't > have a relcache in Startup process. > > So either database or tablespace level seems doable.
Even db or ts level is problematic. Options (1) Recovery ignores checksums until db in consistent state (2) Recovery ignores checksums until all databases are enabled, when we set flag in pg_control (3) Recovery checks blocks marked as having a checksum, no matter the overall state -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
