Re: Substituting Checksum Algorithm (was: Enabling Checksums) - Mailing list pgsql-hackers

From Noah Misch
Subject Re: Substituting Checksum Algorithm (was: Enabling Checksums)
Date
Msg-id 20130430231204.GC27134@tornado.leadboat.com
Whole thread Raw
In response to Re: Substituting Checksum Algorithm (was: Enabling Checksums)  (Greg Smith <greg@2ndQuadrant.com>)
List pgsql-hackers
Orthogonal to this thread, but:

On Tue, Apr 30, 2013 at 06:39:09PM -0400, Greg Smith wrote:
> The WAL logging of hint bits is where the scary stuff to me for this  
> feature has always been at.  My gut feel is that doing that needed to  
> start being available as an option anyway.  Just this month we've had  
> two customer issues pop up where we had to look for block differences  
> between a master and a standby.  The security update forced some normal  
> update stragglers to where they now have the 9.1.6 index corruption fix,  
> and we're looking for cases where standby indexes might have been  
> corrupted by it.  In this case the comparisons can just avoid anything  
> but indexes, so hint bits are thankfully not involved.

B-tree indexes have hints; see callers of ItemIdMarkDead().

-- 
Noah Misch
EnterpriseDB                                 http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Substituting Checksum Algorithm (was: Enabling Checksums)
Next
From: Jeff Janes
Date:
Subject: Re: Incomplete description of pg_start_backup?