Re: [PATCHES] wal_checksum = on (default) | off - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [PATCHES] wal_checksum = on (default) | off
Date
Msg-id 200701062130.l06LU8928517@momjian.us
Whole thread Raw
In response to Re: [PATCHES] wal_checksum = on (default) | off  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs wrote:
> > Somehow, neither of these statements seem likely to be uttered by
> > a sane DBA ...
>
> If I take a backup of a server and bring it up on a new system, the
> blocks in the backup will not have been CRC checked before they go to
> disk.
>
> If I take the same server and now stream log records across to it, why
> *must* that data be CRC checked, when the original data has not been?
>
> I'm proposing choice, with a safe default. That's all.

Are there performance numbers to justify the option?  We don't give
people options unless there is real value to it.

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: 8.3 pending patch queue
Next
From: Dave Page
Date:
Subject: Re: 8.3 pending patch queue