Re: Enabling Checksums - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Enabling Checksums
Date
Msg-id 5137DBD1.2090707@nasby.net
Whole thread Raw
In response to Re: Enabling Checksums  (Daniel Farina <daniel@heroku.com>)
List pgsql-hackers
On 3/4/13 7:04 PM, Daniel Farina wrote:
> Corruption has easily occupied more than one person-month of time last
> year for us.

Just FYI for anyone that's experienced corruption... we've looked into doing row-level checksums at work. The only
challengewe ran into was how to check them when reading data back. I don't remember the details but there was an issue
withdoing this via SELECT rules. It would be possible if you were willing to put writable views on all your tables
(whichisn't actually as horrible as it sounds; it wouldn't be hard to write a function to automagically do that for
you).



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [v9.3] OAT_POST_ALTER object access hooks
Next
From: Jim Nasby
Date:
Subject: Re: Enabling Checksums