Re: Sv: Re: Sv: Re: data-checksums

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Sv: Re: Sv: Re: data-checksums
Date: 2018-01-09 22:42:45
Message-ID: 5b2a7b5e-ee96-f4a7-754e-ef7d169c023e@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)anarazel(dot)de <mailto:andres(at)anarazel(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Joseph Krogh 2018-01-09 23:25:08 Sv: Re: Sv: Re: Sv: Re: data-checksums
Previous Message Andreas Joseph Krogh 2018-01-09 22:30:28 Sv: Re: Sv: Re: data-checksums