From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Thu, 9 Sep 2021 19:07:35 +0000 (+0200)
Subject: tuning
X-Git-Url: http://git.rot13.org/?p=edozvola;a=commitdiff_plain;h=bae49ded26ab1066b07300fe73a3a39652ffd88f

tuning
---

diff --git a/db.txt b/db.txt
index 9e30e12..2f65fd6 100644
--- a/db.txt
+++ b/db.txt
@@ -131,3 +131,23 @@ SELECT * FROM pg_stop_backup(false, true);
 
 [root@slave 10]# mkdir /var/lib/pgsql/10/archive.base/
 
+# tuning
+
+https://www.enterprisedb.com/blog/tuning-debian-ubuntu-postgresql
+
+## /etc/sysctl.conf
+
+vm.swappiness = 10
+vm.dirty_expire_centisecs = 500
+vm.dirty_writeback_centisecs = 250
+vm.dirty_ratio = 10
+vm.dirty_background_ratio = 3
+vm.overcommit_memory=2
+net.ipv4.tcp_timestamps=0
+
+/dev/mapper/pgdata-01-data /pgdata xfs 	defaults,noatime,nodiratime 1 1
+
+To activate it immediately, run:
+
+mount -o remount,noatime,nodiratime /pgdata
+