| From: | Dan Harris <fbsd(at)drivefaster(dot)net> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: extremly low memory usage |
| Date: | 2005-08-20 07:12:15 |
| Message-ID: | EFA54B85-504E-453A-972D-A7DD0E144763@drivefaster.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marko Ristola | 2005-08-20 11:17:54 | Re: extremly low memory usage |
| Previous Message | Dan Harris | 2005-08-20 06:52:08 | Re: Query plan looks OK, but slow I/O - settings advice? |