Re: Best Linux filesystem for Postgres data store ?

nick(dot)lello(at)rentrakmail(dot)com ("Lello, Nick") writes:
> What is considered the best filesystem to use for postgres data stores ?

What is your metric for "best"?

Several are plausible:

- Fastest, for write workload (read performance doesn't usually vary
much based on filesystem)

- Fastest, for recovery from problems (e.g. - spontaneous reboot, where
journalled options are generally preferred)

- Best supported by some vendor (which historically tends to point
towards ext3, away from JFS and ReiserFS, with ambiguous results for
XFS)

- Most reliable (under some defined set of conditions, which tend not to
be well-defined)

- Perhaps some other metric, such as ability to support atomic backups
(where interesting options include ZFS, or running other filesystems
layered atop LVM)

I could see there being five different answers.
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org').
http://linuxdatabases.info/info/fs.html
He doesn't have much of a reputation, or so I've heard.