From:
"Simon Riggs" <simon(at)2ndquadrant(dot)com>
To:
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
<pgsql-hackers(at)postgresql(dot)org>,<pgsql-patches(at)postgresql(dot)org>
Subject:
Re: [HACKERS] wal_checksum = on (default) | off
Date:
2007-01-04 17:53:44
Message-ID:
1167933225.20749.216.camel@silverbirch.site (view raw or flat )
Thread:
2007-01-04 14:27:56 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-01-04 15:00:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-01-04 15:56:39 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-01-04 16:09:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-01-04 16:51:50 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-01-04 17:13:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-01-04 17:53:44 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-01-05 10:01:31 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-01-05 10:35:47 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-01-05 11:30:46 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-01-05 14:39:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-01-05 16:25:08 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-01-05 21:41:01 from Jim Nasby <decibel(at)decibel(dot)org>
2007-01-06 03:57:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-01-06 04:05:56 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-01-06 14:41:02 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-01-06 21:30:08 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-01-11 04:32:51 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-01-11 11:32:12 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-01-11 14:01:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-01-11 14:54:52 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-01-11 14:59:26 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-01-11 15:07:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-01-11 16:18:36 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-01-11 16:22:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-01-11 16:25:28 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-01-11 16:37:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-01-11 17:06:11 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-01-11 23:10:38 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-01-12 10:09:28 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2007-01-04 16:58:51 from Florian Weimer <fweimer(at)bfk(dot)de>
2007-01-04 17:05:04 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-01-04 17:07:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-01-04 19:18:12 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2007-01-04 19:43:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-01-04 20:16:02 from Florian Weimer <fw(at)deneb(dot)enyo(dot)de>
2007-01-04 20:22:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-01-04 21:48:56 from Florian Weimer <fw(at)deneb(dot)enyo(dot)de>
2007-01-04 22:03:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-hackers pgsql-patches
On Thu, 2007-01-04 at 12:13 -0500, Tom Lane wrote:
> "Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> > On Thu, 2007-01-04 at 11:09 -0500, Tom Lane wrote:
> >> "It works most of the time" doesn't exactly satisfy me.
>
> > It seemed safer to allow a very rare error through to the next level of
> > error checking rather than to close the door so tight that recovery
> > would not be possible in a very rare case.
>
> If a DBA is turning checksums off at all, he's already bought into the
> assumption that he's prepared to recover from backups. What you don't
> seem to get here is that this "feature" is pretty darn questionable in
> the first place, and for it to have a side effect of poking a hole in
> the system's reliability even when it's off is more than enough to get
> it rejected outright. It's just a No Sale.
I get it, and I listened. I'm was/am happy to do it the way you
suggested; I was merely explaining that I had considered the issue.
New patch enclosed.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
In response to
pgsql-hackers by date
Next :From: Tom LaneDate: 2007-01-04 17:58:37Subject : Re: Small vcbuild patch Previous :From : Andrew DunstanDate : 2007-01-04 17:24:10Subject : Re: 8.3 pending patch queue
pgsql-patches by date
Next :From: Tom LaneDate: 2007-01-04 17:58:37Subject : Re: Small vcbuild patch Previous :From : Tom LaneDate : 2007-01-04 17:13:57Subject : Re: [HACKERS] wal_checksum = on (default) | off
