Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vtl0w-0000vN-Nd for pgsql-admin@arkaria.postgresql.org; Thu, 19 Dec 2013 21:20:14 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vtl0w-00062c-6s for pgsql-admin@arkaria.postgresql.org; Thu, 19 Dec 2013 21:20:14 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vtl0u-0005zp-Nh for pgsql-admin@postgresql.org; Thu, 19 Dec 2013 21:20:12 +0000 Received: from proofpoint2.mail.rice.edu ([128.42.201.101] helo=pp2.rice.edu) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vtl0r-0004EU-L5 for pgsql-admin@postgresql.org; Thu, 19 Dec 2013 21:20:11 +0000 Received: from pps.filterd (pp2.rice.edu [127.0.0.1]) by pp2.rice.edu (8.14.5/8.14.5) with SMTP id rBJLHekW017295; Thu, 19 Dec 2013 15:20:08 -0600 Received: from mh2.mail.rice.edu (mh2.mail.rice.edu [128.42.201.21]) by pp2.rice.edu with ESMTP id 1gv37r08wu-1; Thu, 19 Dec 2013 15:20:07 -0600 X-Virus-Scanned: by amavis-2.7.0 at mh2.mail.rice.edu, auth channel X-SMTP-Auth: no X-SMTP-Auth: no Received: from aart.rice.edu (aart.rice.edu [168.7.56.48]) by mh2.mail.rice.edu (Postfix) with ESMTP id 9A1E350012A; Thu, 19 Dec 2013 15:20:07 -0600 (CST) Received: by aart.rice.edu (Postfix, from userid 18612) id 9088B100339; Thu, 19 Dec 2013 15:20:07 -0600 (CST) Date: Thu, 19 Dec 2013 15:20:07 -0600 From: "ktm@rice.edu" To: Vasiliy I Ozerov Cc: pgsql-admin@postgresql.org Subject: Re: Postgres 9.2 CPU Usage Message-ID: <20131219212007.GU19242@aart.rice.edu> References: <0ECD0DAFC1A24867A84CBF6C25C372F9@2reallife.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <0ECD0DAFC1A24867A84CBF6C25C372F9@2reallife.com> User-Agent: Mutt/1.5.20 (2009-12-10) X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 kscore.is_bulkscore=0 kscore.compositescore=0 circleOfTrustscore=0 compositescore=0.995703810101747 urlsuspect_oldscore=0.995703810101747 suspectscore=0 recipient_domain_to_sender_totalscore=0 phishscore=0 bulkscore=0 kscore.is_spamscore=0 recipient_to_sender_totalscore=0 recipient_domain_to_sender_domain_totalscore=0 rbsscore=0.995703810101747 spamscore=0 recipient_to_sender_domain_totalscore=0 urlsuspectscore=0.9 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=7.0.1-1305240000 definitions=main-1312190150 X-Pg-Spam-Score: -0.5 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Fri, Dec 20, 2013 at 12:56:47AM +0400, Vasiliy I Ozerov wrote: > Good day! > > Sometimes ago we order new Dell (Dell PowerEdge T720 DX290) server, with this configuration: > > 1. 128 Gb DDR3 ECC RAM > 2. Dual Intel Xeon E5-2620 Hexa Core incl. Hyper-Thrreading Tecknology > 3. 2x 600Gb SSD With PERC H710 mini RAID 1 > > ... > > But we have a strange cpu usage by postgresql (LA about 4). But there is no a lot of requests or heavy requests. We use pgbouncer, so postgresql doesn’t accept connections from users, only from pgbouncer. And the number of active requests per second is about 5: > > ... > > I think it is some misconfiguration issue, so can you help me with some config/sysctl options for such server? > > Thank you! > Hi Vasiliy, I think this may not be a PostgreSQL related problem, but a BIOS configuration problem. Dell used to ship servers with the BIOS set for performance mode, i.e. 100% at all times, now they ship with more energy thrifty defaults. We had a similar problem and by setting the BIOS to performance mode and rebooting, the phantom load vanished. Regards, Ken -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin