From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jim Nasby <decibel(at)decibel(dot)org>, Zeugswetter Andreas ADI SD <ZeugswetterA(at)spardat(dot)at>, pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: [HACKERS] [PATCHES] wal_checksum = on (default) | off |
Date: | 2007-01-11 04:32:51 |
Message-ID: | 200701110432.l0B4Wpj21366@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Simon Riggs wrote:
> On Fri, 2007-01-05 at 22:57 -0500, Tom Lane wrote:
> > Jim Nasby <decibel(at)decibel(dot)org> writes:
> > > On Jan 5, 2007, at 6:30 AM, Zeugswetter Andreas ADI SD wrote:
> > >> Ok, so when you need CRC's on a replicate (but not on the master) you
> >
> > > Which sounds to me like a good reason to allow the option in
> > > recovery.conf as well...
> >
> > Actually, I'm not seeing the use-case for a slave having a different
> > setting from the master at all?
> >
> > "My backup server is less reliable than the primary."
> >
> > "My backup server is more reliable than the primary."
> >
> > 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.
I am assuming this item is dead because no performance results have been
reported.
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-01-11 04:48:00 | Re: InitPostgres and flatfiles question |
Previous Message | Tom Lane | 2007-01-11 04:31:41 | Re: [COMMITTERS] pgsql: Stamp major release 8.3.0, |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2007-01-11 10:20:38 | Re: Remove of .SECONDARY from SGML Makefile |
Previous Message | Bruce Momjian | 2007-01-11 04:19:12 | Re: [PATCHES] COPY with no WAL, v2 |