Message-ID: <454F9F62.9070408@janestcapital.com>
Date: Mon, 06 Nov 2006 15:47:30 -0500
From: Brian Hurt <bhurt@janestcapital.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Easy read-heavy benchmark kicking around?
References: <20061102160057.GA26580@oppetid.no>
In-Reply-To: <20061102160057.GA26580@oppetid.no>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I'm having a spot of problem with out storage device vendor.  Read 
performance (as measured by both bonnie++ and hdparm -t) is abysmal 
(~14Mbyte/sec), and we're trying to get them to fix it.  Unfortunately, 
they're using the fact that bonnie++ is an open source benchmark to 
weasle out of doing anything- they can't fix it unless I can show an 
impact in Postgresql.

So the question is: is there an easy to install and run, read-heavy 
benchmark out there that I can wave at them to get them to fix the 
problem?  I have a second database running on a single SATA drive, so I 
can use that as a comparison point- "look, we're getting 1/3rd the read 
speed of a single SATA drive- this sucks!"

Any advice?

Brian