Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 01AE264FD1C for ; Mon, 18 Aug 2008 12:33:50 -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 47741-07 for ; Mon, 18 Aug 2008 12:33:46 -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.191]) by postgresql.org (Postfix) with ESMTP id 4814264FD06 for ; Mon, 18 Aug 2008 12:33:46 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id c7so1118693nfi.23 for ; Mon, 18 Aug 2008 08:33:44 -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=Oc/VoQrQpGb6yuIkKzdGkPmuC7Nt/6d+sfR9D3wvoF4=; b=f+yD7Ut2LLWWTTzT7YkNMm259Nj8dP7iXEObpQ2rv4TLphE8tBfhiEa86N00bHhzuJ s0xuJoaOHRe31w1YpCuHvRRsEB60H3iuKUe7J9Zc+h5JrzM1R7Jxm4W5y0DiMoNFmT/u bQGdx5la4jY+wKnR9uODy5e0WwcCEAnn0jlhg= 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=RLDX51Ge2QNp+utNnhL29tFIx7jwlPEarnxQKINcZRFvj3WTJrFC41XQ6yIUdw8/Zu qaNYH8vWNstD4Ibau9fbpy209pMgqyj8OrOmb0AEN5rgUvS8x2eX/prlOZEhv5YL+KF+ 7BrlCuhmjrheiyI5ydd0tNl2AwjoGSMyZ1MlQ= Received: by 10.210.143.11 with SMTP id q11mr8174379ebd.61.1219073624691; Mon, 18 Aug 2008 08:33:44 -0700 (PDT) Received: by 10.210.72.10 with HTTP; Mon, 18 Aug 2008 08:33:44 -0700 (PDT) Message-ID: <70c01d1d0808180833m4a10b39ak9e9c367554a44a67@mail.gmail.com> Date: Mon, 18 Aug 2008 08:33:44 -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/196 X-Sequence-Number: 31077 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 have one set of results with ext3 data=writeback and it appears that some of the write tests have less throughput than data=ordered. For anyone who wants to look at the results details: http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide it's under the "Aggregate Bandwidth (MB/s) - RAID 5 (256KB stripe) - No partition table" table. Regards, Mark