Re: [GENERAL] Huge Pages - setting the right value

Поиск
Список
Период
Сортировка
От Andrew Kerber
Тема Re: [GENERAL] Huge Pages - setting the right value
Дата
Msg-id 1D35C710-E82C-40DB-B2A8-491CE69065FA@gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Huge Pages - setting the right value  (pinker <pinker@onet.eu>)
Ответы Re: [GENERAL] Huge Pages - setting the right value
Список pgsql-general
I can't give you an absolutely authoritative answer, but because of the way hugepages are implemented and allocated, I
can'tthink how they could be used for other processes.  Linux hugepages are either 2m or 1g, far too large for any
likelyprocesses to require. They cannot be allocated in partial pages. 

Sent from my iPad

> On Jun 11, 2017, at 10:02 AM, pinker <pinker@onet.eu> wrote:
>
> We are experiencing some performance issues because of high CPU load. So I
> would like to ask one more time. The exact question is:
> Does PostgreSQL can use huge pages for processes or only for shared buffers?
> (Does it make any sense to set the number of huge pages above the
> shared_buffers?)
> Any help or suggestions would be much appreciated!
>
>
>
> --
> View this message in context:
http://www.postgresql-archive.org/Huge-Pages-setting-the-right-value-tp5952972p5965956.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Inconsistent performance with LIKE and bind variable on long-lived connection
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100