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@janestcapital.com]
Sent: Monday, November 06, 2006 03:49 PM Eastern Standard Time
To: pgsql-performance@postgresql.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
