Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51767=pgsql-performance-ar@postgresql.org>)
 id 1WsY1A-0007IJ-1s
 for pgsql-performance@arkaria.postgresql.org; Thu, 05 Jun 2014 13:47:44 +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+M51767=pgsql-performance-ar@postgresql.org>)
 id 1WsY19-0004eL-HU
 for pgsql-performance@arkaria.postgresql.org; Thu, 05 Jun 2014 13:47:43 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <tgl@sss.pgh.pa.us>) id 1WsY18-0004eE-1l
 for pgsql-performance@postgresql.org; Thu, 05 Jun 2014 13:47:42 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
 by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <tgl@sss.pgh.pa.us>) id 1WsY15-0004xc-3J
 for pgsql-performance@postgresql.org; Thu, 05 Jun 2014 13:47:40 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
 by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id s55DlbNc006016;
 Thu, 5 Jun 2014 09:47:37 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Vince Lasmarias <vincent.lasmarias@gmail.com>
cc: pgsql-performance@postgresql.org
Subject: Re: High CPU load when 'free -m' shows low 'free' memory even though
 large 'cached' memory still available
In-reply-to: 
 <CABnAvF3ii0gGds19W4LKK4US+gmshYzv-jhH6XYds12F9172-Q@mail.gmail.com>
References: 
 <CABnAvF3ii0gGds19W4LKK4US+gmshYzv-jhH6XYds12F9172-Q@mail.gmail.com>
Comments: In-reply-to Vince Lasmarias <vincent.lasmarias@gmail.com>
 message dated "Mon, 02 Jun 2014 16:43:30 -0700"
Date: Thu, 05 Jun 2014 09:47:37 -0400
Message-ID: <6015.1401976057@sss.pgh.pa.us>
X-Pg-Spam-Score: -1.2 (-)
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

Vince Lasmarias <vincent.lasmarias@gmail.com> writes:
> For the past few days, we've been seeing unexpected high CPU spikes in our
> system.

Recent reports have suggested that disabling transparent huge page
management in your kernel can help with this.  If the excess CPU
load is mostly "system" time not "user" time then this is probably
the culprit.

			regards, tom lane


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