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

help / color / mirror / Atom feed
From: Ivan Voras <ivoras@freebsd.org>
To: pgsql-performance@postgresql.org
Subject: Re: Adding more memory = hugh cpu load
Date: Tue, 11 Oct 2011 12:20:45 +0200
Message-ID: <j7159t$jhf$1@dough.gmane.org> (raw)
In-Reply-To: <CAEV0TzD8uae+1yqK3Z9XYL9_S57ZJHz3w-UirHaCvSj=XodiYQ@mail.gmail.com>
References: <4E92F294.9010405@gmail.com>
	<4E92FB87.1030703@peak6.com>
	<4E932BFC.7070007@gmail.com>
	<4E92E9340200002500041CD5@gw.wicourts.gov>
	<4E933F4B.2080808@gmail.com>
	<4E9303A00200002500041CFE@gw.wicourts.gov>
	<4E9356E5.6000308@gmail.com>
	<4E9314A50200002500041D12@gw.wicourts.gov>
	<CAEV0TzD8uae+1yqK3Z9XYL9_S57ZJHz3w-UirHaCvSj=XodiYQ@mail.gmail.com>

On 11/10/2011 00:02, Samuel Gendler wrote:

> The original question doesn't actually say that performance has gone down,
> only that cpu utilization has gone up. Presumably, with lots more RAM, it is
> blocking on I/O a lot less, so it isn't necessarily surprising that CPU
> utilization has gone up.  

It's Linux - it counts IO wait in the load average. Again there are too
little details to be sure of anything, but it is possible that the IO
rate didn't go down.

Attachments:

  signature.asc (application/pgp-signature, 259B) download

view thread (24+ messages)  latest in thread

Message-ID: <j7159t$jhf$1@dough.gmane.org>
Permalink:  ../j7159t$jhf$1@dough.gmane.org/
Also on:    postgresql.org/message-id/j7159t$jhf$1@dough.gmane.org

 · 

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: ivoras@freebsd.org
  Subject: Re: Adding more memory = hugh cpu load
  In-Reply-To: <j7159t$jhf$1@dough.gmane.org>

* 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