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 ECA91D1B95E for ; Thu, 9 Oct 2003 15:11:12 +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 46319-06 for ; Thu, 9 Oct 2003 12:10:27 -0300 (ADT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 98BAED1B981 for ; Thu, 9 Oct 2003 12:07:05 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h99FC44B020489 for ; Thu, 9 Oct 2003 20:42:04 +0530 Received: from persistent.co.in (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id h99FBxwc020446; Thu, 9 Oct 2003 20:41:59 +0530 Message-ID: <3F85798B.1010106@persistent.co.in> Date: Thu, 09 Oct 2003 20:36:51 +0530 From: Shridhar Daithankar Organization: Persistent Systems Pvt. Ltd. User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5b) Gecko/20030917 Thunderbird/0.3a X-Accept-Language: en-us, en MIME-Version: 1.0 To: Kaarel Cc: Grega Bremec , 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/274 X-Sequence-Number: 4022 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? Yes and no. Yes for the results. No for the tests that weren't run. Database load is quite different. Its mixture of read and write load with a dynamics varying from one extreme to other, between these two. All it says that if you want to choose a good file system for postgresql, look at JFS first..:-) Besides all the tests were done on files file bigger than 1GB. If single file size is restricted to 1GB, it might produce a different result set. And postgresql does not exceed 1GB limit per file. So still, quite a few unknowns there.. Best thing could be repeat those benchmarks on $PGDATA with your live data inside it. It could mimmic the load pretty well.. Shridhar