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 challenge we ran into was how to check 
them when reading data back. I don't remember the details but there was an 
issue with doing this via SELECT rules. It would be possible if you were 
willing to put writable views on all your tables (which isn't actually as 
horrible as it sounds; it wouldn't be hard to write a function to automagically 
do that for you).


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to