Skip site navigation (1) Skip section navigation (2)

Re: Undetected corruption of table files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Undetected corruption of table files
Date: 2007-08-27 15:16:55
Message-ID: 617.1188227815@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
"Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> writes:
> Tom Lane wrote:
>>> Would it be an option to have a checksum somewhere in each
>>> data block that is verified upon read?

>> That's been proposed before and rejected before.  See the archives ...

> I searched for "checksum" and couldn't find it. Could someone
> give me a pointer? I'm not talking about WAL files here.

"CRC" maybe?  Also, make sure your search goes all the way back; I think
the prior discussions were around the same time WAL was initially put
in, and/or when we dropped the WAL CRC width from 64 to 32 bits.
The very measurable overhead of WAL CRCs are the main thing that's
discouraged us from having page CRCs.  (Well, that and the lack of
evidence that they'd actually gain anything.)

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Jonah H. HarrisDate: 2007-08-27 15:26:40
Subject: Re: [HACKERS] Undetected corruption of table files
Previous:From: Joshua D. DrakeDate: 2007-08-27 15:08:34
Subject: Problem with recent permission changes commits

pgsql-general by date

Next:From: Tom LaneDate: 2007-08-27 15:25:53
Subject: Re: Tables dissapearing
Previous:From: Tom LaneDate: 2007-08-27 15:07:11
Subject: Re: [GENERAL] table column vs. out param [1:0]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group