| From: | Scott Carey <scott(at)richrelevance(dot)com> |
|---|---|
| To: | Greg Smith <gsmith(at)gregsmith(dot)com> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, henk de wit <henk53602(at)hotmail(dot)com>, "jesper(at)krogh(dot)cc" <jesper(at)krogh(dot)cc>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Using IOZone to simulate DB access patterns |
| Date: | 2009-04-10 18:17:39 |
| Message-ID: | C604DB53.4877%scott@richrelevance.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 4/10/09 11:01 AM, "Greg Smith" <gsmith(at)gregsmith(dot)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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Cox | 2009-04-10 19:05:11 | determining the locks that will be held by a query |
| Previous Message | Josh Berkus | 2009-04-10 18:07:09 | Re: Postgres 8.x on Windows Server in production |