From: Chris Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Subject: Re: Best Linux filesystem for Postgres data store ?
Date: Wed, 01 Dec 2010 14:07:15 -0500
Message-ID: <87lj498g7w.fsf@cbbrowne.afilias-int.info> (raw)
References: <AANLkTinnJhU49CQoD36F9dPRpPg+2inVCGP-jBV7dgny@mail.gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: Best Linux filesystem for Postgres data store ?
In-Reply-To: <87lj498g7w.fsf@cbbrowne.afilias-int.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox