Re: Easy read-heavy benchmark kicking around?

["Luke Lonergan" <LLonergan(at)greenplum(dot)com>]

Select count(*) from table-twice-size-of-ram

Divide the query time by the number of pages in the table times the pagesize (normally 8KB) and you have your net disk rate.

- Luke

Msg is shrt cuz m on ma treo

 -----Original Message-----
From: 	Brian Hurt [mailto:bhurt(at)janestcapital(dot)com]
Sent:	Monday, November 06, 2006 03:49 PM Eastern Standard Time
To:	pgsql-performance(at)postgresql(dot)org
Subject:	[PERFORM] Easy read-heavy benchmark kicking around?

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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster