From: | Chris Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Best Linux filesystem for Postgres data store ? |
Date: | 2010-12-01 19:07:15 |
Message-ID: | 87lj498g7w.fsf@cbbrowne.afilias-int.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-12-01 21:31:36 | Re: Best Linux filesystem for Postgres data store ? |
Previous Message | Lou Picciano | 2010-12-01 18:28:36 | Re: Best Linux filesystem for Postgres data store ? |