Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 20D3A64FD35 for ; Thu, 7 Aug 2008 16:36:49 -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 69272-02 for ; Thu, 7 Aug 2008 16:36:43 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ik-out-1112.google.com (ik-out-1112.google.com [66.249.90.181]) by postgresql.org (Postfix) with ESMTP id D981764FCF6 for ; Thu, 7 Aug 2008 16:36:45 -0300 (ADT) Received: by ik-out-1112.google.com with SMTP id c30so817039ika.3 for ; Thu, 07 Aug 2008 12:36: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=syJndw3gbKk6uVkfKlAHuL8bwDKUYBichWU5ulqndMc=; b=F6u5hc2p66ng3eAukN6nG2Xc65vG8TbiZzf90wajmRvkTAKIKUEWBAPKQyfv5hLZAv kHFZmI1uRE9y1/YSrE9lO+IG/kIHth7N4ceb41Gj875juA1NtGocjHYXIYL9FVmbuqmU h/t6SWa6PNZevBMq26714Hdu17XuTwrj5YBPA= 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=PfpmRQAPI0/InQUopFFtvvAEY3cfq4tDJBw5S62WNSKulvUXBY++WF8kToAMVvlLck 0XDaPabhr4K5fMpZrC0p5a+9e48HAI2B8sEJXO40LVc5Tx3DOu26K6wAy/L4wWknS3bY HiMj0k9ErToTXWYrxsQP5KzNQ+0IcN6ilIbxs= Received: by 10.210.26.10 with SMTP id 10mr4462228ebz.15.1218137803930; Thu, 07 Aug 2008 12:36:43 -0700 (PDT) Received: by 10.210.72.10 with HTTP; Thu, 7 Aug 2008 12:36:43 -0700 (PDT) Message-ID: <70c01d1d0808071236u36fe5002w833582b036d952e8@mail.gmail.com> Date: Thu, 7 Aug 2008 12:36:43 -0700 From: "Mark Wong" To: "Mario Weilguni" Subject: Re: file system and raid performance Cc: "Mark Kirkwood" , greg@tcscs.com, david@lang.hm, pgsql-performance@postgresql.org, "Gabrielle Roth" In-Reply-To: <489ACC90.9030401@sime.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <70c01d1d0808042154u7b78d988vac1e461a93b0ba10@mail.gmail.com> <70c01d1d0808050800j7196922bt2c4b43ba09a19099@mail.gmail.com> <4898E80A.3020809@paradise.net.nz> <489A3B75.6060004@paradise.net.nz> <489AC2F0.9050907@paradise.net.nz> <489ACC90.9030401@sime.com> 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/50 X-Sequence-Number: 30931 On Thu, Aug 7, 2008 at 3:21 AM, Mario Weilguni wrote: > Mark Kirkwood schrieb: >> >> Mark Kirkwood wrote: >>> >>> You are right, it does (I may be recalling performance from my other >>> machine that has a 3Ware card - this was a couple of years ago...) Anyway, >>> I'm thinking for the Hardware raid tests they may need to be specified. >>> >>> >> >> FWIW - of course this somewhat academic given that the single disk xfs >> test failed! I'm puzzled - having a Gentoo system of similar configuration >> (2.6.25-gentoo-r6) and running the fio tests a little modified for my config >> (2 cpu PIII 2G RAM with 4x ATA disks RAID0 and all xfs filesystems - I >> changed sizes of files to 4G and no. processes to 4) all tests that failed >> on Marks HP work on my Supermicro P2TDER + Promise TX4000. In fact the >> performance is pretty reasonable on the old girl as well (seq read is >> 142Mb/s and the random read/write is 12.7/12.0 Mb/s). >> >> I certainly would like to see some more info on why the xfs tests were >> failing - as on most systems I've encountered xfs is a great performer. >> >> regards >> >> Mark >> > I can second this, we use XFS on nearly all our database servers, and never > encountered the problems mentioned. I have heard of one or two situations where the combination of the disk controller caused bizarre behaviors with different journaling file systems. They seem so few and far between though. I personally wasn't looking forwarding to chasing Linux file system problems, but I can set up an account and remote management access if anyone else would like to volunteer. Regards, Mark