public inbox for [email protected]  

help / color / mirror / Atom feed

From: Kanimozhi Manoharan <[email protected]>
To: [email protected]
Subject: Re: Postgres fine tuning
Date: Mon, 3 Jun 2024 10:56:07 +0530
Message-ID: <CAA9MTjQbFq10fhxGesCPB=LgW56d9LiUMAmMWwacMbZYbDZ=fA@mail.gmail.com> (raw)
In-Reply-To: <CAA9MTjSNxx1u8v23u7M-ASKP7winDrOFUvue2UHRLqYexoCK4w@mail.gmail.com>
References: <CAA9MTjSNxx1u8v23u7M-ASKP7winDrOFUvue2UHRLqYexoCK4w@mail.gmail.com>

Team, please share your thoughts.

Regards,
Kanimozhi.

On Fri, May 31, 2024 at 11:12 AM Kanimozhi Manoharan <[email protected]>
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 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.
>

reply

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Postgres fine tuning
  In-Reply-To: <CAA9MTjQbFq10fhxGesCPB=LgW56d9LiUMAmMWwacMbZYbDZ=fA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox