[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] Postgres 9.2 CPU Usage
From:       Vasiliy I Ozerov <vozerov () 2reallife ! com>
Date:       2013-12-19 21:26:29
Message-ID: FCA738F5138442858AD0C454BA91685B () 2reallife ! com
[Download RAW message or body]

Hmm.. Thank you! I will try it!  

--  
Vasiliy I Ozerov


пятница, 20 декабря 2013 г. в 1:20, ktm@rice.edu написал:

> 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
> 
> 


[Attachment #3 (text/html)]

                <div>
                    Hmm.. Thank you! I will try it!
                </div>
                <div><div><br></div><div>--&nbsp;</div><div>Vasiliy I \
Ozerov</div><div><br></div></div>  
                <p style="color: #A0A0A8;">пятница, 20 декабря 2013 г. \
                в 1:20, ktm@rice.edu написал:</p>
                <blockquote type="cite" \
style="border-left-style:solid;border-width:1px;margin-left:0px;padding-left:10px;">  \
<span><div><div><div>On Fri, Dec 20, 2013 at 12:56:47AM +0400, Vasiliy I Ozerov \
wrote:</div><blockquote type="cite"><div><div>Good \
day!</div><div><br></div><div>Sometimes ago we order new Dell (Dell PowerEdge T720 \
DX290) server, with this configuration:</div><div><br></div><div>1. 128 Gb DDR3 ECC \
RAM</div><div>2. Dual Intel Xeon E5-2620 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 postgresql doesn't accept connections from users, only \
from pgbouncer. 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 \
misconfiguration issue, so can you help me with some config/sysctl options for such \
server?</div><div><br></div><div>Thank \
you!</div></div></blockquote><div><br></div><div>Hi \
Vasiliy,</div><div><br></div><div>I think this may not be a PostgreSQL related \
problem, but a BIOS configuration</div><div>problem. 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 defaults. We had a</div><div>similar problem and by setting \
the BIOS to performance mode and rebooting, the</div><div>phantom load \
vanished.</div><div><br></div><div>Regards,</div><div>Ken</div></div></div></span>  
                 
                 
                 
                </blockquote>
                 
                <div>
                    <br>
                </div>
            



[prev in list] [next in list] [prev in thread] [next in thread]