From: Laurenz Albe <laurenz.albe@cybertec.at>
To: John Wiencek <jwiencek3@comcast.net>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: RHEL-8 Kernel Settings
Date: Fri, 11 Jun 2021 08:56:13 +0200
Message-ID: <a21a096321d234c1fd1a3cb9842df8b8002aae34.camel@cybertec.at> (raw)
In-Reply-To: <B564BAE8-FC9F-4925-9D05-55F1F8181EAF@comcast.net>
References: <B564BAE8-FC9F-4925-9D05-55F1F8181EAF@comcast.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, jwiencek3@comcast.net, pgsql-admin@lists.postgresql.org
Subject: Re: RHEL-8 Kernel Settings
In-Reply-To: <a21a096321d234c1fd1a3cb9842df8b8002aae34.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox