Posts Tagged kernel

PostgreSQL tuning (Linux kernel parameters)

Edit file /etc/sysctl.conf

Add the following lines

kernel.shmmax=2147483648
vm.overcommit_memory=2

kernel.shmmax
1. Around 1/2 of the total system memory
e.g. 4GB system memory, kernel.shmmax =  2 x 1024 x 1024 x 1024

Modify postgresql server effective cache settings
edit /var/lib/pgsql/data/postgresql.conf

effective_cache_size = 1800MB

VN:F [1.9.18_1163]
Rating: 5.0/5 (1 vote cast)
VN:F [1.9.18_1163]
Rating: 0 (from 0 votes)
Total views: 21,246 views

, ,

No Comments