MIME-Version: 1.0
From: Kanimozhi Manoharan <kanithilak@gmail.com>
Date: Fri, 31 May 2024 11:12:19 +0530
Message-ID: 
 <CAA9MTjSNxx1u8v23u7M-ASKP7winDrOFUvue2UHRLqYexoCK4w@mail.gmail.com>
Subject: Postgres fine tuning
To: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001846a90619b97326"
Archived-At: 
 <https://www.postgresql.org/message-id/CAA9MTjSNxx1u8v23u7M-ASKP7winDrOFUvue2UHRLqYexoCK4w%40mail.gmail.com>
Precedence: bulk

--0000000000001846a90619b97326
Content-Type: text/plain; charset="UTF-8"

Hi Team,

Recently we migrated from the OS from Cent 7 to RHEL 8 version. Post
migration we are seeing high memory usage. Upon checking with RHEL team,
they are asking to fine tune the system for postgres and to configure huge
pages to improve the performance.

/etc/sysctl.conf
<snip>
vm.swappiness = 10
vm.dirty_expire_centisecs = 500
vm.dirty_writeback_centisecs = 250
vm.dirty_ratio = 15
vm.dirty_background_ratio = 3

Is this value recommended for all systems running postgres ? Please let me
know if it is fine to update this.

Regards,
Kanimozhi.

--0000000000001846a90619b97326
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Team,<div><br></div><div>Recently we migrated from the =
OS from=C2=A0Cent 7 to RHEL=C2=A08 version. Post migration we are seeing hi=
gh memory usage. Upon checking with RHEL team, they are asking to fine tune=
 the system for postgres and to configure huge pages to improve the perform=
ance.</div><div><br></div><div><pre style=3D"box-sizing:border-box;overflow=
:auto;font-family:Consolas,Monaco,&quot;Andale Mono&quot;,monospace;font-si=
ze:0.8125rem;padding:0.9375rem;margin-top:0px;margin-bottom:0.625rem;line-h=
eight:1.42857;word-break:normal;color:rgb(51,51,51);background-color:rgb(24=
5,245,245);border:0.0625rem solid rgb(237,237,237);border-radius:0px"><code=
 style=3D"box-sizing:border-box;font-family:Consolas,Monaco,&quot;Andale Mo=
no&quot;,monospace;font-size:inherit;padding:0px;color:inherit;background-c=
olor:transparent;white-space:inherit;border-radius:0px">/etc/sysctl.conf
&lt;snip&gt;
vm.swappiness =3D 10
vm.dirty_expire_centisecs =3D 500
vm.dirty_writeback_centisecs =3D 250
vm.dirty_ratio =3D 15
vm.dirty_background_ratio =3D 3</code></pre></div><div>Is this value recomm=
ended for all systems running postgres ? Please let me know if it is fine t=
o update this.</div><div><br></div><div>Regards,</div><div>Kanimozhi.</div>=
</div>

--0000000000001846a90619b97326--