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 2CF3E9DC87C for ; Mon, 19 Dec 2005 15:37:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32991-03 for ; Mon, 19 Dec 2005 15:37:31 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.Mi8.com (d01gw01.mi8.com [63.240.6.47]) by postgresql.org (Postfix) with ESMTP id 8204A9DC86C for ; Mon, 19 Dec 2005 15:37:29 -0400 (AST) Received: from 172.16.1.110 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Mon, 19 Dec 2005 14:37:17 -0500 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01SMTP01.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 19 Dec 2005 14:37:16 -0500 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 ; Mon, 19 Dec 2005 19:37:15 +0000 User-Agent: Microsoft-Entourage/11.2.1.051004 Date: Mon, 19 Dec 2005 11:37:15 -0800 Subject: Re: PostgreSQL and Ultrasparc T1 From: "Luke Lonergan" To: "Jignesh Shah" cc: "Juan Casero" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] PostgreSQL and Ultrasparc T1 Thread-Index: AcYE0p2CGNZIrp6bTj6milivLBHEqwAAP/G2 In-Reply-To: MIME-Version: 1.0 X-OriginalArrivalTime: 19 Dec 2005 19:37:16.0047 (UTC) FILETIME=[9DE7E9F0:01C604D3] X-WSS-ID: 6FB9D466330217046-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.253 required=5 tests=[AWL=0.000, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.253 X-Spam-Level: * X-Archive-Number: 200512/460 X-Sequence-Number: 16281 Jignesh, On 12/19/05 11:29 AM, "Jignesh Shah" wrote: > I have gone to the max with 4 fibers on Sun Fire T2000. But I am not sure > about the answers that you asked. Let me see if I can get answers for them. I > am going to try to max out the IO on these systems with 8 fibers as soon as I > get additional storage so stay tuned for that. Cool - how close did you get to 800MB/s? > By the way you don't have to wait for my tests. Just get a trial server and > try it on your own. If you don't like it return it. > > https://www.sun.com/emrkt/trycoolthreads/contactme.html Done - I'll certainly test Postgres / Bizgres on it - you know me ;-) > However if you do try it with PostgreSQL, do let me know also with your > experience. See above. The Niagara is UltraSparc III compatible - so the GCC compiler should emit good code for it, right? - Luke