On Wed, Oct 1, 2008 at 11:36 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> I probably wouldn't compare checksumming *every* WAL record to a
>> single block-level checksum.
> No, not at all. Block-level checksums would be an order of magnitude
> more expensive: they're on bigger chunks of data and they'd be done more
That's debatable and would be dependent on cache and the workload.
In our case however, because shared buffers doesn't scale, we would
end up doing a lot more block-level checksums than the other vendors
just pushing the block to/from the OS cache.
Jonah H. Harris, Senior DBA
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2008-10-01 15:56:30|
|Subject: Re: Block-level CRC checks |
|Previous:||From: Reg Me Please||Date: 2008-10-01 15:54:01|
|Subject: Transactions within a function body|