Re: What filesystem works best for PostgreSQL?

From: Vincent Janelle <random(at)goblinstudios(dot)com>
To: Aschaffer(at)bloomberg(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: What filesystem works best for PostgreSQL?
Date: 2003-01-29 21:23:35
Message-ID: 20030129162335.67ae9c1b.random@goblinstudios.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)bloomberg(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Aris wendy 2003-01-30 04:11:03 Database Management Setup
Previous Message Aschaffer 2003-01-29 18:38:55 Re: What filesystem works best for PostgreSQL?