Re: Page Checksums

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Page Checksums
Date: 2011-12-18 08:14:38
Message-ID: 4EEDA0EE.7060006@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 17.12.2011 23:33, David Fetter wrote:
> What:
>
> Please find attached a patch for 9.2-to-be which implements page
> checksums. It changes the page format, so it's an initdb-forcing
> change.
>
> How:
> In order to ensure that the checksum actually matches the hint
> bits, this makes a copy of the page, calculates the checksum, then
> sends the checksum and copy to the kernel, which handles sending
> it the rest of the way to persistent storage.
>...
> If this introduces new failure modes, please detail, and preferably
> demonstrate, just what those new modes are.

Hint bits, torn pages -> failed CRC. See earlier discussion:

http://archives.postgresql.org/pgsql-hackers/2009-11/msg01975.php

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gianni Ciolli 2011-12-18 08:28:12 Autonomous subtransactions
Previous Message Bruce Momjian 2011-12-18 05:04:19 Re: Command Triggers