Home > mailing lists

overcommit_ratio setting - Mailing list pgsql-performance

From	Yi Sun
Subject	overcommit_ratio setting
Date	June 14, 2021 13:16:35
Msg-id	CABWY_HCTBwZY-dQNX-XweBz3XYfuCwXcyggo8H3YbW4EUQKOdQ@mail.gmail.com Whole thread Raw
Responses	Re: overcommit_ratio setting Re: overcommit_ratio setting
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:

From: Ayub Khan
Date: 14 June 2021, 08:02:17
Subject: Re: waiting for client write

From: Andrew Dunstan
Date: 14 June 2021, 16:21:30
Subject: pg_dumpall --exclude-database case folding, was Re: AWS forcing PG upgrade from v9.6 a disaster

overcommit_ratio setting - Mailing list pgsql-performance

Previous

Next