Re: How much do the hint bits help? - Mailing list pgsql-hackers

From David Fetter
Subject Re: How much do the hint bits help?
Date
Msg-id 20101222165346.GA16815@fetter.org
Whole thread Raw
In response to Re: How much do the hint bits help?  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Wed, Dec 22, 2010 at 04:00:30PM +0000, Simon Riggs wrote:
> On Wed, 2010-12-22 at 17:42 +0200, Heikki Linnakangas wrote:
> > On 22.12.2010 17:31, Simon Riggs wrote:
> > > On Wed, 2010-12-22 at 17:01 +0200, Heikki Linnakangas wrote:
> > >> There's plenty of stuff in memory that's not covered by an
> > >> application-level CRC. That's what ECC RAM is for.
> > >
> > > http://www.google.com/research/pubs/archive/35162.pdf
> > >
> > > Google research shows that each DIMM has an 8% chance per annum of
> > > uncorrectable memory errors, even on ECC.
> > 
> > You misread that paper. From summary:
> 
> I read the paper in detail before I posted. If you think that finding an
> error in my quote disproves anything, you should read the whole paper. I
> see this:
> 
> Conclusion 1
> "... Nonetheless, the remaining incidence of 0.22% per DIMM
> per year makes a crash-tolerant application layer indispens-
> able for large-scale server farms."
> 
> What you are arguing for is a protection system that will reduce in
> effectiveness as we add more cache.
> 
> What I am arguing in favour of is an option to allow people to protect
> their data, whatever the size of their cache. I'm not forcing you or
> anyone to use it, but I think its an important option to be offering to
> our users. 

For what version of PostgreSQL are you proposing that we provide this
protection?  Let's assume that it's before 10.0 so we can get some
idea of how this will arise :)

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: How much do the hint bits help?
Next
From: Noah Misch
Date:
Subject: Re: strncmp->memcmp when we know the shorter length