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=0E1HB_cS5ab58i-2RFTLYeb1MTijS-cZ-R2_sRuwXjHw@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>)
List pgsql-performance
On Mon, Feb 18, 2013 at 5:39 PM, Josh Berkus <josh@agliodbs.com> wrote:
> Scott,
>
>> So do you have generally slow IO, or is it fsync behavior etc?
>
> All tests except pgBench show this system as superfast.  Bonnie++ and DD
> tests are good (200 to 300mb/s), and test_fsync shows 14K/second.
> Basically it has no issues until checkpoint kicks in, at which time the
> entire system basically halts for the duration of the checkpoint.

I assume you've made attemtps at write levelling to reduce impacts of
checkpoints etc.


pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Next
From: Mark Kirkwood
Date:
Subject: Re: High CPU usage / load average after upgrading to Ubuntu 12.04