From: | Jwiencek3 <jwiencek3(at)comcast(dot)net> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: RHEL-8 Kernel Settings |
Date: | 2021-06-11 09:07:51 |
Message-ID: | B1EFDEC8-07B5-4823-A404-15A7B90EAE30@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Other than HugePages are any other settings determined by the amount of memory on a server?
John
Sent from my iPad
> On Jun 11, 2021, at 1:56 AM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
>
> 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 | Vineet Naik | 2021-06-11 12:16:29 | Autovacuum or manual vacuum to recover from XID wraparound? |
Previous Message | Laurenz Albe | 2021-06-11 07:12:28 | Re: RHEL-8 Kernel Settings |