Re: Protecting against unexpected zero-pages: proposal - Mailing list pgsql-hackers

From Aidan Van Dyk
Subject Re: Protecting against unexpected zero-pages: proposal
Date
Msg-id AANLkTingLW8aM=S3O0q+2iQj6-KU2TECJguW3tUAfnb8@mail.gmail.com
Whole thread Raw
In response to Re: Protecting against unexpected zero-pages: proposal  (Greg Stark <gsstark@mit.edu>)
Responses Re: Protecting against unexpected zero-pages: proposal
List pgsql-hackers
On Mon, Nov 8, 2010 at 12:53 PM, Greg Stark <gsstark@mit.edu> wrote:
> On Mon, Nov 8, 2010 at 5:00 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> So maybe Aidan's got a good idea here.  It would sure be a lot easier
>> to shoehorn checksum checking in as an optional feature if the checksums
>> were kept someplace else.
>
> Would it? I thought the only problem was the hint bits being set
> behind the checksummers back. That'll still happen even if it's
> written to a different place.

The problem that putting checksums in a different place solves is the
page layout (binary upgrade) problem.  You're still doing to need to
"buffer" the page as you calculate the checksum and write it out.
buffering that page is absolutely necessary no mater where you put the
checksum, unless you've got an exclusive lock that blocks even hint
updates on the page.

But if we can start using forks to put "other data", that means that
keeping the page layouts is easier, and thus binary upgrades are much
more feasible.

At least, that was my thought WRT checksums being out-of-page.

a.

--
Aidan Van Dyk                                             Create like a god,
aidan@highrise.ca                                       command like a king,
http://www.highrise.ca/                                   work like a slave.


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: How to share the result data of separated plan
Next
From: Tom Lane
Date:
Subject: Re: UNION ALL has higher cost than inheritance