From: Ivan Voras <ivoras@geri.cc.fer.hr>
To: pgsql-performance@postgresql.org
Subject: Re: Looking for bottleneck during load test
Date: Tue, 08 Apr 2008 11:02:44 +0200
Message-ID: <ftfcbk$50k$2@ger.gmane.org> (raw)
In-Reply-To: <B710F3299F04664DB6B37C258FDEEB94015F1CD6@FABAMAIL.fabagl.fabasoft.com>
References: <B710F3299F04664DB6B37C258FDEEB94015F1BA1@FABAMAIL.fabagl.fabasoft.com>
<ftd4ic$38k$1@ger.gmane.org>
<B710F3299F04664DB6B37C258FDEEB94015F1CD6@FABAMAIL.fabagl.fabasoft.com>
Hell, Robert wrote:
> > I tried different other tools for random IO (including a self
written one which does random lseek and read).
> >
> > This tool, started during one of our tests, achieves 2 iops (8k each).
> > Started alone I get something about 1,500 iops with an avg latency
of 100 ms.
1500 iops looks about right for 4x2 RAID 10 volume. What's your worst
latency (as reported by the tool)? iowait is mostly seek time.
> > We are using SAN (EMC CLARiiON CX 300) - are those ~7 MB/s really
our bottleneck?
Depending on your access pattern to the database, it could be (if you
have lots of random IO, and 180 concurrent database threads can make any
IO random enough). Are your queries read-mostly or a mix?
> > Any other tuning ideas?
Only generic ones:
- Are your queries optimized, use indexes, etc.?
- Try PostgreSQL 8.3 - if you have sequential seeks it can in theory
make better use of data between connections.
- Do you have enough memory dedicated to data caches, both in PostgreSQL
and in the OS? (i.e. what is your shared_buffers setting?)
- If the SAN can configure parameters such as prefetch (pre-read) and
stripe size, try lowering them (should help if you have random IO).
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@geri.cc.fer.hr
Subject: Re: Looking for bottleneck during load test
In-Reply-To: <ftfcbk$50k$2@ger.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