Re: overcommit_ratio setting - Mailing list pgsql-performance

From Julien Rouhaud
Subject Re: overcommit_ratio setting
Date
Msg-id 20210614141423.xw4y3vfq6eunuphe@nol
Whole thread Raw
In response to overcommit_ratio setting  (Yi Sun <yinan81@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dumpall --exclude-database case folding, was Re: AWS forcing PG upgrade from v9.6 a disaster
Next
From: Laurenz Albe
Date:
Subject: Re: overcommit_ratio setting