Re: Block-level CRC checks - Mailing list pgsql-hackers

From pgsql@mohawksoft.com
Subject Re: Block-level CRC checks
Date
Msg-id 39053.71.232.149.185.1222868334.squirrel@mail.mohawksoft.com
Whole thread Raw
In response to Re: Block-level CRC checks  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Block-level CRC checks
List pgsql-hackers
> Hannu Krosing <hannu@2ndQuadrant.com> writes:
>> So I don't think that this is a space issue.
>
> No, it's all about time penalties and loss of concurrency.

I don't think that the amount of time it would take to calculate and test
the sum is even important. It may be in older CPUs, but these days CPUs
are so fast in RAM and a block is very small. On x86 systems, depending on
page alignment, we are talking about two or three pages that will be "in
memory" (They were used to read the block from disk or previously
accessed).




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Common Table Expressions (WITH RECURSIVE) patch
Next
From: Brian Hurt
Date:
Subject: Re: Block-level CRC checks