Re: [HACKERS] Clock with Adaptive Replacement

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [HACKERS] Clock with Adaptive Replacement
Дата
Msg-id 20180430181515.gu7pei6sg6wbkqcq@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [HACKERS] Clock with Adaptive Replacement  (Andrey Borodin <x4mmm@yandex-team.ru>)
Ответы Re: [HACKERS] Clock with Adaptive Replacement  (Andrey Borodin <x4mmm@yandex-team.ru>)
Список pgsql-hackers
Hi,

On 2018-04-30 15:39:08 +0500, Andrey Borodin wrote:
> I suspect that performance benefits can be not that big or even
> marginal, if we do not extend comprehensive eviction strategy with
> bgwriter fixes and O_DIRECT.

If so, then the improvements aren't real. Bgwriter doesn't matter for
read-only workloads. O_DIRECT doesn't matter much if shared_buffers are
60+% of OS memory.  And even disregarding that, you can just compute
cache hit ratios to see whether things are improving.

Greetings,

Andres Freund


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Add hint for function named "is"
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Verbosity of genbki.pl