X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 112FA9FB2D2 for ; Sat, 29 Jul 2006 15:53:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 86905-09 for ; Sat, 29 Jul 2006 15:53:10 -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 065879FB2D0 for ; Sat, 29 Jul 2006 15:53:09 -0300 (ADT) Received: from 172.16.1.110 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D4)); Sat, 29 Jul 2006 14:52:59 -0400 X-Server-Uuid: C8FB4D43-1108-484A-A898-3CBCC7906230 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01SMTP01.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Sat, 29 Jul 2006 14:52:59 -0400 Received: from 69.181.100.71 ([69.181.100.71]) 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 ; Sat, 29 Jul 2006 18:52:59 +0000 User-Agent: Microsoft-Entourage/11.2.5.060620 Date: Sat, 29 Jul 2006 11:52:56 -0700 Subject: Re: PostgreSQL scalability on Sun UltraSparc T1 From: "Luke Lonergan" To: "Jochem van Dieten" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] PostgreSQL scalability on Sun UltraSparc T1 Thread-Index: AcazQDQZcvFalB8zEdu8sgAWy4o9DA== In-Reply-To: <44CB7896.8030501@oli.tudelft.nl> MIME-Version: 1.0 X-OriginalArrivalTime: 29 Jul 2006 18:52:59.0726 (UTC) FILETIME=[3651FEE0:01C6B340] X-WSS-ID: 68D571012W82067301-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.635 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, RCVD_NUMERIC_HELO X-Spam-Level: * X-Archive-Number: 200607/286 X-Sequence-Number: 20146 Jochem, On 7/29/06 8:02 AM, "Jochem van Dieten" wrote: > Tweakers.net has done a database performance test between a Sun T2000 (8 > core T1) and a Sun X4200 (2 dual core Opteron 280). The database > benchmark is developed inhouse and represents the average query pattern > from their website. It is MySQL centric because Tweakers.net runs on > MySQL, but Arjen van der Meijden has ported it to PostgreSQL and has > done basic optimizations like adding indexes. Excellent article/job on performance profiling - thanks! Back in March, Anandtech also did a Niagara article profiling web + database performance: http://www.anandtech.com/IT/showdoc.aspx?i=2727&p=7 and the results for the T2000/Niagara were also lesser to the multi-core Opteron. Now maybe this article will help Sun to improve the processor's performance. - Luke