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 9F5A89DC853 for ; Thu, 23 Mar 2006 12:43:48 -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 67803-02 for ; Thu, 23 Mar 2006 12:43:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 6C1759DC80A for ; Thu, 23 Mar 2006 12:43:44 -0400 (AST) Received: from [192.168.1.5] (or-67-76-146-141.sta.sprint-hsd.net [67.76.146.141]) (authenticated bits=0) by projects.commandprompt.com (8.13.4/8.13.4) with ESMTP id k2NGhYH0032762; Thu, 23 Mar 2006 08:43:37 -0800 Message-ID: <4422D033.2030407@commandprompt.com> Date: Thu, 23 Mar 2006 08:43:31 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mail/News 1.5 (X11/20060309) MIME-Version: 1.0 To: Scott Marlowe CC: Jojo Paderes , pgsql-performance@postgresql.org Subject: Re: Scaling up PostgreSQL in Multiple CPU / Dual Core References: <65f9ddfb0603222219r1742c2aevda37acd55ca845be@mail.gmail.com> <1143131901.17999.67.camel@state.g2switchworks.com> In-Reply-To: <1143131901.17999.67.camel@state.g2switchworks.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88, clamav-milter version 0.87 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Thu, 23 Mar 2006 08:43:38 -0800 (PST) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.088 required=5 tests=[AWL=0.088] X-Spam-Score: 0.088 X-Spam-Level: X-Archive-Number: 200603/475 X-Sequence-Number: 17912 > Has someone been working on the problem of splitting a query into pieces > and running it on multiple CPUs / multiple machines? Yes. Bizgress has > done that. I believe that is limited to Bizgress MPP yes? > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >