Re: Using IOZone to simulate DB access patterns - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Using IOZone to simulate DB access patterns
Date
Msg-id 49DF8277.4050801@agliodbs.com
Whole thread Raw
In response to Re: Using IOZone to simulate DB access patterns  (Scott Carey <scott@richrelevance.com>)
Responses Re: Using IOZone to simulate DB access patterns
List 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Shouldn't the planner have a higher cost for reverse index scans?
Next
From: Scott Carey
Date:
Subject: Re: Using IOZone to simulate DB access patterns