Re: Looking for bottleneck during load test - Mailing list pgsql-performance

From Ivan Voras
Subject Re: Looking for bottleneck during load test
Date
Msg-id ftd4ic$38k$1@ger.gmane.org
Whole thread Raw
In response to Looking for bottleneck during load test  ("Hell, Robert" <Robert.Hell@fabasoft.com>)
Responses Re: Looking for bottleneck during load test  ("Hell, Robert" <Robert.Hell@fabasoft.com>)
List pgsql-performance
Hell, Robert wrote:
> We have a PostgreSQL 8.2.7 database (~230 GB) running on a machine with 8 Intel Xeon Cores and 32 GB RAM (64-bit
Linux2.6.18). Data is stored on an EMC² CLARiiON on RAID 1/0 (8 x 146 GB 15k rpm).  
> When we do random I/O with a small test tool (reading random 8k blocks from big files in 200 threads) on the disk we
retrievedata with about 25 MB/s. 

How do you test random IO? Do you use this utility:
http://arctic.org/~dean/randomio/ ?

If not, try using it, with same parameters. It might be that the latency
is destroying your performance. Do you use NFS or are you accessing the
storage as SAN?

pgsql-performance by date:

Previous
From: "Hell, Robert"
Date:
Subject: Looking for bottleneck during load test
Next
From: "Matt Klinker"
Date:
Subject: Re: [SOLVED] Query plan excluding index on view