X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 21C70D1D2DD for ; Tue, 30 Mar 2004 17:29:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 83375-04 for ; Tue, 30 Mar 2004 13:29:06 -0400 (AST) Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by svr1.postgresql.org (Postfix) with ESMTP id CD02DD1B441 for ; Tue, 30 Mar 2004 13:29:05 -0400 (AST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-35.mail.demon.net with esmtp (Exim 3.35 #1) id 1B8N2u-000KrC-0Z; Tue, 30 Mar 2004 18:29:04 +0100 Received: by mainbox.archonet.com (Postfix, from userid 529) id 36AC416E24; Tue, 30 Mar 2004 18:29:02 +0100 (BST) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 0B91016711; Tue, 30 Mar 2004 18:29:00 +0100 (BST) From: Richard Huxton To: Josh Berkus , "Jaime Casanova" , pgsql-performance@postgresql.org Subject: Re: [ADMIN] Raw vs Filesystem Date: Tue, 30 Mar 2004 18:28:59 +0100 User-Agent: KMail/1.5 References: <200403300922.42448.dev@archonet.com> <200403300843.01437.josh@agliodbs.com> In-Reply-To: <200403300843.01437.josh@agliodbs.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200403301828.59498.dev@archonet.com> X-Bogosity: No, tests=bogofilter, spamicity=0.000000, version=0.15.3 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/423 X-Sequence-Number: 6279 On Tuesday 30 March 2004 17:43, Josh Berkus wrote: > Jaime, Richard, > > > That's going to depend on a number of things: > > There are some test results people have provided in the archives, but > > whether they apply to your setup is open to argument. > > True. On Linux overall, XFS, JFS, and Reiser have all looked good at one > time or another. Ext3 has never been a leader for performance, though, so > that's an easy elimination. True, but on the sorts of commodity boxes I use, it doesn't make sense for me to waste time setting up non-standard filesystems - it's cheaper to spend a little more for better performance. I think SuSE offer Reiser though, so maybe we'll see a wider selection available by default. -- Richard Huxton Archonet Ltd