Re: What filesystem works best for PostgreSQL? - Mailing list pgsql-admin

From Vincent Janelle
Subject Re: What filesystem works best for PostgreSQL?
Date
Msg-id 20030129162335.67ae9c1b.random@goblinstudios.com
Whole thread Raw
In response to Re: What filesystem works best for PostgreSQL?  (Aschaffer@bloomberg.com)
List pgsql-admin
ext3/xfs by default journal the meta-data changes.  You can turn this
off in ext3 by simply mounting as ext2.

On Wed, 29 Jan 2003 13:38:55 -0500
Aschaffer@bloomberg.com wrote:

> XFS seems to work pretty well.  ext3 uses journaling which is very
> slow, xfs uses it as well but xfs tends to be faster overall.  Try
> adding data =writeback to the mount parameters when using ext3 or xfs.
>  I think this turns of journaling.
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 4: Don't 'kill -9' the
> postmaster

pgsql-admin by date:

Previous
From: Aschaffer@bloomberg.com
Date:
Subject: Re: What filesystem works best for PostgreSQL?
Next
From: Aris wendy
Date:
Subject: Database Management Setup