From: Jeff Davis <pgsql@j-davis.com>
To: pgsql-performance@postgresql.org
Subject: Which benchmark to use for testing FS?
Date: Wed, 23 Aug 2006 15:23:03 -0700
Message-ID: <1156371783.15743.157.camel@dogma.v10.wvs> (raw)
I am planning to test various filesystems on some new hardware I'm
getting. Is pgbench a good way to try out the filesystem?
I'm currently planning to test some or all of:
Linux: ext2, ext3, XFS, JFS, reiser3, reiser4
FreeBSD: UFS, UFS+SU
So, I'm looking for a good way to test just the filesystem performance
through PostgreSQL (since database access is different than normal FS
activity). Would pgbench give me a good approximation?
Also, do ext2 or UFS without soft updates run the risk of losing or
corrupting my data?
I saw Chris Browne did some benchmarks back in 2003 and determined that
JFS was a good choice. However, I assume things have changed somewhat
since then. Does anyone have a pointer to some newer results?
Regards,
Jeff Davis
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pgsql@j-davis.com
Subject: Re: Which benchmark to use for testing FS?
In-Reply-To: <1156371783.15743.157.camel@dogma.v10.wvs>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox