Re: filesystems benchmark

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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD