Re: High CPU usage / load average after upgrading to Ubuntu 12.04 - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Date
Msg-id CAOR=d=2cEi=ibGS4DCrFAWq8VtCz6XEYDsMyarBX=evshLWgKg@mail.gmail.com
Whole thread Raw
In response to Re: High CPU usage / load average after upgrading to Ubuntu 12.04  (Josh Berkus <josh@agliodbs.com>)
Responses Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Re: High CPU usage / load average after upgrading to Ubuntu 12.04
List pgsql-performance
On Fri, Feb 15, 2013 at 11:26 AM, Josh Berkus <josh@agliodbs.com> wrote:
> On 02/14/2013 08:47 PM, Scott Marlowe wrote:
>> 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.
>
> Well, background sar, by default on Linux, only collects every 30min.
> For a benchmark run, you want to generate your own sar file, for example:

On all my machines (debian and ubuntu) it collects every 5.

> sar -o hddrun2.sar -A 10 90 &
>
> which says "collect all stats every 10 seconds and write them to the
> file hddrun2.sar for 15 minutes"

Not a bad idea. esp when benchmarking.


pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Next
From: Scott Marlowe
Date:
Subject: Re: postgresql.conf recommendations