Re: Easy read-heavy benchmark kicking around?

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