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