Re: High CPU usage / load average after upgrading to Ubuntu 12.04

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Dan Kogan <dan(at)iqtell(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Date: 2013-02-15 04:47:45
Message-ID: CAOR=d=3CqRL5jrFRTSg9kFdcJzKpx3TJSsoDwRqpPUO=ENoFRQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

If you run your benchmarks for more than a few minutes I highly
recommend enabling sysstat service data collection, then you can look
at it after the fact with sar. VERY useful stuff both for
benchmarking and post mortem on live servers.

On Thu, Feb 14, 2013 at 9:32 PM, Dan Kogan <dan(at)iqtell(dot)com> wrote:
> Yes, we are seeing higher system % on the CPU, not sure how to quantify in terms of % right now - will check into that tomorrow.
> We were not checking the context switch numbers during our benchmark, will check that tomorrow as well.
>
> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Josh Berkus
> Sent: Thursday, February 14, 2013 6:58 PM
> To: pgsql-performance(at)postgresql(dot)org
> Subject: Re: [PERFORM] High CPU usage / load average after upgrading to Ubuntu 12.04
>
> On 02/14/2013 12:41 PM, Dan Kogan wrote:
>> We used scale factor of 3600.
>> Yeah, maybe other people see similar load average, we were not sure.
>> However, we saw a clear difference right after the upgrade.
>> We are trying to determine whether it makes sense for us to go to 11.04 or maybe there is something here we are missing.
>
> Well, I'm seeing a higher system % on CPU than I expect (around 15% on each core), and a MUCH higher context-switch than I expect (up to 500K).
> Is that anything like you're seeing?
>
> --
> Josh Berkus
> PostgreSQL Experts Inc.
> http://pgexperts.com
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance

--
To understand recursion, one must first understand recursion.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ali Pouya 2013-02-15 08:47:20 Re: Partition insert trigger using C language
Previous Message Dan Kogan 2013-02-15 04:32:15 Re: High CPU usage / load average after upgrading to Ubuntu 12.04