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://opensource.com/article/18/9/swap-space-linux-systems
>
> RAM swap
>
> 2GB – 8GB = RAM
> >8GB 8GB
I wouldn't change the swap space to fit overcommit_ratio, but
the other way around.
With a properly configured PostgreSQL, you won't need a lot of swap space.
> 2. If the RAM is 4GB and 8GB, the formula (RAM - swap) / RAM * 100 result will become to 0,
> how could we configure overcommit_ratio please?
You have to use floating point arithmetic.
The result will only be 0 if RAM = swap.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
