hi kevin: thanks for you help . but the following config Indicate my OS THP is Disable [root@pg1 ~]# grep -i HugePages_Total /proc/meminfo HugePages_Total: 0 [root@pg1 ~]# cat /proc/sys/vm/nr_hugepages 0
657985...@qq.com From: Kevin Grittner Date: 2015-11-23 23:30 To: 657985...@qq.com CC: Merlin Moncure; Bill Moran; pgsql-general Subject: Re: [GENERAL] ??: postgres cpu 100% need help On Mon, Nov 23, 2015 at 12:20 AM, 657985...@qq.com <657985...@qq.com> wrote: > [root@pg1 ~]# cat /sys/kernel/mm/transparent_hugepage/enabled > [always] madvise never > [root@pg1 ~]# cat /sys/kernel/mm/transparent_hugepage/defrag > [always] madvise never There's your problem. You need to set those to "never". You can get immediate relief by echoing 'never' to those pseudo-files, but you need to configure your system to set them at OS boot time, too. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company