| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Yi Sun <yinan81(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: overcommit_ratio setting |
| Date: | 2021-06-15 07:07:00 |
| Message-ID: | ed9bdd0e15309e01c690319bb567558f2a912390.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yi Sun | 2021-06-15 07:45:59 | Re: overcommit_ratio setting |
| Previous Message | Haseeb Khan | 2021-06-15 06:17:05 | Re: Master - Slave Replication Window Server |