Re: ??: postgres cpu 100% need help

From: "657985552(at)qq(dot)com" <657985552(at)qq(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Kevin Grittner" <kgrittn(at)gmail(dot)com>, "Merlin Moncure" <mmoncure(at)gmail(dot)com>, "Bill Moran" <wmoran(at)potentialtech(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: ??: postgres cpu 100% need help
Date: 2015-11-25 03:57:49
Message-ID: 2015112511574850020322@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

oh .thanks i understand . but i still have a question .
[root(at)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(at)pg1 pgdata]# cat /etc/redhat-release
CentOS Linux release 7.0.1406 (Core)

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

657985552(at)qq(dot)com

From: Tom Lane
Date: 2015-11-25 10:21
To: 657985552(at)qq(dot)com
CC: Kevin Grittner; Merlin Moncure; Bill Moran; pgsql-general
Subject: Re: [GENERAL] ??: postgres cpu 100% need help
"657985552(at)qq(dot)com" <657985552(at)qq(dot)com> writes:
> thanks for you help . but the following config Indicate my OS THP is Disable
> [root(at)pg1 ~]# grep -i HugePages_Total /proc/meminfo
> HugePages_Total: 0
> [root(at)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benedikt Grundmann 2015-11-25 08:04:49 Re: Problems with pg_upgrade after change of unix user running db.
Previous Message Tom Lane 2015-11-25 02:21:21 Re: ??: postgres cpu 100% need help