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.
-----Original Message-----
From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Josh Berkus
Sent: Thursday, February 14, 2013 1:38 PM
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] High CPU usage / load average after upgrading to Ubuntu 12.04
On 02/13/2013 05:30 PM, Dan Kogan wrote:
> Just to be clear - I was describing the current situation in our production.
>
> We were running pgbench on different Ununtu versions today. I don’t have 12.04 setup at the moment, but I do have
12.10,which seems to be performing about the same as 12.04 in our tests with pgbench.
> Running pgbench with 8 jobs and 32 clients resulted in load average of about 15 and TPS was 51350.
What size database?
>
> Question - how many cores does your server have? Ours has 8 cores.
32
I suppose I could throw multiple pgbenches at it. I just dont' see the load numbers as unusual, but I don't have a
similarpre-12.04 server to compare with.
--
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
