X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 232A111F66CE for ; Fri, 7 Apr 2006 16:59:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21878-09 for ; Fri, 7 Apr 2006 16:59:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from fon.nation-net.com (213-2-2-26.uk.vianw.net [213.2.2.26]) by postgresql.org (Postfix) with ESMTP id 9D4E811F61E0 for ; Fri, 7 Apr 2006 16:59:23 -0300 (ADT) Received: from fon.nation-net.com (localhost [127.0.0.1]) by fon.nation-net.com (Postfix) with ESMTP id 405511376AF for ; Fri, 7 Apr 2006 20:59:23 +0100 (BST) Received: from eddie.acentral.co.uk (80-192-144-33.cable.ubr04.pres.blueyonder.co.uk [80.192.144.33]) by fon.nation-net.com (Postfix) with ESMTP id 05CEF13768E for ; Fri, 7 Apr 2006 20:59:23 +0100 (BST) Received: from eddie.acentral.co.uk (eddie.acentral.co.uk [127.0.0.1]) by eddie.acentral.co.uk (Postfix) with ESMTP id 3268B75FE5 for ; Fri, 7 Apr 2006 20:59:25 +0100 (BST) Received: from localhost.localdomain (unknown [10.0.0.29]) by eddie.acentral.co.uk (Postfix) with SMTP id 22AC375F8D for ; Fri, 7 Apr 2006 20:59:25 +0100 (BST) Date: Fri, 7 Apr 2006 20:59:19 +0100 From: Gavin Hamill To: pgsql-performance@postgresql.org Subject: Re: pg 8.1.3, AIX, huge box, painfully slow. Message-Id: <20060407205919.a091da26.gdh@laterooms.com> In-Reply-To: <1144436060.32269.13.camel@state.g2switchworks.com> References: <20060407185823.abe93017.gdh@laterooms.com> <1144436060.32269.13.camel@state.g2switchworks.com> X-Mailer: Sylpheed version 2.1.1 (GTK+ 2.8.6; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV using ClamSMTP X-AV-Checked: ClamAV using ClamSMTP X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.096 required=5 tests=[AWL=0.096] X-Spam-Score: 0.096 X-Spam-Level: X-Archive-Number: 200604/150 X-Sequence-Number: 18234 On Fri, 07 Apr 2006 13:54:21 -0500 Scott Marlowe wrote: > Are the same queries getting the same basic execution plan on both > boxes? Turn on logging for slow queries, and explain analyze them on > both machines to see if they are. See reply to Tom Lane :) > I'd put the old 4 way Xeon back in production and do some serious > testing of this pSeries machine. IBM should be willing to help you, I > hope. They probably would if this had been bought new - as it is, we have rented the machine for a month from a 2nd-user dealer to see if it's capable of taking the load. I'm now glad we did this. > My guess is that this is an OS issue. Maybe there are AIX tweaks that > will get it up to the same or higher level of performance as your four > way xeon. Maybe there aren't. The pSeries isn't much older than our Xeon machine, and I expected the performance level to be exemplary out of the box.. we've enabled the 64-bit kernel+userspace, and compiled pg for 64-bitness with the gcc flags as reccommended by Senica Cunningham on this very list.. > Myself, I'd throw a spare drive in for the OS, put some flavor of > linux on it Terrifying given I know nothing about the pSeries boot system, but at this stage I'm game for nearly anything. > http://www.asaservers.com/system_dept.asp?dept_id=SD-002 Multi-Opteron was the other thing we considered but decided to give 'Big Iron' UNIX a whirl... Cheers, Gavin.