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
> >
> > 1. Our env RAM are 4GB, 8 GB, 16 GB... as below url suggesti
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
>
> 1. Our env RAM are 4GB, 8 GB, 16 GB... as below url suggestion, could we
> configure swap as below?
> https://o
> 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
> > some articles mentioned that 80 o
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
> some articles mentioned that 80 or 90 conf
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/Documen
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
