Re: ??: postgres cpu 100% need help

["657985552@xxxxxx" <657985552@xxxxxx>]

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

---

657985552@xxxxxx

 

From: Kevin Grittner

Date: 2015-11-23 23:30

To: 657985552@xxxxxx

CC: Merlin Moncure; Bill Moran; pgsql-general

Subject: Re: [GENERAL] ??: postgres cpu 100% need help

On Mon, Nov 23, 2015 at 12:20 AM, 657985552@xxxxxx <657985552@xxxxxx> 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