tuning

[edozvola] / db.txt

diff --git a/db.txt b/db.txt
index bcf6395..2f65fd6 100644 (file)
--- a/db.txt
+++ b/db.txt
@@ -105,10 +105,14 @@ archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/arch
 
 
 [root@slave 10]# mkdir -p /var/lib/pgsql/10/archive/
+chown postgres:postgres /var/lib/pgsql/10/archive/
 
 vi /var/lib/pgsql/10/data/postgresql.conf
 i
-archive_mode = on               # enables archiving; off, on, or always
+
+# https://www.postgresql.org/docs/10/warm-standby.html#CONTINUOUS-ARCHIVING-IN-STANDBY
+
+archive_mode = always               # enables archiving; off, on, or always
 archive_command = 'test ! -f /var/lib/pgsql/10/archive/%f && cp %p /var/lib/pgsql/10/archive/%f'
 
 
@@ -118,6 +122,32 @@ dpavlin=# insert into test(t) select i from generate_series(100, 150) as i ;
 
 
 
+dpavlin=# SELECT pg_start_backup('label', false, false);
+
+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
+