From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Subject: Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Date: Wed, 13 Feb 2013 16:25:52 -0800
Message-ID: <511C2F10.3080409@agliodbs.com> (raw)
In-Reply-To: <511BE879.8080706@agliodbs.com>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 02/13/2013 11:24 AM, Josh Berkus wrote:
> On 02/12/2013 05:28 PM, Dan Kogan wrote:
>> Hi Will,
>>
>> Yes, I think we've seen some discussions on that. Our servers our hosted on Amazon Ec2 and upgrading the kernel does not seem so straight forward.
>> We did a benchmark using pgbench on 3.5 vs 3.2 and saw an improvement. Unfortunately our production server would not boot off 3.5 so we had to revert back to 3.2.
>>
>> At this point we are contemplating whether it's better to go back to 11.04 or upgrade to 12.10 (which comes with kernel version 3.5).
>> Any thoughts on that would be appreciated.
>
> I have a machine running the same version of Ubuntu. I'll run some
> tests and tell you what I find.
So I'm running a pgbench. However, I don't really have anything to
compare the stats I'm seeing. CPU usage and load average was high (load
7.9), but that was on -j 8 -c 32, with a TPS of 8500.
What numbers are you seeing, exactly?
--
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com
Subject: Re: High CPU usage / load average after upgrading to Ubuntu 12.04
In-Reply-To: <511C2F10.3080409@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox