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 A3BC69DC847 for ; Sun, 18 Dec 2005 12:30:05 -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 32663-02 for ; Sun, 18 Dec 2005 12:29:59 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from rwcrmhc11.comcast.net (rwcrmhc11.comcast.net [216.148.227.151]) by postgresql.org (Postfix) with ESMTP id DDB3F9DC833 for ; Sun, 18 Dec 2005 12:29:58 -0400 (AST) Received: from lifebook.aspen (c-66-176-9-173.hsd1.fl.comcast.net[66.176.9.173]) by comcast.net (rwcrmhc11) with ESMTP id <2005121816295801300c6pcbe>; Sun, 18 Dec 2005 16:29:58 +0000 Content-Disposition: inline From: Juan Casero To: pgsql-performance@postgresql.org Subject: PostgreSQL and Ultrasparc T1 Date: Sun, 18 Dec 2005 11:35:15 -0500 User-Agent: KMail/1.8.2 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200512181135.15202.caseroj@comcast.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=2.319 required=5 tests=[DNS_FROM_RFC_POST=1.44, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 2.319 X-Spam-Level: ** X-Archive-Number: 200512/440 X-Sequence-Number: 16261 Hi - 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. Thanks, Juan -------------------------------------------------------