Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id BE13A64FC57 for ; Wed, 10 Dec 2008 12:17:37 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 58798-10 for ; Wed, 10 Dec 2008 12:17:32 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.168]) by mail.postgresql.org (Postfix) with ESMTP id 775AC64FC4F for ; Wed, 10 Dec 2008 12:17:32 -0400 (AST) Received: by wf-out-1314.google.com with SMTP id 25so211054wfc.28 for ; Wed, 10 Dec 2008 08:17:30 -0800 (PST) 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=QWRUQYTxAAAAJmDuo2jtEbqczBB7DJEcyQBO4ZerQLQ=; b=FEfBZjyg22l9phPb9JiTZKkNPSRqO+pHQa+0iKhCp3nkBR6pzjTMXMtpcSprdSr89I TH0bhVeAPE9FZn3pwvVpsBLtWWHZPFrQmvul7Nq3jwI0UrGzZrrMElEKUjPcrXbIpMQm /mctta3oGuvg8aiq7Q3oD9ohbYQ3ovZUnH2Vo= 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=IoZu+7Nh8kkQunp1LKO30qpnEOzGp0sdP34M4ik+5lRkAgJpBxqkXRc9Bg3jUia0JT udyEvsh9H1+QlW3SyAvVUSHkKfUAxGMJVWGPE51EFOI3bWxMUwGD82xbA/VNDfQiCBSM 74kfkZCMLeIJmxDKEH6h2z1Pc4Tvwq3ttxj4M= Received: by 10.114.122.5 with SMTP id u5mr1074045wac.88.1228925849055; Wed, 10 Dec 2008 08:17:29 -0800 (PST) Received: by 10.114.167.5 with HTTP; Wed, 10 Dec 2008 08:17:28 -0800 (PST) Message-ID: Date: Wed, 10 Dec 2008 09:17:28 -0700 From: "Scott Marlowe" To: "Mario Weilguni" Subject: Re: Experience with HP Smart Array P400 and SATA drives? Cc: "Aidan Van Dyk" , "Joshua D. Drake" , pgsql-performance@postgresql.org In-Reply-To: <493FE8B2.9040809@sime.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4934FE60.30702@sime.com> <493E6023.3030800@sime.com> <1228838308.13962.0.camel@jd-laptop.pragmaticzealot.org> <20081209161750.GO26596@yugib.highrise.ca> <493FB619.5060205@sime.com> <20081210155208.GR26596@yugib.highrise.ca> <493FE8B2.9040809@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: 200812/120 X-Sequence-Number: 32156 On Wed, Dec 10, 2008 at 9:05 AM, Mario Weilguni wrote: > In fact, for this system we're currently going to RAID10, I'm convinced now. > With other systems we have, RAID5 is a safe option for one reason, the > machines are clusters, so we have (sort of) RAID50 here: > Machine A/RAID5 <-- DRBD --> Machine B/RAID5 > > Seems reliable enough for me. But in this case, the machine will be > standalone, and so RAID5 might really not be the best choice. > > However, I'm pretty sure we'll have the same problems with RAID10, the > problem seems to have to do with P400 and/or SATA drives. Yeah, I'm thinking there's something off in your system and until you resolve it you're going to have issues. I'd check the following: firmware on RAID controller how it runs with a couple of SAS drives in RAID-1 or RAID-0 (just for testing) OS version / kernel version / driver version. especially compared to your customer's machine. See how much of his environment you can clone until performance goes up where it should be. Then change one thing at a time until you break it again. I'm sure everyone here would like to know what makes a P400 fast or slow. Or, if you don't have time to mess with it, just order an escalade or areca card and be done with it. :)