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. +
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 |