PostgreSQL 12 High Availability Cookbook - Third Edition

Getting ready

While the following settings are based on Linux servers, some of the concepts are universal. We'll try to provide enough information to illustrate this. However, keep that in mind for this recipe.

Otherwise, look for a directory named /etc/sysctl.d. Any system with this directory can be easily configured by adding a file that contains extra settings here. Otherwise, we need to find a file named /etc/sysctl.conf, which serves a similar purpose but requires direct modification.

The settings we are going to change include the following:

kernel.sched_migration_cost_ns = 5000000 
kernel.sched_autogroup_enabled = 0 
vm.dirty_background_bytes = 67108864 
vm.dirty_bytes = 1073741824 
vm.zone_reclaim_mode = 0 
vm.swappiness = 1