Message-ID: <5122C9D9.9040909@agliodbs.com>
Date: Mon, 18 Feb 2013 16:39:53 -0800
From: Josh Berkus <josh@agliodbs.com>
Organization: PostgreSQL Experts Inc.
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:17.0) Gecko/20130106 Thunderbird/17.0.2
MIME-Version: 1.0
To: Scott Marlowe <scott.marlowe@gmail.com>
CC: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: High CPU usage / load average after upgrading to Ubuntu
 12.04
References: 
 <60B572D9298D944580F7D51195DD30804357FA4ABF@VMBX125.ihostexchange.net>
	<CABdoJnZmO3M3a20KZWDpfaLG++deaHPdGY8AMPKfRF4Sz=GygQ@mail.gmail.com>
	<60B572D9298D944580F7D51195DD30804357FA4B60@VMBX125.ihostexchange.net>
	<dpg5ol29ltnb072ngdg8auj4.1360707457411@email.android.com>
	<60B572D9298D944580F7D51195DD30804357FA4C11@VMBX125.ihostexchange.net>
	<511BE879.8080706@agliodbs.com> <511C2F10.3080409@agliodbs.com>
	<60B572D9298D944580F7D51195DD30804357FA4DE2@VMBX125.ihostexchange.net>
	<511D2F11.6040706@agliodbs.com>
	<60B572D9298D944580F7D51195DD308043580CAA0B@VMBX125.ihostexchange.net>
	<511D79FE.7060705@agliodbs.com>
	<60B572D9298D944580F7D51195DD308043580CAA87@VMBX125.ihostexchange.net>
	<CAOR=d=3CqRL5jrFRTSg9kFdcJzKpx3TJSsoDwRqpPUO=ENoFRQ@mail.gmail.com>
	<511E7DC0.4090506@agliodbs.com>
	<CAOR=d=2cEi=ibGS4DCrFAWq8VtCz6XEYDsMyarBX=evshLWgKg@mail.gmail.com>
	<5122C507.7060303@agliodbs.com>
	<CAOR=d=3bXmMmTvh3cKCizhwsijxg6wh6ADC053w-dbkC3e_zCQ@mail.gmail.com>
In-Reply-To: 
 <CAOR=d=3bXmMmTvh3cKCizhwsijxg6wh6ADC053w-dbkC3e_zCQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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.

For that matter, if I run a pgbench and halt it just before checkpoint
kicks in, I get around 12000TPS, which is what I'd expect on this system.

At this point, we've tried 3.2.0.26, 3.2.0.27, 3.4.0, and tried updating
the RAID driver, and changing the IO scheduler.  Nothing seems to affect
the behavior.   Testing using Ext4 (instead of XFS) next.


-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance