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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

On Wed, Aug 23, 2006 at 03:23:03PM -0700, Jeff Davis wrote:
>Also, do ext2 or UFS without soft updates run the risk of losing or
>corrupting my data?

I suggest you check the list archives; there's a lot of stuff about
filesystems and disk configuration in there.

Mike Stone

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On Wed, 2006-08-23 at 21:50 -0400, Michael Stone wrote:
> On Wed, Aug 23, 2006 at 03:23:03PM -0700, Jeff Davis wrote:
> >Also, do ext2 or UFS without soft updates run the risk of losing or
> >corrupting my data?
>
> I suggest you check the list archives; there's a lot of stuff about
> filesystems and disk configuration in there.
>

I spent a while looking in the list archives, but the list archives have
been misbehaving lately (you click on a search result and the message
that appears doesn't have the same subject as the one you clicked on).
They may have fixed that (they are aware of the problem, according to
pgsql-www). Also, the messages I was able to find were mostly from a
long time ago.

If you have a pointer to a particularly useful thread please let me
know.

Regards,
Jeff Davis


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org