From: Niels Kristian Schjødt <nielskristian@autouncle.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Merlin Moncure <mmoncure@gmail.com>
Cc: pgsql-performance@postgresql.org list <pgsql-performance@postgresql.org>
Subject: Re: Sudden crazy high CPU usage
Date: Mon, 31 Mar 2014 19:21:05 +0200
Message-ID: <794FDEE2-FAC1-4201-AD09-6BCB26234348@autouncle.com> (raw)
In-Reply-To: <CAOR=d=0aZVO=s7i+dFr98JaWHSARb+AkWT4cHhFBom46sz5mGg@mail.gmail.com>
References: <24BBD031-7384-4FFF-848B-90F5664C0063@autouncle.com>
<CAHyXU0y9hviyKWvQZxX5UWfH9M2LYvwvAOPQ_DUPva2b71t12g@mail.gmail.com>
<2ABC90E9-8312-45A4-96E0-CFE202CCD9CE@autouncle.com>
<CAOR=d=0aZVO=s7i+dFr98JaWHSARb+AkWT4cHhFBom46sz5mGg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Thanks, I don’t think overheating is an issue, it’s a large dell server, and I have checked the historic CPU temperature in the servers control panel, and no overheating has shown.
Zone_reclaim_mode is already set to 0
Den 31/03/2014 kl. 16.50 skrev Scott Marlowe <scott.marlowe@gmail.com>:
> 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 experienced anything 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.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: nielskristian@autouncle.com, scott.marlowe@gmail.com, mmoncure@gmail.com
Subject: Re: Sudden crazy high CPU usage
In-Reply-To: <794FDEE2-FAC1-4201-AD09-6BCB26234348@autouncle.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox