Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 1F279B5DBCC for ; Tue, 9 Aug 2011 00:42:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 62755-07 for ; Tue, 9 Aug 2011 03:42:24 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.8]) by mail.postgresql.org (Postfix) with ESMTP id 9E6F4B5DBBF for ; Tue, 9 Aug 2011 00:42:24 -0300 (ADT) Received: from [192.168.1.3] (mail.highperformancepostgresql.com [71.179.240.8]) by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis) id 0LiGd5-1RdhXi0xmd-00nRZR; Tue, 09 Aug 2011 05:42:21 +0200 Message-ID: <4E40AC9B.9090400@2ndquadrant.com> Date: Mon, 08 Aug 2011 23:42:19 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: mark CC: pgsql-performance@postgresql.org Subject: Re: benchmark woes and XFS options References: <012901cc5638$f44df9d0$dce9ed70$@com> In-Reply-To: <012901cc5638$f44df9d0$dce9ed70$@com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:M1Bn4a6phZKgVSN8TCuH3QOM/met6Nw/363t4bclSTb p6z+FUXr1ZUqDq4RdPYabazC4JaWfEC3mY+lIZTTiuMUAGCns5 ZZABdwEuawGTnBZn58KZ7fadJeEDwGbEsYwgL8mNDL/vKXvJfO uNHyYCSGqpOHaI2dlS/36ft/d4hv6kgnDKdjqRj5tF4iFgS6aF 7ywnHfNXpHhcalEBc2d4NYLPzWV3FNYR6i6kgRZxg0= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201108/107 X-Sequence-Number: 44554 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