Re: Block-level CRC checks

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: decibel <decibel(at)decibel(dot)org>
Cc: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, jd(at)commandprompt(dot)com, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Aidan Van Dyk <aidan(at)highrise(dot)ca>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Block-level CRC checks
Date: 2009-12-04 12:12:54
Message-ID: 200912041212.nB4CCsV27604@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

decibel wrote:
> On Dec 3, 2009, at 1:53 PM, Jonah H. Harris wrote:
> > On Tue, Dec 1, 2009 at 1:27 PM, Joshua D. Drake
> > <jd(at)commandprompt(dot)com> wrote:
> > On Tue, 2009-12-01 at 13:20 -0500, Robert Haas wrote:
> > > Does $COMPETITOR offer this feature?
> > >
> >
> > My understanding is that MSSQL does. I am not sure about Oracle. Those
> > are the only two I run into (I don't run into MySQL at all). I know
> > others likely compete in the DB2 space.
> >
> > To my knowledge, MySQL, InnoDB, BerkeleyDB, solidDB, Oracle, SQL
> > Server, Sybase, DB2, eXtremeDB, RDB, and Teradata all checksum pages.
>
>
> So... now that the upgrade discussion seems to have died down... was
> any consensus reached on how to do said checksumming?

I think the hint bit has to be added to the item pointer, by using the
offset bits that are already zero, according to Greg Stark. That
solution leads to easy programming, no expanding hint bit array, and it
is backward compatible so doesn't cause problems for pg_migrator.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2009-12-04 12:48:43 Re: Block-level CRC checks
Previous Message Simon Riggs 2009-12-04 12:04:17 Re: Hot standby and removing VACUUM FULL