Postgres Pro
Downloads
Home   >   mailing lists

Re: Easy read-heavy benchmark kicking around? - Mailing list pgsql-performance

From Markus Schaber
Subject Re: Easy read-heavy benchmark kicking around?
Date
Msg-id 45520338.2050804@logix-tt.com
Whole thread Raw
In response to Easy read-heavy benchmark kicking around?  (Brian Hurt <bhurt@janestcapital.com>)
Responses Re: Easy read-heavy benchmark kicking around?  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-performance
Tree view 
Hi, Brian,

Brian Hurt wrote:

> 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?

For sequential read performance, use dd. Most variants of dd I've seen
output some timing information, and if not, do a "time dd
if=/your/device of=/dev/null bs=1M" on the partition.

Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Context switching
Next
From: "Merlin Moncure"
Date:
Subject: Re: Easy read-heavy benchmark kicking around?