Re: 16-bit page checksums for 9.2

Andres Freund <andres@anarazel.de>

From: Andres Freund <andres@anarazel.de>
To: pgsql-hackers@postgresql.org
Cc: Simon Riggs <simon@2ndquadrant.com>, Stephen Frost <sfrost@snowman.net>, Jim Nasby <jim@nasby.net>, Kevin Grittner <Kevin.Grittner@wicourts.gov>, aidan@highrise.ca, stark@mit.edu
Date: 2012-01-06T10:36:08Z
Lists: pgsql-hackers
On Friday, January 06, 2012 11:30:53 AM Simon Riggs wrote:
> On Fri, Jan 6, 2012 at 1:10 AM, Stephen Frost <sfrost@snowman.net> wrote:
> > * Simon Riggs (simon@2ndQuadrant.com) wrote:
> >> I discover that non-all-zeroes holes are fairly common, just not very
> >> frequent.
> > 
> > Curious, might be interesting to find out why.
> > 
> >> That may or may not be a problem, but not something to be dealt with
> >> here and now.
> > 
> > But I agree that it's not the job of this patch/effort.  It sounds like
> > we have clear indication, however, that those areas, as they are not
> > necessairly all zeros, should be included in the checksum.
> 
> Disagree. Full page writes ignore the hole, so its appropriate to do
> so here also.
Well, ignoriging them in fpw has clear space benefits. Ignoring them while 
checksumming doesn't have that much of a benefit.

Andres