How only 2 parameters of PostgreSQL reduced anomaly of Jira Data Center nodes
Hello community, Gonchik Tsymzhitov is in touch. Today, I would like to share with you a short story about postgresqltuner.pl in usage. So from previous articles I hope you configured the PostgreSQL server and postgresqltuner.pl. After executing command, ./postgresqltuner.pl --ssd for ssd disks server. You can see like this output: postgresqltuner.pl version 1.0.1 [OK] I can invoke executables Connecting to /var/run/postgresql:5432 database template1 as user 'postgres'... [OK] The user account used by me for reporting has superuser rights on this PostgreSQL instance ===== OS information ===== [INFO] OS: linux Version: 5.4.17-2036.102.0.2.el8uek.x86_64 Arch: x86_64-linux-thread-multi [INFO] OS total memory: 41.03 GB [OK] vm.overcommit_memory is adequate: no memory overcommitment [INFO] Running under a vmware hypervisor [INFO] Currently used I/O sc...