Re: ??: postgres cpu 100% need help - Mailing list pgsql-general

From 657985552@qq.com
Subject Re: ??: postgres cpu 100% need help
Date
Msg-id 2015112511574850020322@qq.com
Whole thread Raw
In response to 回复: postgres cpu 100% need help  ("657985552@qq.com" <657985552@qq.com>)
Responses Re: ??: postgres cpu 100% need help
List pgsql-general
oh .thanks i understand . but i still have a question .
[root@pg1 pgdata]# uname -a
Linux pg1 3.10.0-123.9.3.el7.x86_64 #1 SMP Thu Nov 6 15:06:03 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux   
[root@pg1 pgdata]# cat /etc/redhat-release 
CentOS Linux release 7.0.1406 (Core) 

my os is centos7 .  is there  THP problem in it ?


657985552@qq.com
 
From: Tom Lane
Date: 2015-11-25 10:21
Subject: Re: [GENERAL] ??: postgres cpu 100% need help
"657985552@qq.com" <657985552@qq.com> writes:
> 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
 
Those values reflect whether *explicit* huge pages are enabled.  They do
not control *transparent* huge pages.
 
Red Hat's version of all this is documented here:
https://access.redhat.com/solutions/46111
 
regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ??: postgres cpu 100% need help
Next
From: Benedikt Grundmann
Date:
Subject: Re: Problems with pg_upgrade after change of unix user running db.