Re: filesystems benchmark - Mailing list pgsql-performance

From Greg Smith
Subject Re: filesystems benchmark
Date
Msg-id Pine.GSO.4.64.0812151218080.7153@westnet.com
Whole thread Raw
In response to filesystems benchmark  (Adrian Moisey <adrian@careerjunction.co.za>)
List pgsql-performance
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@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: "Vladimir Sitnikov"
Date:
Subject: Re: filesystems benchmark
Next
From: "Jaime Casanova"
Date:
Subject: measure database contention