Postgres Pro
Downloads
Home   >   mailing lists

overcommit_ratio setting - Mailing list pgsql-performance

From Yi Sun
Subject overcommit_ratio setting
Date
Msg-id CABWY_HCTBwZY-dQNX-XweBz3XYfuCwXcyggo8H3YbW4EUQKOdQ@mail.gmail.com
Whole thread Raw
Responses Re: overcommit_ratio setting  (Julien Rouhaud <rjuju123@gmail.com>)
Re: overcommit_ratio setting  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-performance
Tree view
Hello,

After checking doc, only mentioned vm.overcommit_memory=2, but didn't mentioned vm.overcommit_ratio recommended value

https://www.postgresql.org/docs/11/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT

some articles mentioned that 80 or 90 configuration in their env

So is it OK just to configure  vm.overcommit_ratio to 90 please?

Thank you

pgsql-performance by date:

Previous
From: Ayub Khan
Date:
Subject: Re: waiting for client write
Next
From: Andrew Dunstan
Date:
Subject: pg_dumpall --exclude-database case folding, was Re: AWS forcing PG upgrade from v9.6 a disaster