Thread: What filesystem works best for PostgreSQL?

I'm in the process of adding a new filesystem to our development server
for Postgres data.  I have been using ext3fs and ext2fs for PG databases
and I haven't been impressed with the performance.

So, has anyone out there benchmarked the various Linux filesystems for
PG performance?  More information:  RH 7.3, 3 or 6 disk RAID5
(hardware).  Kernel 2.4.19.

Cheers!

Bob
--
Robert M. Meyer
Sr. Network Administrator
INSTALLS inc
14 Lafayette Sq, Ste 700
Buffalo, NY 14203-1904
(716)332-1451

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. 

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