pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: eleven@ludojad.itpp.pl
To: pgsql-performance@postgresql.org
Subject: Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver.
Date: Tue, 29 Jun 2004 19:52:27 +0200
Message-ID: <20040629175227.GA11658@ludojad.itpp.pl> (raw)
In-Reply-To: <9662496504062909172bf8034b@mail.gmail.com>
References: <20040629155537.GA5465@ludojad.itpp.pl>
	<9662496504062909172bf8034b@mail.gmail.com>

On Tue, Jun 29, 2004 at 09:17:36AM -0700, Marc wrote:

> > Performance issue, I'm experiencing here, is somewhat
> > weird - server gets high average load (from 5 up to 15,
> > 8 on average). Standard performance monitoring
> > utilities (like top) show that CPUs are not loaded
> > (below 20%, often near zero).
> So ... you never actually say what the performance issue you
> experience is.  Having a high load average is not necessarily a
> performance issue.

Well, if the server's CPUs are idle and the machine
is starting to hog itself, one can
suspect something bad going on.

> What is it that you want to fix?

Basically, I'm wondering if I'm already on the edge of 
performance capabilities of this machine/configuration, or maybe
there's some abnormal behaviour happening (which
could be noticed by somebody from this mailing list, hopefully).

In particular - could someone tell me if those iostat
values can tell if I'm close to upper performance boundary
of fast SCSI (Ultra 320, 15k RPM) disks? 

-- 
11.



view thread (7+ messages)  latest in thread

Message-ID: <20040629175227.GA11658@ludojad.itpp.pl>
Permalink:  ../20040629175227.GA11658@ludojad.itpp.pl/
Also on:    postgresql.org/message-id/20040629175227.GA11658@ludojad.itpp.pl

 · 

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: eleven@ludojad.itpp.pl
  Subject: Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver.
  In-Reply-To: <20040629175227.GA11658@ludojad.itpp.pl>

* 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