Re: overcommit_ratio setting

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: overcommit_ratio setting
Дата
Msg-id 20210614141423.xw4y3vfq6eunuphe@nol
обсуждение исходный текст
Ответ на overcommit_ratio setting  (Yi Sun <yinan81@gmail.com>)
Список pgsql-performance
On Mon, Jun 14, 2021 at 06:16:35PM +0800, Yi Sun wrote:
> 
> So is it OK just to configure  vm.overcommit_ratio to 90 please?

This parameter entirely depends on the amount of RAM and swap you have on your
server, and how much memory you want to be allocable.

See https://www.kernel.org/doc/Documentation/vm/overcommit-accounting.

It's usually a good practice to not allow more than your RAM to be alloced, and
let a at least a bit of memory non allocable to make sure that you keep at
least some OS cache, but that's up to you.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dumpall --exclude-database case folding, was Re: AWS forcing PG upgrade from v9.6 a disaster
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: overcommit_ratio setting