Re: Server hitting 100% CPU usage, system comes to a crawl.

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Server hitting 100% CPU usage, system comes to a crawl.
Date: 2011-10-27 22:23:44
Message-ID: 201110271523.44328.ahodgson@simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2011-10-27 23:13:30 User feedback requested on temp tables usage for Hot Standby
Previous Message Tom Lane 2011-10-27 22:23:21 Re: Custom data type in C with one fixed and one variable attribute