X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8D3C0D1B554 for ; Thu, 9 Oct 2003 15:29:48 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 52041-09 for ; Thu, 9 Oct 2003 12:28:58 -0300 (ADT) Received: from mta3.adelphia.net (mta3.adelphia.net [68.168.78.181]) by svr1.postgresql.org (Postfix) with ESMTP id 75E8DD1CA97 for ; Thu, 9 Oct 2003 12:19:46 -0300 (ADT) Received: from potentialtech.com ([68.68.113.33]) by mta3.adelphia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20031009151943.TJCN1358.mta3.adelphia.net@potentialtech.com>; Thu, 9 Oct 2003 11:19:43 -0400 Message-ID: <3F857C8E.1030804@potentialtech.com> Date: Thu, 09 Oct 2003 11:19:42 -0400 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20031005 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Kaarel Cc: Performance Subject: Re: Linux filesystem shootout References: <3F8542B5.6070209@persistent.co.in> <20031009121124.GA7038@elbereth.noviforum.si> <3F85763C.3080307@future.ee> In-Reply-To: <3F85763C.3080307@future.ee> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/275 X-Sequence-Number: 4023 Kaarel wrote: > >>>http://www.ussg.iu.edu/hypermail/linux/kernel/0310.1/0208.html >>> >>>Shridhar >>> > I feel incompetent when it comes to file systems. Yet everybody would > like to have the best file system if given the choice...so do I :) Here > I am looking at those tables seeing JFS having more green cells than > others. The more green the better right? So based on these tests JFS > ought to be the one? Those tests seem to align with the ones I did recently: http://www.potentialtech.com/wmoran/postgresql.php#results There were less filesystems involved, and the data is less comprehensive, but probably a little easier to understand (i.e. -> fastest filesystem at the top of the graph, slowest at the bottom). I've been telling people that JFS is fastest. This is definately oversimplified, since the "shoot out" shows that it's not _always_ fastest, but for people who just want to make a good initial choice, and won't do their own testing to find out what's fastest in their configuration (for whatever reason), I think JFS is the safest bet. Since it's a journalling filesystem as well, it should have good recoverability in the even of catastrophy, but I haven't tested that. -- Bill Moran Potential Technologies http://www.potentialtech.com