Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id B45B11337BCB for ; Wed, 1 Dec 2010 15:13:03 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 80253-06-5 for ; Wed, 1 Dec 2010 19:12:56 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 7BD741337B7F for ; Wed, 1 Dec 2010 15:12:43 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.4/8.14.4) with ESMTP id oB1JChRQ051243 for ; Wed, 1 Dec 2010 15:12:43 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.4/8.14.4/Submit) id oB1J7ZA7079951 for pgsql-admin@postgresql.org; Wed, 1 Dec 2010 15:07:35 -0400 (AST) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: Best Linux filesystem for Postgres data store ? Date: Wed, 01 Dec 2010 14:07:15 -0500 Organization: cbbrowne Computing Inc Lines: 29 Message-ID: <87lj498g7w.fsf@cbbrowne.afilias-int.info> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.2 (gnu/linux) Cancel-Lock: sha1:HCE0L8wyDGOrIviT/zoGoeeYFHw= To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/9 X-Sequence-Number: 36238 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.