Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TTHAB-0004OM-Ah for pgsql-performance@postgresql.org; Tue, 30 Oct 2012 19:07:47 +0000 Received: from smtp.01.com ([199.36.142.181]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TTHA5-0004Fm-0p for pgsql-performance@postgresql.org; Tue, 30 Oct 2012 19:07:46 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id 34AAC29400A for ; Tue, 30 Oct 2012 14:07:39 -0500 (CDT) X-Virus-Scanned: amavisd-new at smtp-out-1.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-1.01.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id GMjjuQk-bhdw for ; Tue, 30 Oct 2012 14:07:39 -0500 (CDT) Received: from smtp.01.com (localhost.localdomain [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id 037103F6793 for ; Tue, 30 Oct 2012 14:07:38 -0500 (CDT) Received: from Sidney-Stratton.local (70-36-143-92.dsl.dynamic.sonic.net [70.36.143.92]) by smtp-out-1.01.com (Postfix) with ESMTPSA id A8DCE294001 for ; Tue, 30 Oct 2012 14:07:38 -0500 (CDT) Message-ID: <50902579.5090304@agliodbs.com> Date: Tue, 30 Oct 2012 12:07:37 -0700 From: Josh Berkus Organization: PostgreSQL Experts Inc. User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:16.0) Gecko/20121010 Thunderbird/16.0.1 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: High %SYS CPU usage References: In-Reply-To: X-Enigmail-Version: 1.4.5 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201210/387 X-Sequence-Number: 48346 Cesar, > On this server I have only one database with 312GB of data. The database > had run fine during 4 months, but from two months ago, during high work > load periods, the server is collapsed by "%sys" type load. Hmmm. Have you updated Linux any time recently? I'm wondering if this is a PostgreSQL problem at all. It sounds like an OS issue. Can you give us the results of mpstat -P ALL 3 ? The dstat output doesn't tell me much. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com