Re: Best Linux filesystem for Postgres data store ?

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.