X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D13429DC85E for ; Mon, 20 Feb 2006 12:12:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 24452-06 for ; Mon, 20 Feb 2006 12:12:09 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id B15CD9DC85C for ; Mon, 20 Feb 2006 12:12:09 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k1KGC762098151 for ; Mon, 20 Feb 2006 16:12:09 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k1KG43u7096914 for pgsql-admin@postgresql.org; Mon, 20 Feb 2006 12:04:03 -0400 (AST) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: Best filesystem Date: Mon, 20 Feb 2006 10:41:05 -0500 Organization: cbbrowne Computing Inc Lines: 18 Message-ID: <60slqe9gxa.fsf@dba2.int.libertyrms.com> References: <43F305A0.5010403@androme.es> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.18 (linux) Cancel-Lock: sha1:gtWKurrwKQfMKV9JEPS5ITVH38o= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-1.258 required=5 tests=[ALL_TRUSTED=-1.44, AWL=0.182] X-Spam-Score: -1.258 X-Spam-Level: X-Archive-Number: 200602/236 X-Sequence-Number: 20657 arebassa@androme.es (Arnau Rebassa Villalonga) writes: > Which is the best filesystem in linux for postgresql? nowadays I'm > using ext3, I don't know if other filesystems like XFS, > reiser... would be better from the performance point of view. As far as I can tell, ext3 is the best *supported* filesystem for Linux, and support trumps performance 99 days out of 100. The trouble with all the other filesystems is that vendors are likely to throw up their hands and ignore you if you report problems with them, and "not getting your database eaten by a filesystem error" is *WAY* more important than eking out some fraction of a percent improvement in write performance. -- output = ("cbbrowne" "@" "cbbrowne.com") http://cbbrowne.com/info/linuxxian.html "Heavy music didn't start in Seattle. It started in Katy, Texas with King's X" -- Jeff Ament/Pearl Jam