Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 2F7E5632EFC for ; Thu, 8 Jul 2010 14:05:16 -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 20008-04 for ; Thu, 8 Jul 2010 17:05:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailhub1.renesys.com (mailhub1.ep.renesys.com [195.160.236.248]) by mail.postgresql.org (Postfix) with ESMTP id AD4FF6330B2 for ; Thu, 8 Jul 2010 14:05:07 -0300 (ADT) Received: from ops05.psm1.renesys.com (ops05.psm1.renesys.com [10.200.1.25]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mailhub1.renesys.com (Postfix) with ESMTP id 09EE9671A4; Thu, 8 Jul 2010 17:05:06 +0000 (UTC) Received: (from rouilj@localhost) by ops05.psm1.renesys.com (8.13.8/8.13.8/Submit) id o68H55xG005849; Thu, 8 Jul 2010 17:05:05 GMT Date: Thu, 8 Jul 2010 17:05:05 +0000 From: John Rouillard To: Ryan Wexler Cc: pgsql-performance@postgresql.org Subject: Re: performance on new linux boxeradmin(11983)i: STATEMENT: update license set expires= '2010-06-15' where lic Message-ID: <20100708170505.GG3171@renesys.com> References: <4C3532CC.6070601@squeakycode.net> <4C3591F40200002500033219@gw.wicourts.gov> <4C35A23B0200002500033220@gw.wicourts.gov> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201007/109 X-Sequence-Number: 39498 On Thu, Jul 08, 2010 at 09:31:32AM -0700, Ryan Wexler wrote: > Thanks a lot for all the comments. The fact that both my windows box and > the old linux box both show a massive performance improvement over the new > linux box seems to point to hardware to me. I am not sure how to test the > fsync issue, but i don't see how that could be it. > > The raid card the server has in it is: > 3Ware 4 Port 9650SE-4LPML RAID Card > > Looking it up, it seems to indicate that it has BBU By "looking it up", I assume you mean running tw_cli and looking at the output to make sure the bbu is enabled and the cache is turned on for the raid array u0 or u1 ...? -- -- rouilj John Rouillard System Administrator Renesys Corporation 603-244-9084 (cell) 603-643-9300 x 111