MIME-Version: 1.0
References: 
 <CAA9MTjSNxx1u8v23u7M-ASKP7winDrOFUvue2UHRLqYexoCK4w@mail.gmail.com>
In-Reply-To: 
 <CAA9MTjSNxx1u8v23u7M-ASKP7winDrOFUvue2UHRLqYexoCK4w@mail.gmail.com>
From: Kanimozhi Manoharan <kanithilak@gmail.com>
Date: Mon, 3 Jun 2024 10:56:07 +0530
Message-ID: 
 <CAA9MTjQbFq10fhxGesCPB=LgW56d9LiUMAmMWwacMbZYbDZ=fA@mail.gmail.com>
Subject: Re: Postgres fine tuning
To: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000b8340d0619f59207"
Archived-At: 
 <https://www.postgresql.org/message-id/CAA9MTjQbFq10fhxGesCPB%3DLgW56d9LiUMAmMWwacMbZYbDZ%3DfA%40mail.gmail.com>
Precedence: bulk

--000000000000b8340d0619f59207
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Team, please share your thoughts.

Regards,
Kanimozhi.

On Fri, May 31, 2024 at 11:12=E2=80=AFAM Kanimozhi Manoharan <kanithilak@gm=
ail.com>
wrote:

> 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 hug=
e
> pages to improve the performance.
>
> /etc/sysctl.conf
> <snip>
> 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
>
> Is this value recommended for all systems running postgres ? Please let m=
e
> know if it is fine to update this.
>
> Regards,
> Kanimozhi.
>

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

<div dir=3D"ltr">Team, please share your thoughts.<div><br></div><div>Regar=
ds,</div><div>Kanimozhi.</div></div><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">On Fri, May 31, 2024 at 11:12=E2=80=AFAM Kani=
mozhi Manoharan &lt;<a href=3D"mailto:kanithilak@gmail.com">kanithilak@gmai=
l.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"ma=
rgin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:=
1ex"><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 seei=
ng 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 pe=
rformance.</div><div><br></div><div><pre style=3D"box-sizing:border-box;ove=
rflow:auto;font-family:Consolas,Monaco,&quot;Andale Mono&quot;,monospace;fo=
nt-size:0.8125rem;padding:0.9375rem;margin-top:0px;margin-bottom:0.625rem;l=
ine-height:1.42857;word-break:normal;color:rgb(51,51,51);background-color:r=
gb(245,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;Anda=
le Mono&quot;,monospace;font-size:inherit;padding:0px;color:inherit;backgro=
und-color:transparent;white-space:inherit;border-radius:0px">/etc/sysctl.co=
nf
&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>
</blockquote></div>

--000000000000b8340d0619f59207--