From: Mark Wong <markwkm@gmail.com>
To: Greg Smith <gsmith@gregsmith.com>
Cc: Scott Carey <scott@richrelevance.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>
Cc: Selena Deckelmann <selenamarie@gmail.com>
Cc: Gabrielle Roth <gorthx@gmail.com>
Subject: Re: Using IOZone to simulate DB access patterns
Date: Sun, 26 Apr 2009 20:28:13 -0700
Message-ID: <70c01d1d0904262028j42fc4940s116fc14ec26d2e35@mail.gmail.com> (raw)
In-Reply-To: <70c01d1d0904111144m50c569bbh7dc32f2bce36195e@mail.gmail.com>
References: <C604CBE2.4856%scott@richrelevance.com>
<alpine.GSO.2.01.0904101359490.21946@westnet.com>
<70c01d1d0904111144m50c569bbh7dc32f2bce36195e@mail.gmail.com>
On Sat, Apr 11, 2009 at 11:44 AM, Mark Wong <markwkm@gmail.com> wrote:
> On Fri, Apr 10, 2009 at 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
>
> There's a couple of potential flaws I'm trying to characterize this
> weekend. I'm having second thoughts about how I did the sequential
> read and write profiles. Using multiple processes doesn't let it
> really do sequential i/o. I've done one comparison so far resulting
> in about 50% more throughput using just one process to do sequential
> writes. I just want to make sure there shouldn't be any concern for
> being processor bound on one core.
>
> The other flaw is having a minimum run time. The max of 1 hour seems
> to be good to establishing steady system utilization, but letting some
> tests finish in less than 15 minutes doesn't provide "good" data.
> "Good" meaning looking at the time series of data and feeling
> confident it's a reliable result. I think I'm describing that
> correctly...
FYI, I've updated the wiki with the parameters I'm running with now.
I haven't updated the results yet though.
Regards,
Mark
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: markwkm@gmail.com, gsmith@gregsmith.com, scott@richrelevance.com, josh@agliodbs.com, henk53602@hotmail.com, jesper@krogh.cc, selenamarie@gmail.com, gorthx@gmail.com
Subject: Re: Using IOZone to simulate DB access patterns
In-Reply-To: <70c01d1d0904262028j42fc4940s116fc14ec26d2e35@mail.gmail.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