Re: Sudden crazy high CPU usage - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Sudden crazy high CPU usage
Date
Msg-id CAOR=d=0aZVO=s7i+dFr98JaWHSARb+AkWT4cHhFBom46sz5mGg@mail.gmail.com
Whole thread Raw
In response to Re: Sudden crazy high CPU usage  (Niels Kristian Schjødt <nielskristian@autouncle.com>)
Responses Re: Sudden crazy high CPU usage
List pgsql-performance
On Mon, Mar 31, 2014 at 8:24 AM, Niels Kristian Schjødt
<nielskristian@autouncle.com> wrote:
>
> Thanks, this seems to persist after a reboot of the server though, and I have never in my server's 3 months life time
experiencedanything like it. 

Could it be overheating and therefore throttling the cores?

Also another thing to look at on large memory machines with > 1 CPU
socket is zone_reclaim_mode being set to 1. Always set it to 0 on a
linux machine running postgres.


pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Sudden crazy high CPU usage
Next
From: Christopher Jackson
Date:
Subject: Re: Slow Count-Distinct Query