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 289C49DCAD4 for ; Thu, 23 Mar 2006 12:38:26 -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 66604-02 for ; Thu, 23 Mar 2006 12:38:24 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id DDBD49DC948 for ; Thu, 23 Mar 2006 12:38:22 -0400 (AST) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Thu, 23 Mar 2006 16:38:21 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 23 Mar 2006 10:38:21 -0600 Subject: Re: Scaling up PostgreSQL in Multiple CPU / Dual Core From: Scott Marlowe To: Jojo Paderes Cc: pgsql-performance@postgresql.org In-Reply-To: <65f9ddfb0603222219r1742c2aevda37acd55ca845be@mail.gmail.com> References: <65f9ddfb0603222219r1742c2aevda37acd55ca845be@mail.gmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1143131901.17999.67.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 23 Mar 2006 10:38:21 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.144 required=5 tests=[AWL=0.143, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.144 X-Spam-Level: X-Archive-Number: 200603/474 X-Sequence-Number: 17911 On Thu, 2006-03-23 at 00:19, Jojo Paderes wrote: > I'd like to know if the latest PostgreSQL release can scale up by > utilizing multiple cpu or dual core cpu to boost up the sql > executions. > > I already do a research on the PostgreSQL mailing archives and only > found old threads dating back 2000. A lot of things have improved with > PostgreSQL and hopefully the support for multiple cpu or dual cores is > already provided. Can a single query be split up into parts and run on separate processors at the same time? No. Can multiple incoming queries be run on different processors for better performance? Yes. 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.