Re: overcommit_ratio setting

2021-06-15 Thread Yi Sun
Laurenz Albe 于2021年6月15日周二 下午3:07写道: > On Tue, 2021-06-15 at 08:34 +0800, Yi Sun wrote: > > > overcommit_ratio < (RAM - swap) / RAM * 100 > > > > > > Here, RAM is the RAM available to PostgreSQL. > > > > Thank you for your reply > > >

Re: overcommit_ratio setting

2021-06-14 Thread Yi Sun
> On Mon, 2021-06-14 at 18:16 +0800, Yi Sun wrote: > > 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 > >

overcommit_ratio setting

2021-06-14 Thread Yi Sun
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 conf