Re: Cost of XLogInsert CRC calculations - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Cost of XLogInsert CRC calculations
Date
Msg-id 27521.1115763748@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cost of XLogInsert CRC calculations  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Cost of XLogInsert CRC calculations
Re: Cost of XLogInsert CRC calculations
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> The cause of the performance problem has been attributed to it being a
> 64-bit rather than 32-bit calculation. That is certainly part of it, but
> I have seen evidence that there is an Intel processor stall associated
> with the use of a single byte constant somewhere in the algorithm.

That's awfully vague --- can't you give any more detail?

I have seen XLogInsert eating significant amounts of time (up to 10% of
total CPU time) on non-Intel architectures, so I think that dropping
down to 32 bits is warranted in any case.  But if you are correct then
that might not fix the problem on Intel machines.  We need more info.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Table Partitioning, Part 1
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Cleaning up unreferenced table files