Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 405D76324D6 for ; Fri, 9 Jul 2010 06:08:42 -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 19113-03 for ; Fri, 9 Jul 2010 09:08:33 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.trinitydigital.com.au (mail.trinitydigital.com.au [122.102.101.7]) by mail.postgresql.org (Postfix) with ESMTP id 1EC026322A4 for ; Fri, 9 Jul 2010 06:08:33 -0300 (ADT) Received: from localhost (unknown [122.102.101.11]) by mail.trinitydigital.com.au (Postfix) with ESMTP id B5412828B5B; Fri, 9 Jul 2010 19:03:38 +1000 (EST) Received: from mail.trinitydigital.com.au ([122.102.101.7]) by localhost (spam-filter.trinitydigital.com.au [122.102.101.11]) (amavisd-new, port 10024) with LMTP id 19272-10; Fri, 9 Jul 2010 18:58:29 +1000 (EST) Received: from [172.17.73.19] (ppp59-167-179-245.static.internode.on.net [59.167.179.245]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.trinitydigital.com.au (Postfix) with ESMTPSA id 85A68828B2A; Fri, 9 Jul 2010 19:03:30 +1000 (EST) Message-ID: <4C36E6FC.6030902@pws.com.au> Date: Fri, 09 Jul 2010 19:08:12 +1000 From: Russell Smith User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.23) Gecko/20090817 Thunderbird/2.0.0.23 Mnenhy/0.7.5.0 MIME-Version: 1.0 To: Ryan Wexler CC: Kevin Grittner , Eliot Gable , pgsql-performance@postgresql.org, Andy Colson Subject: Re: performance on new linux box References: <4C3532CC.6070601@squeakycode.net> <4C3591F40200002500033219@gw.wicourts.gov> <4C35A23B0200002500033220@gw.wicourts.gov> In-Reply-To: Content-Type: multipart/alternative; boundary="------------060105090407090705060805" X-Virus-Scanned: Trinity Digital Spam Filter 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, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201007/145 X-Sequence-Number: 39534 This is a multi-part message in MIME format. --------------060105090407090705060805 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On 09/07/10 02:31, 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 > > The only other difference between the boxes is the postgresql > version. The new one has 8.4-2 from the yum install instructions on > the site: > http://yum.pgrpms.org/reporpms/repoview/pgdg-centos.html > > Any more thoughts? Really dumb idea, you don't happen to have the build of the RPM's that had debug enabled do you? That resulted in significant performance problem? Regards Russell --------------060105090407090705060805 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On 09/07/10 02:31, 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

The only other difference between the boxes is the postgresql version. The new one has 8.4-2 from the yum install instructions on the site:
http://yum.pgrpms.org/reporpms/repoview/pgdg-centos.html

Any more thoughts?

Really dumb idea, you don't happen to have the build of the RPM's that had debug enabled do you? That resulted in significant performance problem?

Regards

Russell
--------------060105090407090705060805--