| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | John Wiencek <jwiencek3(at)comcast(dot)net>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: RHEL-8 Kernel Settings |
| Date: | 2021-06-11 06:56:13 |
| Message-ID: | a21a096321d234c1fd1a3cb9842df8b8002aae34.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, 2021-06-10 at 13:06 -0500, John Wiencek wrote:
> I’m looking for assistance in determining kernel setting for a VM RHEL-8 linux server running postgresql-13.
>
> I have 3 server groupings
>
> 1) 2 vcpu’s 8gb memory
> 2) 4 cpu’s 16gb memory
> 3) 8 cpu’s 32gb memory
>
> I’ve read various articles and the PostgreSQL documentation . Does anyone have practical experiences doing this kind of set up
>
> Do kernel setting requirements change based on the number of cpu’s and amount of memory? I’ve not read any mention of this.
I recommend setting
vm.overcommit_memory = 2
vm.overcommit_ratio (the correct value depends on your swap)
vm.swappiness = 0
Also, disable Transparent Hugepages.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johannes Truschnigg | 2021-06-11 07:06:17 | Re: RHEL-8 Kernel Settings |
| Previous Message | Tom Lane | 2021-06-11 03:54:41 | Re: pg_dump directory format and proper ordering |