Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42021=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Vtl7K-0001Dq-Ir
 for pgsql-admin@arkaria.postgresql.org; Thu, 19 Dec 2013 21:26:50 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42021=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Vtl7J-0004t9-5y
 for pgsql-admin@arkaria.postgresql.org; Thu, 19 Dec 2013 21:26:49 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <vozerov@2reallife.com>) id 1Vtl77-0004bP-89
 for pgsql-admin@postgresql.org; Thu, 19 Dec 2013 21:26:37 +0000
Received: from mail-la0-f48.google.com ([209.85.215.48])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <vozerov@2reallife.com>) id 1Vtl74-0000xg-6U
 for pgsql-admin@postgresql.org; Thu, 19 Dec 2013 21:26:36 +0000
Received: by mail-la0-f48.google.com with SMTP id n7so718088lam.21
 for <pgsql-admin@postgresql.org>; Thu, 19 Dec 2013 13:26:33 -0800 (PST)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20130820;
 h=x-gm-message-state:date:from:to:cc:message-id:in-reply-to
 :references:subject:mime-version:content-type;
 bh=lp9jf70athinBdpRcKM4iU0I0wcH+GSjQbYCGElGHec=;
 b=g7HCbCbaJvVR1I+Xe2nrclOf22pW8JRQRQODpm6hR5FR1pcEqIXbu1pt3U1pfs5Ty0
 prKMkGMWFedw7joitrjTluQAmmf9woLRCxA6laMpSgJUkFIbFLYppBizQaAiSr1iffHt
 8CcapJKekgm9HJokmxx5Z7/+wGjcjrodEdW/VcGyk6f8Jo+EtcI0g1WMPVySzi6dVzMS
 58dLpiUy5mDnNPtYV/jMVe9iDBgOemww6GnFRUwWhKijlnsomxuz6rgobxzoGkWkRuv1
 n0/+yoY2Mq5rXMewoMeSOWu87REeJO0iGe9Yg4HjQ1J7SqRNYzNV/MZVvRdF5GAs+qpg
 xXEg==
X-Gm-Message-State: 
 ALoCoQlCy5FixHV3uvqMpbeytNO6y8Jb436Do7w5kZUW4E2+E+1MuaoNk7O0BTbhCA0M+bQKj+M4
X-Received: by 10.152.115.130 with SMTP id jo2mr1988898lab.2.1387488393067;
 Thu, 19 Dec 2013 13:26:33 -0800 (PST)
Received: from [192.168.1.5] (host-87-255-14-144.bigtelecom.ru.
 [87.255.14.144])
 by mx.google.com with ESMTPSA id ox6sm3227272lbb.6.2013.12.19.13.26.30
 for <multiple recipients>
 (version=TLSv1 cipher=RC4-SHA bits=128/128);
 Thu, 19 Dec 2013 13:26:31 -0800 (PST)
Date: Fri, 20 Dec 2013 01:26:29 +0400
From: Vasiliy I Ozerov <vozerov@2reallife.com>
To: "=?utf-8?Q?ktm=40rice.edu?=" <ktm@rice.edu>
Cc: pgsql-admin@postgresql.org
Message-ID: <FCA738F5138442858AD0C454BA91685B@2reallife.com>
In-Reply-To: <20131219212007.GU19242@aart.rice.edu>
References: <0ECD0DAFC1A24867A84CBF6C25C372F9@2reallife.com>
 <20131219212007.GU19242@aart.rice.edu>
Subject: Re: Postgres 9.2 CPU Usage
X-Mailer: sparrow 1.6.4 (build 1176)
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="52b36485_520eedd1_95f0"
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

--52b36485_520eedd1_95f0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hmm.. Thank you=21 I will try it=21 =20

-- =20
Vasiliy I Ozerov


=D0=BF=D1=8F=D1=82=D0=BD=D0=B8=D1=86=D0=B0, 20 =D0=B4=D0=B5=D0=BA=D0=B0=D0=
=B1=D1=80=D1=8F 2013 =D0=B3. =D0=B2 1:20, ktm=40rice.edu =D0=BD=D0=B0=D0=BF=
=D0=B8=D1=81=D0=B0=D0=BB:

