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 BFC1611F655B for ; Wed, 5 Apr 2006 17:43:46 -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 25182-09 for ; Wed, 5 Apr 2006 17:43:45 -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 24C0A11F6269 for ; Wed, 5 Apr 2006 17:43:43 -0300 (ADT) Received: from 172.16.1.112 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D4)); Wed, 05 Apr 2006 16:43:32 -0400 X-Server-Uuid: C8FB4D43-1108-484A-A898-3CBCC7906230 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01SMTP02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 5 Apr 2006 16:43:31 -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 20:43:31 +0000 User-Agent: Microsoft-Entourage/11.2.3.060209 Date: Wed, 05 Apr 2006 13:43:29 -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+o= In-Reply-To: <7583B3F1891CC0429FA4A44952AA539C66FA2C@wfm-exchprd2.wfm.pvt> MIME-Version: 1.0 X-OriginalArrivalTime: 05 Apr 2006 20:43:31.0574 (UTC) FILETIME=[99B47160:01C658F1] X-WSS-ID: 682AF47E20C39709062-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.345 required=5 tests=[AWL=0.092, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.345 X-Spam-Level: * X-Archive-Number: 200604/62 X-Sequence-Number: 18146 Juan, On 4/5/06 11:12 AM, "Juan Casero (FL FLC)" wrote: > I know the postgresql server is not smp aware but I believe > parts of it are. In particular the buffer manager is supposed to scale the > performance almost linearly with the number of cpu's (including virtual ones). > I don't know however, if I need to recompile the postgresql server myself to > get those benefits. As Tom said, to get the benefits of parallelism on one query, you would need a parallelizing database like Teradata, Oracle Parallel Query option, Netezza, or Bizgres MPP. The announcement about Postgres linear scalability for SMP is only relevant to statement throughput for highly concurrent environments (web sites, OLTP, etc). - Luke