From: Josh Berkus <josh@agliodbs.com>
To: 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 16:34:48 -0700
Message-ID: <200406291634.48909.josh@agliodbs.com> (raw)
In-Reply-To: <20040629175227.GA11658@ludojad.itpp.pl>
References: <20040629155537.GA5465@ludojad.itpp.pl>
<9662496504062909172bf8034b@mail.gmail.com>
<20040629175227.GA11658@ludojad.itpp.pl>
Eleven,
> 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?
It's quite possible that you need to improve your disk array; certainly I
would have spec'd a lot more disk than you're using (like raid 0+1 with 6
disks or RAID 5 with seven disks).
However, there's the other end as well; it's quite possible that your queries
are doing seq scans and other disk-intensive operations that could be
avoided. Have you analyed this at all?
--
-Josh Berkus
Aglio Database Solutions
San Francisco
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, eleven@ludojad.itpp.pl
Subject: Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver.
In-Reply-To: <200406291634.48909.josh@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