Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D61C46503F8 for ; Fri, 15 Aug 2008 16:32:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 73902-06-2 for ; Fri, 15 Aug 2008 16:31:56 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.188]) by postgresql.org (Postfix) with ESMTP id 5CFA2650292 for ; Fri, 15 Aug 2008 16:31:05 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id c7so701352nfi.23 for ; Fri, 15 Aug 2008 12:31:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=Kyea/MMysY5wiqf/YtTvixkmnLFk+DMwiuFhVY7y8pM=; b=H9CPvLPsxWzqLy0UdKmXOcBNim46cuDRk45Kmw85f8usRXtjx6Q3hnZrdfVe60+Ei0 zY9BLW7gEE2d24JvodqFEyf/BtgDJiAbPBSfzwtnqAKeTR67T2/tJ/KvyttERMsdDONd RtCGUB4/832DJdtkLmGpE5B5mrCfycdr0OUUw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=AkGkEmRB5zt2cHNjxHgyQtz55QDVS1WcEESs0WyaM38cDpLo5poNbYT4eS34Sgu5fG VnziWGxhHg8jyb03JryvZDueFIt35VkC3ItGTgHfAoaCohqQHlWK/OYxzNrHXOSOspGr 5XdufW/1YSP1ZtFtQwH76m6X44UmW4i6x6Qf0= Received: by 10.210.139.15 with SMTP id m15mr3601154ebd.51.1218828664229; Fri, 15 Aug 2008 12:31:04 -0700 (PDT) Received: by 10.210.72.10 with HTTP; Fri, 15 Aug 2008 12:31:04 -0700 (PDT) Message-ID: <70c01d1d0808151231m407a52cbo8069200fe8078aa2@mail.gmail.com> Date: Fri, 15 Aug 2008 12:31:04 -0700 From: "Mark Wong" To: "Bruce Momjian" Subject: Re: file system and raid performance Cc: david@lang.hm, pgsql-performance@postgresql.org, "Gabrielle Roth" In-Reply-To: <200808151922.m7FJMxJ21964@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <70c01d1d0808050757j34886207xbcbb76d475319b65@mail.gmail.com> <200808151922.m7FJMxJ21964@momjian.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/173 X-Sequence-Number: 31054 On Fri, Aug 15, 2008 at 12:22 PM, Bruce Momjian wrote: > Mark Wong wrote: >> On Mon, Aug 4, 2008 at 10:04 PM, wrote: >> > On Mon, 4 Aug 2008, Mark Wong wrote: >> > >> >> Hi all, >> >> >> >> We've thrown together some results from simple i/o tests on Linux >> >> comparing various file systems, hardware and software raid with a >> >> little bit of volume management: >> >> >> >> http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide > > Mark, very useful analysis. I am curious why you didn't test > 'data=writeback' on ext3; 'data=writeback' is the recommended mount > method for that file system, though I see that is not mentioned in our > official documentation. I think the short answer is that I neglected to. :) I didn't realized 'data=writeback' is the recommended journal mode. We'll get a result or two and see how it looks. Mark