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 8E17111F66F3 for ; Wed, 5 Apr 2006 18:54:28 -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 76988-10 for ; Wed, 5 Apr 2006 18:54:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mi8.com (d01gw02.mi8.com [63.240.6.46]) by postgresql.org (Postfix) with ESMTP id D37A211F66E8 for ; Wed, 5 Apr 2006 18:54:25 -0300 (ADT) Received: from 172.16.1.148 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D2)); Wed, 05 Apr 2006 17:54:16 -0400 X-Server-Uuid: 7829E76E-BB9E-4995-8473-3C0929DF7DD1 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01HOST02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 5 Apr 2006 17:54:15 -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 ; Wed, 5 Apr 2006 21:54:15 +0000 User-Agent: Microsoft-Entourage/11.2.3.060209 Date: Wed, 05 Apr 2006 14:54:13 -0700 Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3 From: "Luke Lonergan" To: "Juan Casero (FL FLC)" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Sun Fire T2000 and PostgreSQL 8.1.3 Thread-Index: AcZY2tjXfVRhB87QTyyEQXkYWR91JAAAagagAAVFz+oAAEdD8AABm2MGAAAzVGAAAGJtiA== In-Reply-To: <7583B3F1891CC0429FA4A44952AA539C66FA77@wfm-exchprd2.wfm.pvt> MIME-Version: 1.0 X-OriginalArrivalTime: 05 Apr 2006 21:54:15.0272 (UTC) FILETIME=[7B255E80:01C658FB] X-WSS-ID: 682AE3F32XS40480620-20-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.346 required=5 tests=[AWL=0.093, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.346 X-Spam-Level: * X-Archive-Number: 200604/69 X-Sequence-Number: 18153 Juan, On 4/5/06 2:45 PM, "Juan Casero (FL FLC)" wrote: > Do you think bizgres might be a good choice of database server for the > Ultrasparc T1 based T2000? I have downloaded the source code but I was > hoping to find out if the potential performance gains were worth the > effort to compile and install the code. Bizgres (non-MPP) does not do any multi-CPU parallelism, so it won't use more CPUs in your T2000. It does have the faster sort performance and an on-disk bitmap index, both of which will make it run many times (3-6) faster than 8.1 Postgres depending if your queries use larger data or involve sorts. Bizgres MPP is closed source and unfortunately for your T2000 experiment it doesn't currently support Solaris SPARC CPUs, only Solaris x86. It would use all of your CPUs and I/O channels on one or more machines for every query. Again, it's optimized for queries where that use a lot of data or have a lot of complexity (sorts, aggregations, joins, etc). - Luke