Postgres fine tuning - Mailing list pgsql-sql

From Kanimozhi Manoharan
Subject Postgres fine tuning
Date
Msg-id CAA9MTjSNxx1u8v23u7M-ASKP7winDrOFUvue2UHRLqYexoCK4w@mail.gmail.com
Whole thread Raw
Responses Re: Postgres fine tuning
List pgsql-sql
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.

pgsql-sql by date:

Previous
From: Amitabh Kant
Date:
Subject: Re: Pgadmin 4 cannot add or modify line in a view
Next
From: Muhammad Ikram
Date:
Subject: Re: Pgadmin 4 cannot add or modify line in a view