Re: overcommit_ratio setting

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Yi Sun <yinan81(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: overcommit_ratio setting
Date: 2021-06-14 14:14:23
Message-ID: 20210614141423.xw4y3vfq6eunuphe@nol
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Laurenz Albe 2021-06-14 16:18:23 Re: overcommit_ratio setting
Previous Message Andrew Dunstan 2021-06-14 13:46:06 pg_dumpall --exclude-database case folding