Re: System Load analyze

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Peter Bauer <peter(dot)bauer(at)apus(dot)co(dot)at>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: System Load analyze
Date: 2007-11-29 06:28:33
Message-ID: Pine.GSO.4.64.0711290021380.13473@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 28 Nov 2007, Peter Bauer wrote:

> PERC4E/DI DC ULTRA320 SCSI RAID, 256MB
> Its Debian sarge with kernel 2.4.26.050719-686 #1 SMP.

OK, so I'd expect you're using the megaraid2 driver. That and kernel
2.4.26 are a few years behind current at this point, and there have been
plenty of performance improvements in Linux and that driver since then.
Since you're asking about this before it's a serious problem and don't
need an immediate fix, you may want to consider whether upgrading to a
more modern 2.6 kernel is in your future; that change alone may resolve
some of the possibly too high load you're having. I doubt any 2.4 kernel
is really getting the best from your fairly modern server hardsare.

Also, the PERC4E and similar Megaraid cards are known to be generally
sluggish on write throughput compared with some of the competing products
out there. I don't know that I'd replace it though, as spending the same
amount of money adding disks would probably be more useful.

There's actually a way to combine these two ideas and get an upgrade
transition plan. Buy a second disk, find a downtime window, install a
newer Linux onto it and test. If that works well switch to it. If it
doesn't you still have the original unmodified system around and you can
at least split the disk load between the two drives.

> vmstat and iostat were running with 1 second intervals.

Good, that means the responses you've already gotten made the right
assumptions. There's some additional fun statistics you can collect with
the Linux iostat, but sadly that needs a newer kernel as well.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josh Trutwin 2007-11-29 06:41:55 Re: Why upgrade?
Previous Message Gregory Williamson 2007-11-29 06:11:07 Re: PostgresSQL vs. Informix