Re: extremly low memory usage - Mailing list pgsql-performance

From Dan Harris
Subject Re: extremly low memory usage
Date
Msg-id EFA54B85-504E-453A-972D-A7DD0E144763@drivefaster.net
Whole thread Raw
In response to Re: extremly low memory usage  (Jeremiah Jahn <jeremiah@cs.earlham.edu>)
Responses Re: extremly low memory usage
Re: extremly low memory usage
List pgsql-performance
On Aug 19, 2005, at 3:01 PM, Jeremiah Jahn wrote:

> Rebuild in progress with just ext3 on the raid array...will see if
> this
> helps the access times.

 From my recent experiences, I can say ext3 is probably not a great
choice for Pg databases.  If you check the archives you'll see
there's a lot of discussion about various journalling filesystems and
ext3 usually(always?) comes up on the bottom as far as performance
goes.  If you insist on using it, I would at least recommend the
noatime option in fstab and using data=writeback to get the faster of
the journal modes.

XFS seems to be a trusted choice, followed by Reiser and JFS both
with the occasional controversy when the comparisons pop up.

-Dan


pgsql-performance by date:

Previous
From: Dan Harris
Date:
Subject: Re: Query plan looks OK, but slow I/O - settings advice?
Next
From: Marko Ristola
Date:
Subject: Re: extremly low memory usage