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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Date: 2013-02-19 03:41:26
Message-ID: CAOR=d=0E1HB_cS5ab58i-2RFTLYeb1MTijS-cZ-R2_sRuwXjHw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Feb 18, 2013 at 5:39 PM, Josh Berkus <josh(at)agliodbs(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2013-02-19 04:28:00 Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Previous Message Josh Berkus 2013-02-19 00:51:50 Re: High CPU usage / load average after upgrading to Ubuntu 12.04