Re: [PATCHES] wal_checksum = on (default) | off - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] wal_checksum = on (default) | off
Date
Msg-id 17133.1168524069@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] wal_checksum = on (default) | off  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: [PATCHES] wal_checksum = on (default) | off
Re: [PATCHES] wal_checksum = on (default) | off
List pgsql-hackers
"Simon Riggs" <simon@2ndquadrant.com> writes:
> COPY        XLogInsert() #1 on oprofile results at 17% CPU
>         (full_page_writes = on)

But what portion of that is actually CRC-related?  XLogInsert does quite
a lot.

Anyway, I can't see degrading the reliability of the system for a gain
in the range of a few percent, which is the most that we'd be likely
to get here ... for a factor of two or more, maybe people would be
willing to take a risk.

            regards, tom lane

pgsql-hackers by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: share info between backends
Next
From: Peter Eisentraut
Date:
Subject: contrib/xml2 and xml type