Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 0276E63595B for ; Wed, 25 Mar 2009 00:30:19 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 10551-08 for ; Wed, 25 Mar 2009 00:30:12 -0300 (ADT) Received: from mx2.hub.org (mx2.hub.org [200.46.204.254]) by mail.postgresql.org (Postfix) with ESMTP id F1C29635488 for ; Wed, 25 Mar 2009 00:29:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from westnet.com (westnet.com [216.187.52.2]) by mx2.hub.org (Postfix) with ESMTP id 92A511E81D1B for ; Wed, 25 Mar 2009 00:29:56 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id n2P3THQw025810; Tue, 24 Mar 2009 23:29:17 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id n2P3THu6025806; Tue, 24 Mar 2009 23:29:17 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Tue, 24 Mar 2009 23:29:17 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: David Rees cc: Scott Carey , Mark Kirkwood , "pgsql-performance@postgresql.org" Subject: Re: Raid 10 chunksize In-Reply-To: <72dbd3150903241904t39a2304cv806b228cbaef3036@mail.gmail.com> Message-ID: References: <49C98433.5080709@paradise.net.nz> <72dbd3150903241904t39a2304cv806b228cbaef3036@mail.gmail.com> User-Agent: Alpine 2.01 (GSO 1184 2008-12-16) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; format=flowed; charset=US-ASCII X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=AWL=0.000 X-Spam-Level: X-Archive-Number: 200903/360 X-Sequence-Number: 33282 On Tue, 24 Mar 2009, David Rees wrote: > I would tend to recommend ext3 in data=writeback and make sure that > it's mounted with noatime over using ext2 - for the sole reason that > if the system shuts down unexpectedly, you don't have to worry about a > long fsck when bringing it back up. Well, Mark's system is already using noatime, and if you believe http://www.commandprompt.com/blogs/joshua_drake/2008/04/is_that_performance_i_smell_ext2_vs_ext3_on_50_spindles_testing_for_postgresql/ there's little difference between writeback and ordered on the WAL disk. Might squeeze out some improvements with ext2 though, and if there's nothing besides the WAL on there fsck isn't ever going to take very long anyway--not much of a directory tree to traverse there. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD