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 863E611F67D7 for ; Fri, 7 Apr 2006 19:07:04 -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 69122-09 for ; Fri, 7 Apr 2006 19:06:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mi8.com (d01gw04.mi8.com [63.240.6.44]) by postgresql.org (Postfix) with ESMTP id 78DCE11F6600 for ; Fri, 7 Apr 2006 19:07:01 -0300 (ADT) Received: from 172.16.1.112 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D4)); Fri, 07 Apr 2006 18:06:50 -0400 X-Server-Uuid: C8FB4D43-1108-484A-A898-3CBCC7906230 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01SMTP02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 7 Apr 2006 18:06:50 -0400 Received: from 67.103.45.218 ([67.103.45.218]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.106]) with Microsoft Exchange Server HTTP-DAV ; Fri, 7 Apr 2006 22:06:49 +0000 User-Agent: Microsoft-Entourage/11.2.3.060209 Date: Fri, 07 Apr 2006 15:06:48 -0700 Subject: Re: pg 8.1.3, AIX, huge box, painfully slow. From: "Luke Lonergan" To: "Tom Lane" cc: "Gavin Hamill" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] pg 8.1.3, AIX, huge box, painfully slow. Thread-Index: AcZajwsQfQ1WAzPERHapihmxjFBp9gAAIWT7 In-Reply-To: <17108.1144447375@sss.pgh.pa.us> MIME-Version: 1.0 X-OriginalArrivalTime: 07 Apr 2006 22:06:50.0321 (UTC) FILETIME=[92043410:01C65A8F] X-WSS-ID: 68283DF020C40930198-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.333 required=5 tests=[AWL=0.080, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.333 X-Spam-Level: * X-Archive-Number: 200604/162 X-Sequence-Number: 18246 Tom, On 4/7/06 3:02 PM, "Tom Lane" wrote: > On the other hand, we already know that Xeons suck about as badly as > can be on that same measure; could the pSeries really be worse? I wouldn't be too surprised, but it sounds like it needs a test. Do we have a test for this? Is there a contention-prone query stream that we can think up? - Luke