Re: Block-level CRC checks

Robert Treat wrote:
> On Wednesday 01 October 2008 10:27:52 Tom Lane wrote:

> > Your optimism is showing ;-).  XLogInsert routinely shows up as a major
> > CPU hog in any update-intensive test, and AFAICT that's mostly from the
> > CRC calculation for WAL records.
> 
> Yeah... for those who run on filesystems that do checksumming for you, I'd bet 
> they'd much rather see time spent in turning that off rather than 
> checksumming everything else.  (just guessing) 

I don't think it can be turned off, because ISTR a failed checksum is
used to detect end of the WAL stream to be recovered.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.