Re: Benchmarking a large server - Mailing list pgsql-performance

From Yeb Havinga
Subject Re: Benchmarking a large server
Date
Msg-id 4DC8E20D.7090602@gmail.com
Whole thread Raw
In response to Benchmarking a large server  (Chris Hoover <revoohc@gmail.com>)
List pgsql-performance
On 2011-05-09 22:32, Chris Hoover wrote:
>
> The issue we are running into is how do we benchmark this server,
> specifically, how do we get valid benchmarks for the Fusion IO card?
>  Normally to eliminate the cache effect, you run iozone and other
> benchmark suites at 2x the ram.  However, we can't do that due to 2TB
> > 1.3TB.
>
> So, does anyone have any suggestions/experiences in benchmarking
> storage when the storage is smaller then 2x memory?

Oracle's Orion test tool has a configurable cache size parameter - it's
a separate download and specifically written to benchmark database oltp
and olap like io patterns, see
http://www.oracle.com/technetwork/topics/index-089595.html

--
Yeb Havinga
http://www.mgrid.net/
Mastering Medical Data


pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Benchmarking a large server
Next
From: AI Rumman
Date:
Subject: 8.2.13 commit is taking too much time