Re: filesystems benchmark - Mailing list pgsql-performance

From Vladimir Sitnikov
Subject Re: filesystems benchmark
Date
Msg-id 1d709ecc0812150402v62375a88y121d5515d7210cd2@mail.gmail.com
Whole thread Raw
In response to filesystems benchmark  (Adrian Moisey <adrian@careerjunction.co.za>)
List pgsql-performance
I'm trying to compare different filesystems for postgres using pgbench.  The problem I've seen is that my IO wait is very very low.  Is there a way I can get pgbench to do more to push that up a little?
Why do you expect to see high IO wait?

Does your database fit in system memory? If you do not modify the data and it is not large enough, it is unlikely you will hit IO wait.

Do you have write cache enabled for the file system/device? Even if you have some DML statements, it would not be that easy to saturate write cache enabled storage (especially, when it fits in memory).


Regards,
Vladimir Sitnikov

pgsql-performance by date:

Previous
From: Adrian Moisey
Date:
Subject: filesystems benchmark
Next
From: Greg Smith
Date:
Subject: Re: filesystems benchmark