Re: WIP checksums patch - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: WIP checksums patch
Date
Msg-id 1352502866.26644.15.camel@sussancws0025
Whole thread Raw
In response to Re: WIP checksums patch  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: WIP checksums patch  (Greg Smith <greg@2ndQuadrant.com>)
List pgsql-hackers
On Mon, 2012-11-05 at 12:19 -0500, Robert Haas wrote:
> Yeah.  I definitely think that we could shed an enormous amount of
> complexity by deciding that this is, for now, an option that can only
> be selected at initdb time.  That would remove approximately 85% of
> everything I've ever disliked about this patch - without, I think,
> precluding the possibility of improving things later.

That's certainly true, but it introduces one large problem: upgrading
would not work, which (in the past few releases) we've treated as a
major showstopper for many features.

If there is really no other good way to do it, then that might be
reasonable. But it seems within grasp to at least offer an offline way
to set checksums.

> It also occurred to me that another way to reduce the scope of this
> change would be to have a first version that does CRCs only for SLRU
> pages.  That would be useful for verifying the integrity of some of
> our most critical data (pg_clog) and be a useful building block toward
> a more complete implementation.

That also breaks upgrade, right?

Regards,Jeff Davis




pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Enabling Checksums
Next
From: Andres Freund
Date:
Subject: Re: Further pg_upgrade analysis for many tables