From: Scott Carey <scott@richrelevance.com>
To: Greg Smith <gsmith@gregsmith.com>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: henk de wit <henk53602@hotmail.com>
Cc: jesper@krogh.cc <jesper@krogh.cc>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Using IOZone to simulate DB access patterns
Date: Fri, 10 Apr 2009 11:17:39 -0700
Message-ID: <C604DB53.4877%scott@richrelevance.com> (raw)
In-Reply-To: <alpine.GSO.2.01.0904101359490.21946@westnet.com>
On 4/10/09 11:01 AM, "Greg Smith" <gsmith@gregsmith.com> wrote:
> On Fri, 10 Apr 2009, Scott Carey wrote:
>
>> FIO with profiles such as the below samples are easy to set up
>
> There are some more sample FIO profiles with results from various
> filesystems at
> http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide
I wish to thank Greg here as many of my profile variations came from the
above as a starting point.
Note in his results the XFS file system behavior on random writes is due to
FIO doing 'sparse writes' (which Postgres does not do, and fio exposes some
issues on xfs with) in the default random write mode. To properly simulate
Postgres these should be random overwrites.
Add 'overwrite=true' to the profile for random writes and the whole file
will be allocated before randomly (over)writing to it.
Here is the man page:
http://linux.die.net/man/1/fio>
> --
> * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott@richrelevance.com, gsmith@gregsmith.com, josh@agliodbs.com, henk53602@hotmail.com, jesper@krogh.cc
Subject: Re: Using IOZone to simulate DB access patterns
In-Reply-To: <C604DB53.4877%scott@richrelevance.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox