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

From Alvaro Herrera
Subject Re: Block-level CRC checks
Date
Msg-id 20081002201349.GG4151@alvh.no-ip.org
Whole thread Raw
In response to Re: Block-level CRC checks  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
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.


pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: Block-level CRC checks
Next
From: Alvaro Herrera
Date:
Subject: Re: Block-level CRC checks