On Mon, 15 Dec 2008, Adrian Moisey wrote:
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?
Increase the database scale until the wait is what you expect. See http://www.westnet.com/~gsmith/gregsmith/content/postgresql/pgbench-scaling.htm for details.
The latest filesystem performance comparison I'm aware of is at http://www.baconandtech.com/files/filesystem_io.pdf
You might also take a look at that to make sure you're not re-mapping territory that's already been explored.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance