Re: Perplexing, regular decline in performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Perplexing, regular decline in performance
Дата
Msg-id 8279.1561576694@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Perplexing, regular decline in performance  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: Perplexing, regular decline in performance
Список pgsql-performance
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> On 2019-Jun-26, Hugh Ranalli wrote:
>> From my research in preparing for the upgrade, I understood transparent
>> huge pages were a good thing, and should be enabled. Is this not correct?

> It is not.

Yeah ... they would be a good thing perhaps if the quality of the kernel
implementation were better.  But there are way too many nasty corner
cases, at least with the kernel versions people around here have
experimented with.  You're best off to disable THP and instead manually
arrange for Postgres' shared memory to use huge pages.  I forget where
to look for docs about doing that, but I think we have some.

            regards, tom lane



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Perplexing, regular decline in performance
Следующее
От: David Rowley
Дата:
Сообщение: Re: scans on table fail to be excluded by partition bounds