Re: Server hitting 100% CPU usage, system comes to a crawl. - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Server hitting 100% CPU usage, system comes to a crawl.
Date
Msg-id 201110271523.44328.ahodgson@simkin.ca
Whole thread Raw
In response to Re: Server hitting 100% CPU usage, system comes to a crawl.  (Brian Fehrle <brianf@consistentstate.com>)
List pgsql-general
On October 27, 2011 01:09:51 PM Brian Fehrle wrote:
> We've restarted the postgresql cluster, so the issue is not happening at
> this moment. but running a vmstat 10 had my 'cs' average at 3K and 'in'
> averaging around 9.5K.

Random thought, is there any chance the server is physically overheating? I've
seen CPUs throttle really low when overheating, which can make otherwise
normal activity seem really slow.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Custom data type in C with one fixed and one variable attribute
Next
From: Simon Riggs
Date:
Subject: User feedback requested on temp tables usage for Hot Standby