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 6610F9DC852 for ; Mon, 19 Dec 2005 03:21:21 -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 71998-08 for ; Mon, 19 Dec 2005 03:21:21 -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 DDEC79DC878 for ; Mon, 19 Dec 2005 03:21:18 -0400 (AST) Received: from 172.16.1.24 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Mon, 19 Dec 2005 02:21:08 -0500 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by d01smtp03.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 19 Dec 2005 02:21:07 -0500 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.105]) with Microsoft Exchange Server HTTP-DAV ; Mon, 19 Dec 2005 07:21:07 +0000 User-Agent: Microsoft-Entourage/11.2.1.051004 Date: Sun, 18 Dec 2005 23:21:07 -0800 Subject: Re: PostgreSQL and Ultrasparc T1 From: "Luke Lonergan" To: "Juan Casero" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] PostgreSQL and Ultrasparc T1 Thread-Index: AcYD8GoURvloCvVWR5ygX3dh8AWKMAAfF0FW In-Reply-To: <200512181135.15202.caseroj@comcast.net> MIME-Version: 1.0 X-OriginalArrivalTime: 19 Dec 2005 07:21:07.0844 (UTC) FILETIME=[C79AFC40:01C6046C] X-WSS-ID: 6FB880EE15W36025-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.268 required=5 tests=[AWL=0.015, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.268 X-Spam-Level: * X-Archive-Number: 200512/450 X-Sequence-Number: 16271 Juan, On 12/18/05 8:35 AM, "Juan Casero" wrote: > Can anyone tell me how well PostgreSQL 8.x performs on the new Sun Ultrasparc > T1 processor and architecture on Solaris 10? I have a custom built retail > sales reporting that I developed using PostgreSQL 7.48 and PHP on a Fedora > Core 3 intel box. I want to scale this application upwards to handle a > database that might grow to a 100 GB. Our company is green mission conscious > now so I was hoping I could use that to convince management to consider a Sun > Ultrasparc T1 or T2 system provided that if I can get the best performance > out of it on PostgreSQL. So will newer versions of PostgreSQL (8.1.x) be > able to take of advantage of the multiple cores on a T1 or T2? I cannot > change the database and this will be a hard sell unless I can convince them > that the performance advantages are too good to pass up. The company is > moving in the Win32 direction and so I have to provide rock solid reasons for > why I want to use Solaris Sparc on a T1 or T2 server for this database > application instead of Windows on SQL Server. The Niagara CPUs are heavily multi-threaded and will require a lot of parallelism to be exposed to them in order to be effective. Until Sun makes niagara-based machines with lots of I/O channels, there won't be much I/O parallelism available to match the CPU parallelism. Bizgres MPP will use the process and I/O parallelism of these big SMP machines and the version based on Postgres 8.1 will be out in February. - Luke