Re: Sv: Re: Sv: Re: data-checksums - Mailing list pgsql-general

From Rob Sargent
Subject Re: Sv: Re: Sv: Re: data-checksums
Date
Msg-id 5b2a7b5e-ee96-f4a7-754e-ef7d169c023e@gmail.com
Whole thread Raw
In response to Sv: Re: Sv: Re: data-checksums  (Andreas Joseph Krogh <andreas@visena.com>)
Responses Sv: Re: Sv: Re: Sv: Re: data-checksums  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-general



On 01/09/2018 03:30 PM, Andreas Joseph Krogh wrote:
På tirsdag 09. januar 2018 kl. 23:06:06, skrev Andres Freund <andres@anarazel.de>:
Hi,

On 2018-01-09 21:47:17 +0100, Andreas Joseph Krogh wrote:
> Does PG use HW-accellerated crc if CPU supports it[1]?

Yes we do, for WAL checksums. The page checksums are a different
algorithm though, one which has the advantage of being SIMD compatible.

The checksum computations have some impact, but if there's bigger impact
it's much more likely to be related to the fact that some hint bit
writes to a page now needs to be WAL logged.
 
But SIMD-instructions are also HW-accellerated by modern CPUs IIUC?
 
So, if these CRCs all are HW-accelerated the penalty chould be next to neglishable?
 

Leading directly back to JD's proposed documentation update.

pgsql-general by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Sv: Re: Sv: Re: data-checksums
Next
From: Andreas Joseph Krogh
Date:
Subject: Sv: Re: Sv: Re: Sv: Re: data-checksums