pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <smarlowe@qwest.net>
To: eleven@ludojad.itpp.pl
Cc: pgsql-performance@postgresql.org
Subject: Re: High load average with PostgreSQL 7.4.2 on
Date: Tue, 29 Jun 2004 16:36:55 -0600
Message-ID: <1088548615.12350.44.camel@localhost.localdomain> (raw)
In-Reply-To: <20040629155537.GA5465@ludojad.itpp.pl>
References: <20040629155537.GA5465@ludojad.itpp.pl>

On Tue, 2004-06-29 at 09:55, eleven@ludojad.itpp.pl wrote:
> Hello,
> 
> I'm using PostgreSQL 7.4.2 (package from backports.org) 
> on a Debian (woody) box. The machine is IBM eServer 345
> with two 2.8 Xeon CPUs, it has 1024MB of RAM and
> two 15k RPM SCSI disks running in hardware RAID1, which
> is provided by the onboard LSI Logic controller (LSI53C1030).
> 
> The database consists of two rather large tables 
> (currently about 15 million rows in one table
> and about 5 million in the other one). Both tables
> have 5 indexes (4 btree/1 hash). 
> Application running on the server INSERTs a lot of 
> stuff to the tables (which is not the target use of
> the DB, it'll add data periodically, about
> 300 rows per 10 minutes). Queries (SELECTs) run perfectly
> fine on the database, thanks to the indexes we have
> here probably. 
> 
> 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). 

Anytime you have high load but low CPU utilization, you usually have an
I/O bound system.

Ad disks to your RAID (big RAID 5 or RAID 1+0) and make sure you have
battery backed cache set to write back.  also, put as memory as you can
in the machine.  Jumping up to 2 Gigs may help quite a bit as well.




view thread (7+ messages)  latest in thread

Message-ID: <1088548615.12350.44.camel@localhost.localdomain>
Permalink:  ../1088548615.12350.44.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1088548615.12350.44.camel@localhost.localdomain

 · 

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: smarlowe@qwest.net, eleven@ludojad.itpp.pl
  Subject: Re: High load average with PostgreSQL 7.4.2 on
  In-Reply-To: <1088548615.12350.44.camel@localhost.localdomain>

* 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