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 522709DC835 for ; Wed, 15 Feb 2006 09:10:25 -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 20606-03 for ; Wed, 15 Feb 2006 09:10:28 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 139489DCA09 for ; Wed, 15 Feb 2006 09:10:23 -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 k1FDAKq8004937 for ; Wed, 15 Feb 2006 13:10:20 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k1FD2tQA003292 for pgsql-admin@postgresql.org; Wed, 15 Feb 2006 09:02:55 -0400 (AST) (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: Best filesystem Date: Wed, 15 Feb 2006 07:55:19 -0500 Organization: cbbrowne Computing Inc Lines: 29 Message-ID: <87wtfwixxk.fsf@wolfe.cbbrowne.com> References: <43F30708.9080001@andromeiberica.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:eBG0wl0PLmRZgHcF+judnaEwlM4= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-0.869 required=5 tests=[ALL_TRUSTED=-1.44, AWL=-0.242, INFO_TLD=0.813] X-Spam-Score: -0.869 X-Spam-Level: X-Archive-Number: 200602/188 X-Sequence-Number: 20609 Martha Stewart called it a Good Thing when arnaulist@andromeiberica.com (Arnau) wrote: > 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. Do you care more about performance? Or reliability? I think I'd rather see things 3% slower than they could perhaps be if that diminishes the risk of suddenly losing a filesystem... The last time I did a benchmark, I found JFS *slightly* faster than XFS, and XFS slightly faster than ext3. But then lost several JFS filesystems to weird interactions between JFS and disk controller. That was about 2 years ago; there have been new releases of both filesystems, SCSI device drivers, as well as major kernel revisions. It's not evident how much things have really changed. At any rate, I would NOT put filesystem performance at the top of the list; ability of vendors to provide support is something I would put much higher. That factor alone usually rules out both JFS and XFS... -- select 'cbbrowne' || '@' || 'gmail.com'; http://linuxfinances.info/info/lsf.html Rules of the Evil Overlord #43. "I will maintain a healthy amount of skepticism when I capture the beautiful rebel and she claims she is attracted to my power and good looks and will gladly betray her companions if I just let her in on my plans."