Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id C370AB5DBD6 for ; Tue, 9 Aug 2011 01:14:07 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 54971-03 for ; Tue, 9 Aug 2011 04:14:01 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yx0-f174.google.com (mail-yx0-f174.google.com [209.85.213.174]) by mail.postgresql.org (Postfix) with ESMTP id 9A144B5DBCC for ; Tue, 9 Aug 2011 01:14:01 -0300 (ADT) Received: by yxj19 with SMTP id 19so2921464yxj.19 for ; Mon, 08 Aug 2011 21:14:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=from:to:cc:references:in-reply-to:subject:date:message-id :mime-version:content-type:content-transfer-encoding:x-mailer :thread-index:content-language; bh=zBsdDMe5W3GIQcOYZ50ctQ9VNb0L9SyeRpeIbltaOcs=; b=fslgMLZpqtNbE/nvgQTRIQ6j+zxyVgYl/tmZnMo9u4kyISo1ZZc3yRxF1X65HgGqIT 5COYC2GnbyqopCieusi8KZuFzDShdvr5aC3Cz+DSevI6HBUZu4ypsSkZaobnMSo3F1Fa MRg4sJsbWNPJHo9VX92t9mo2b0b3AQfdi1LtU= Received: by 10.43.43.137 with SMTP id uc9mr6835702icb.367.1312863240030; Mon, 08 Aug 2011 21:14:00 -0700 (PDT) Received: from Duality (67-40-130-232.hlrn.qwest.net [67.40.130.232]) by mx.google.com with ESMTPS id a9sm9729654icy.6.2011.08.08.21.13.58 (version=SSLv3 cipher=OTHER); Mon, 08 Aug 2011 21:13:59 -0700 (PDT) From: "mark" To: "'Greg Smith'" Cc: References: <012901cc5638$f44df9d0$dce9ed70$@com> <4E40AC9B.9090400@2ndquadrant.com> In-Reply-To: <4E40AC9B.9090400@2ndquadrant.com> Subject: Re: benchmark woes and XFS options Date: Mon, 8 Aug 2011 22:13:58 -0600 Message-ID: <013001cc564a$c44d7140$4ce853c0$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcxWRlkhJOpwwJt0TieppTBAYhKeRwAAnnZw Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001 X-Spam-Level: X-Archive-Number: 201108/111 X-Sequence-Number: 44558 > -----Original Message----- > From: Greg Smith [mailto:greg@2ndquadrant.com] > Sent: Monday, August 08, 2011 9:42 PM > To: mark > Cc: pgsql-performance@postgresql.org > Subject: Re: [PERFORM] benchmark woes and XFS options > > I think your notion that you have an HP CCISS driver in this older > kernel that just doesn't drive your card very fast is worth exploring. > What I sometimes do in the situation you're in is boot a Linux > distribution that comes with a decent live CD, such as Debian or > Ubuntu. Just mount the suspect drive, punch up read-ahead, and re-test > performance. That should work well enough to do a simple dd test, and > probably well enough to compile and run bonnie++ too. If that gives > good performance numbers, it should narrow the list of possible causes > considerably. You really need to separate out "bad driver" from the > other possibilities here given what you've described, and that's a low > impact way to do it. > > -- > Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD > PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us Thanks Greg. I will try and give HPSA a whirl and report back. Both with single disk and the whole raid set. I am out of the office this week so I might have some delay before I can do some more detective work. I don't think I have any gear that won't require either the CCISS or HPSA driver and in SFF drives. But will try and look around. -Mark