Postgres Pro
Downloads
Home   >   mailing lists

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

From Aschaffer@bloomberg.com
Subject Re: What filesystem works best for PostgreSQL?
Date
Msg-id 54BC8D1BCFFF4343A748FE5EC719D40D05196744@bny526.bloomberg.com
Whole thread Raw
In response to What filesystem works best for PostgreSQL?  ("Robert M. Meyer" <rmeyer@installs.com>)
Responses Re: What filesystem works best for PostgreSQL?  (Vincent Janelle <random@goblinstudios.com>)
List pgsql-admin
Tree view 
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.

pgsql-admin by date:

Previous
From: "Robert M. Meyer"
Date:
Subject: What filesystem works best for PostgreSQL?
Next
From: Vincent Janelle
Date:
Subject: Re: What filesystem works best for PostgreSQL?