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.