tuning

[edozvola] / db.txt

diff --git a/db.txt b/db.txt
index 9e30e12..2f65fd6 100644 (file)
--- 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
+