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以上就可以使用