Re: Postgres 9.2 CPU Usage

From: "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
To: Vasiliy I Ozerov <vozerov(at)2reallife(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres 9.2 CPU Usage
Date: 2013-12-19 21:20:07
Message-ID: 20131219212007.GU19242@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vasiliy I Ozerov 2013-12-19 21:26:29 Re: Postgres 9.2 CPU Usage
Previous Message Vasiliy I Ozerov 2013-12-19 20:56:47 Postgres 9.2 CPU Usage