Re: Cost of XLogInsert CRC calculations

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Cost of XLogInsert CRC calculations
Дата
Msg-id 27521.1115763748@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Cost of XLogInsert CRC calculations  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Cost of XLogInsert CRC calculations  (Simon Riggs <simon@2ndquadrant.com>)
Re: Cost of XLogInsert CRC calculations  ("Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Table Partitioning, Part 1
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCHES] Cleaning up unreferenced table files