pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
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: Thu, 14 Feb 2013 10:38:09 -0800
Message-ID: <511D2F11.6040706@agliodbs.com> (raw)
In-Reply-To: <60B572D9298D944580F7D51195DD30804357FA4DE2@VMBX125.ihostexchange.net>
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>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

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 similar pre-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



view thread (33+ messages)  latest in thread

Message-ID: <511D2F11.6040706@agliodbs.com>
Permalink:  ../511D2F11.6040706@agliodbs.com/
Also on:    postgresql.org/message-id/511D2F11.6040706@agliodbs.com

 · 

reply
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: <511D2F11.6040706@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