On Wed, Jun 24, 2009 at 11:45 PM, Scott Mead<scott.lists@xxxxxxxxxxxxxxxx> wrote: > > If you're asking "Does the database have the ability to verify that > whatever is in a block is what was put into that block", then Oracle has > block check-summing (I'm not sure if this got into PG 8.4 or not...) It didn't, due to technical issues. However you should be aware that checksumming doesn't necessarily provide a broad guarantee either. It can only protect against damage that occurs between the time the checksum is generated and when it's verified. If you have bad memory, for example, it can corrupt the data before the checksum is calculated, so the block may be stored happily with a valid checksum for the corrupt data. -- greg http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
