Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B7AC364FC57 for ; Wed, 10 Dec 2008 10:18:01 -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 36910-04 for ; Wed, 10 Dec 2008 10:17:55 -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.171]) by mail.postgresql.org (Postfix) with ESMTP id E6DE26501C5 for ; Wed, 10 Dec 2008 10:17:54 -0400 (AST) Received: by wf-out-1314.google.com with SMTP id 25so173159wfc.28 for ; Wed, 10 Dec 2008 06:17:52 -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=d3wntKx1L7+sGG1k/YJDHHRdJVswdrETc21isE7ag8k=; b=CgaJ4XDfqBufuzK8EwR42DAj/fYDUboBpCtVMFDtvMC8hf6jS/x0h4/I1DyKxlpVzU 8VDBT3yUnBTfiqDCI0pJ3XEIaFzvE8E4acMBlAFLmIPKHXzWk2lPzSMia10xgrPvO9f+ HEaWIlSX5QKYHdRotjZUJSuhx5LSX7w6tCMng= 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=oQHo3B0GvO1O48bIl+AW+4b/MNszuUyebI0g034qqtoAD2INLtF0c7f+wke1HRd04l Oygq4uJB90Gc4HC26k7K9kZcIRyBNaglhZc1IzOju/5qcw+w2cxKEGQpF/Z4oVtOIsTz ytGENmU/CCops2B9ZIPqSE0IQlPs7A4vcEQjQ= Received: by 10.114.95.1 with SMTP id s1mr966813wab.160.1228918672184; Wed, 10 Dec 2008 06:17:52 -0800 (PST) Received: by 10.114.167.5 with HTTP; Wed, 10 Dec 2008 06:17:52 -0800 (PST) Message-ID: Date: Wed, 10 Dec 2008 07:17:52 -0700 From: "Scott Marlowe" To: "Mario Weilguni" Subject: Re: Experience with HP Smart Array P400 and SATA drives? Cc: "Alan Hodgson" , pgsql-performance@postgresql.org In-Reply-To: <493F739C.9080800@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> <49395B57.EE98.0025.0@wicourts.gov> <200812051530.01258@hal.medialogik.com> <493E61E1.1020303@sime.com> <493F739C.9080800@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/115 X-Sequence-Number: 32151 On Wed, Dec 10, 2008 at 12:45 AM, Mario Weilguni wrote: > > A customer of us uses the P400 on a different machine, 8 SAS drives (Raid 5 > as well), and the performance is very, very good. So we thought it's a good > choice. Maybe the SATA drives are the root of this problem? What tests have you or the customer done to confirm that performance is very very good? A lot of times the system is not as fast as the customer thinks, it's just faster than it was before and they're happy. Also, there could be problems in the driver or firmware on your P400 versus the customer one. I'd look for those differences as well. I doubt SATA versus SAS is the problem, but who knows...