> On =46ri, Dec 20, 2013 at 12:56:47AM +0400, Vasiliy I Ozerov wrote:
> > Good day=21
> > =20
> > Sometimes ago we order new Dell (Dell PowerEdge T720 DX290) server, w=
ith this configuration:
> > =20
> > 1. 128 Gb DDR3 ECC RAM
> > 2. Dual Intel Xeon E5-2620 Hexa Core incl. Hyper-Thrreading Tecknolog=
y
> > 3. 2x 600Gb SSD With PERC H710 mini RAID 1
> > =20
> > ...
> > =20
> > 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 postgres=
ql doesn=E2=80=99t accept connections from users, only from pgbouncer. An=
d the number of active requests per second is about 5:
> > =20
> > ...
> > =20
> > I think it is some misconfiguration issue, so can you help me with so=
me config/sysctl options for such server=3F
> > =20
> > Thank you=21
> =20
> Hi Vasiliy,
> =20
> I think this may not be a PostgreSQL related problem, but a BIOS config=
uration
> problem. Dell used to ship servers with the BIOS set for performance mo=
de, 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 rebooti=
ng, the
> phantom load vanished.
> =20
> Regards,
> Ken
> =20
> =20



--52b36485_520eedd1_95f0
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline


                <div>
                    Hmm.. Thank you=21 I will try it=21
                </div>
                <div><div><br></div><div>--&nbsp;</div><div>Vasiliy I Oze=
rov</div><div><br></div></div>
                =20
                <p style=3D=22color: =23A0A0A8;=22>=D0=BF=D1=8F=D1=82=D0=BD=
=D0=B8=D1=86=D0=B0, 20 =D0=B4=D0=B5=D0=BA=D0=B0=D0=B1=D1=80=D1=8F 2013 =D0=
=B3. =D0=B2 1:20, ktm=40rice.edu =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0=BB=
:</p>
                <blockquote type=3D=22cite=22 style=3D=22border-left-styl=
e:solid;border-width:1px;margin-left:0px;padding-left:10px;=22>
                    <span><div><div><div>On =46ri, Dec 20, 2013 at 12:56:=
47AM +0400, Vasiliy I Ozerov wrote:</div><blockquote type=3D=22cite=22><d=
iv><div>Good day=21</div><div><br></div><div>Sometimes ago we order new D=
ell (Dell PowerEdge T720 DX290) server, with this configuration:</div><di=
v><br></div><div>1. 128 Gb DDR3 ECC RAM</div><div>2. Dual Intel Xeon E5-2=
620 Hexa Core incl. Hyper-Thrreading Tecknology</div><div>3. 2x 600Gb SSD=
 With PERC H710 mini RAID 1</div><div><br></div><div>...</div><div><br></=
div><div>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 pos=
tgresql doesn=E2=80=99t accept connections from users, only from pgbounce=
r. And the number of active requests per second is about 5:</div><div><br=
></div><div>...</div><div><br></div><div>I think it is some misconfigurat=
ion issue, so can you help me with some config/sysctl options for such se=
rver=3F</div><div><br></div><div>Thank you=21</div></div></blockquote><di=
v><br></div><div>Hi Vasiliy,</div><div><br></div><div>I think this may no=
t be a PostgreSQL related problem, but a BIOS configuration</div><div>pro=
blem. Dell used to ship servers with the BIOS set for performance mode, i=
.e.</div><div>100% at all times, now they ship with more energy thrifty d=
efaults. We had a</div><div>similar problem and by setting the BIOS to pe=
rformance mode and rebooting, the</div><div>phantom load vanished.</div><=
div><br></div><div>Regards,</div><div>Ken</div></div></div></span>
                =20
                =20
                =20
                =20
                </blockquote>
                =20
                <div>
                    <br>
                </div>
            
--52b36485_520eedd1_95f0--