public inbox for [email protected]  

help / color / mirror / Atom feed

Postgres fine tuning
2+ messages / 1 participants
[nested] [flat]

* Postgres fine tuning
@ 2024-05-31 05:42  Kanimozhi Manoharan <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Kanimozhi Manoharan @ 2024-05-31 05:42 UTC (permalink / raw)
  To: [email protected]

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.


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Postgres fine tuning
@ 2024-06-03 05:26  Kanimozhi Manoharan <[email protected]>
  parent: Kanimozhi Manoharan <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Kanimozhi Manoharan @ 2024-06-03 05:26 UTC (permalink / raw)
  To: [email protected]

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.
>


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2024-06-03 05:26 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-05-31 05:42 Postgres fine tuning Kanimozhi Manoharan <[email protected]>
2024-06-03 05:26 ` Kanimozhi Manoharan <[email protected]>

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