Re: File Sytems Types and Os Recomendations - Mailing list pgsql-admin

From Christopher Browne
Subject Re: File Sytems Types and Os Recomendations
Date
Msg-id 607k48h12c.fsf@dev6.int.libertyrms.info
Whole thread Raw
In response to File Sytems Types and Os Recomendations  ("John Allgood" <john@turbocorp.com>)
List pgsql-admin
john@turbocorp.com ("John Allgood") writes:
>         I am looking for information on what operating systems and
> filesystems people are running postgresql on. I have read so much on
> this I decided to get some input from other people. I at first was
> leaning toward FreeBSD and using its filesystem. We are a linux shop
> and love it. What are thoughts on using ext3 or some other Linux
> filesystems is there really that much performance difference by
> using ext3 v/s BSD/FS/UFS.

I did some update-heavy benchmarking recently, comparing Linux FSes,
and found that of (ext3, XFS, JFS), the fastest one, by a moderate
margin, was JFS.

It was not unexpected that XFS and JFS were faster than ext3; what was
a bit surprising was that JFS was quite a bit faster than XFS.  The
last I had heard, JFS was considered pretty slow as it hadn't been
tuned too much; apparently that has changed.

I didn't get around to testing FreeBSD with soft updates; the downside
to that was, in my environment, and may also be, for you, that there
was a lack of administrative familiarity.  We have too many "heads
exploding" from absorbing other things right now to be able to afford
to throw in the learning curve of FreeBSD at this point in time.
--
let name="cbbrowne" and tld="acm.org" in name ^ "@" ^ tld;;
http://cbbrowne.com/info/nonrdbms.html
"The nice  thing about standards  is that you  have so many  to choose
from.  Furthermore, if you do not  like any of them, you can just wait
for next year's model."  -- Tanenbaum, "Computer Networks"

pgsql-admin by date:

Previous
From: "Somasekhar Bangalore"
Date:
Subject: how to find multi-byte is enabled or not for 7.2.3
Next
From: Tom Lane
Date:
Subject: Re: Recycle The Wal logs