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:[EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
