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 41AC89DC8A1 for ; Thu, 23 Mar 2006 09:38:07 -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 31988-02 for ; Thu, 23 Mar 2006 09:38:10 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 37D0E9DC87C for ; Thu, 23 Mar 2006 09:38:04 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id D5AE530CDE; Thu, 23 Mar 2006 14:38:07 +0100 (MET) From: Christopher Browne X-Newsgroups: pgsql.performance Subject: Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Powered Servers Date: Thu, 23 Mar 2006 08:23:42 -0500 Organization: cbbrowne Computing Inc Lines: 20 Message-ID: <87mzfhl2g1.fsf@wolfe.cbbrowne.com> References: <65f9ddfb0603222219r1742c2aevda37acd55ca845be@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:HDjiqZWr4hpYDj1M4wqzWJH+Rjk= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.315 required=5 tests=[AWL=0.315] X-Spam-Score: 0.315 X-Spam-Level: X-Archive-Number: 200603/471 X-Sequence-Number: 17908 jojo.paderes@gmail.com ("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. If you submit multiple concurrent queries, they can be concurrently processed on separate CPUs; that has long been supported, and people have been using SMP systems to this end for years. -- let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];; http://cbbrowne.com/info/spreadsheets.html "In other words -- and this is the rock solid principle on which the whole of the Corporation's Galaxy-wide success is founded -- their fundamental design flaws are completely hidden by their superficial design flaws." -- HHGTG