Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: Jwiencek3 <jwiencek3@comcast.net>
Mime-Version: 1.0 (1.0)
Subject: Re: RHEL-8 Kernel Settings
Date: Fri, 11 Jun 2021 04:07:51 -0500
Message-Id: <B1EFDEC8-07B5-4823-A404-15A7B90EAE30@comcast.net>
References: <a21a096321d234c1fd1a3cb9842df8b8002aae34.camel@cybertec.at>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
In-Reply-To: <a21a096321d234c1fd1a3cb9842df8b8002aae34.camel@cybertec.at>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Archived-At: 
 <https://www.postgresql.org/message-id/B1EFDEC8-07B5-4823-A404-15A7B90EAE30%40comcast.net>
Precedence: bulk

Other than HugePages are any other settings determined by the amount of memo=
ry on a server?

John=20

Sent from my iPad

> On Jun 11, 2021, at 1:56 AM, Laurenz Albe <laurenz.albe@cybertec.at> wrote=
:
>=20
> =EF=BB=BFOn Thu, 2021-06-10 at 13:06 -0500, John Wiencek wrote:
>> I=E2=80=99m looking for assistance in determining kernel setting for a VM=
 RHEL-8 linux server running postgresql-13.
>>=20
>> I have 3 server groupings
>>=20
>> 1)   2 vcpu=E2=80=99s  8gb memory
>> 2)   4 cpu=E2=80=99s 16gb memory
>> 3)   8 cpu=E2=80=99s 32gb memory
>>=20
>> I=E2=80=99ve read various articles and the PostgreSQL documentation .   D=
oes anyone have practical experiences doing this kind of set up
>>=20
>> Do kernel setting requirements change based on the number of cpu=E2=80=99=
s and amount of memory?    I=E2=80=99ve not read any mention of this.
>=20
> I recommend setting
>=20
>  vm.overcommit_memory =3D 2
>  vm.overcommit_ratio (the correct value depends on your swap)
>  vm.swappiness =3D 0
>=20
> Also, disable Transparent Hugepages.
>=20
> Yours,
> Laurenz Albe
> --=20
> Cybertec | https://www.cybertec-postgresql.com
>=20