Re: Using IOZone to simulate DB access patterns

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Scott Carey <scott(at)richrelevance(dot)com>
Cc: henk de wit <henk53602(at)hotmail(dot)com>, jesper(at)krogh(dot)cc, pgsql-performance(at)postgresql(dot)org
Subject: Re: Using IOZone to simulate DB access patterns
Date: 2009-04-10 17:31:35
Message-ID: 49DF8277.4050801@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Carey 2009-04-10 17:40:46 Re: Using IOZone to simulate DB access patterns
Previous Message Tom Lane 2009-04-10 17:19:36 Re: Shouldn't the planner have a higher cost for reverse index scans?