nick.lello@rentrakmail.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.