Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51409=pgsql-performance-ar@postgresql.org>)
 id 1WUftZ-0003Se-MB
 for pgsql-performance@arkaria.postgresql.org; Mon, 31 Mar 2014 17:21:13 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51409=pgsql-performance-ar@postgresql.org>)
 id 1WUftZ-000204-6g
 for pgsql-performance@arkaria.postgresql.org; Mon, 31 Mar 2014 17:21:13 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <nielskristian@autouncle.com>) id 1WUftY-0001zs-EJ
 for pgsql-performance@postgresql.org; Mon, 31 Mar 2014 17:21:12 +0000
Received: from mail-lb0-f179.google.com ([209.85.217.179])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <nielskristian@autouncle.com>) id 1WUftW-00055R-6j
 for pgsql-performance@postgresql.org; Mon, 31 Mar 2014 17:21:12 +0000
Received: by mail-lb0-f179.google.com with SMTP id p9so6137451lbv.10
 for <pgsql-performance@postgresql.org>; Mon, 31 Mar 2014 10:21:09 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20130820;
 h=x-gm-message-state:content-type:mime-version:subject:from
 :in-reply-to:date:cc:content-transfer-encoding:message-id:references
 :to; bh=xmmdLSGI28IgaczJlVd/fJFD4zJ0MyQVCm7DnHJ8AHs=;
 b=PX1nAznIyhfaTPJGChhsjOpi2lnYTH5Wy3iOgVgc0qP8UISRNDq5nsKH9vCYoOw6wG
 ZXA83P1ztLvvQ/YRLQQf9aX3/HfuwiGKSuk6fxLKOQVN9ywjJASKN176Vi0ORVuigjkt
 Kf4K6Je6RkCeewmMtNGIbjUSbePsxpchZVOtiUBM7zOxz15429TB/QwufYT8fNgJ3sUP
 sJ/9ic3z/I8QmX8CtmZqkZI4T4EfOR1Tx6+q/hdxSVyWnxSbzy/iCrQaB59lYjx3gwwX
 +g0VDqS4eqQTMQ/SDWPJ7/kXIjZpRkZpm6pmC13Ur06Fc6t8a8A84g3LE2U4vTOvVe5L
 7SdQ==
X-Gm-Message-State: 
 ALoCoQk87hyOf5eJDQqj5PbVFqmWK2LUOleXq1SIhzf2mB5cq7kphjW4Cl0qJyGItr+DD3pIUh5D
X-Received: by 10.112.147.136 with SMTP id tk8mr21969lbb.95.1396286469236;
 Mon, 31 Mar 2014 10:21:09 -0700 (PDT)
Received: from [192.168.0.16] (x1-6-84-1b-5e-20-07-92.cpe.webspeed.dk.
 [80.167.117.15])
 by mx.google.com with ESMTPSA id d4sm10303094lbr.27.2014.03.31.10.21.07
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Mon, 31 Mar 2014 10:21:08 -0700 (PDT)
Content-Type: text/plain; charset=windows-1252
Mime-Version: 1.0 (Mac OS X Mail 7.2 \(1874\))
Subject: Re: Sudden crazy high CPU usage
From: =?windows-1252?Q?Niels_Kristian_Schj=F8dt?=
 <nielskristian@autouncle.com>
In-Reply-To: 
 <CAOR=d=0aZVO=s7i+dFr98JaWHSARb+AkWT4cHhFBom46sz5mGg@mail.gmail.com>
Date: Mon, 31 Mar 2014 19:21:05 +0200
Cc: Merlin Moncure <mmoncure@gmail.com>,
 "pgsql-performance@postgresql.org list" <pgsql-performance@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <794FDEE2-FAC1-4201-AD09-6BCB26234348@autouncle.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>
To: Scott Marlowe <scott.marlowe@gmail.com>
X-Mailer: Apple Mail (2.1874)
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Thanks, I don=92t think overheating is an issue, it=92s a large dell server=
, and I have checked the historic CPU temperature in the servers control pa=
nel, and no overheating has shown.

Zone_reclaim_mode is already set to 0=20

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=F8dt
> <nielskristian@autouncle.com> wrote:
>>=20
>> 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.
>=20
> Could it be overheating and therefore throttling the cores?
>=20
> 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.



--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance