1.大页测试
vi pg_hpg_count.sh
#!/bin/bash
PGDATA='/postgresql/data'
pid=`head -1 $PGDATA/postmaster.pid`
echo "Pid: $pid"
peak=`grep ^VmPeak /proc/$pid/status | awk '{ print $2 }'`
echo "VmPeak: $peak kB"
hps=`grep ^Hugepagesize /proc/meminfo | awk '{ print $2 }'`
echo "Hugepagesize: $hps kB"
hpg=$((peak/hps))
[pgsql@oracle1:/home/pgsql]$ sh pg_hpg_count.sh
Pid: 58166
VmPeak: 1356028 kB
Hugepagesize: 2048 kB
662
sysctl -w vm.nr_hugepages=662
echo "vm.nr_hugepages=662" >> /etc/sysctl.conf
sysctl -p
2.修改PG的配置文件。
vi /postgresql/data/postgresql.conf
#取消注释:
huge_pages = try
3.检查大页配置
[root@oracle1 ~]# cat /proc/meminfo |grep HugePages_
HugePages_Total: 662
HugePages_Free: 662
HugePages_Rsvd: 0
HugePages_Surp: 0
4.总结
内存较大时,建议使用大页。如内存16G以上就可以使用