Re: Using IOZone to simulate DB access patterns

Josh Berkus <josh@agliodbs.com>

From: Josh Berkus <josh@agliodbs.com>
To: Scott Carey <scott@richrelevance.com>
Cc: henk de wit <henk53602@hotmail.com>, jesper@krogh.cc, pgsql-performance@postgresql.org
Date: 2009-04-10T17:31:35Z
Lists: pgsql-performance
Scott,

> FIO with profiles such as the below samples are easy to set up, and they can
> be mix/matched to test what happens with mixed read/write seq/rand -- with
> surprising and useful tuning results.  Forcing a cache flush or sync before
> or after a run is trivial.  Changing to asynchronous I/O, direct I/O, or
> other forms is trivial.  The output result formatting is very useful as
> well.

FIO?  Link?


-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com