X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 57860D1B513 for ; Fri, 10 Oct 2003 17:04:20 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 55663-07 for ; Fri, 10 Oct 2003 14:03:31 -0300 (ADT) Received: from phaedrusdeinus.org (dsl092-130-239.chi1.dsl.speakeasy.net [66.92.130.239]) by svr1.postgresql.org (Postfix) with SMTP id 5F75BD1B4FD for ; Fri, 10 Oct 2003 14:03:29 -0300 (ADT) Received: (qmail 52315 invoked by uid 1001); 10 Oct 2003 17:15:34 -0000 Date: Fri, 10 Oct 2003 12:15:34 -0500 From: johnnnnnn To: pgsql-performance@postgresql.org Subject: Re: One or more processor ? Message-ID: <20031010171534.GB7976@performics.com> References: <200310101830.49608.herve@elma.fr> <3F86E15C.1010309@potentialtech.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3F86E15C.1010309@potentialtech.com> User-Agent: Mutt/1.5.1i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/347 X-Sequence-Number: 4095 On Fri, Oct 10, 2003 at 12:42:04PM -0400, Bill Moran wrote: > 4) It simply isn't practical to expect a single query to > execute on multiple processors simultaneously. > > Do you know of any RDBMS that actually will execute a single query > on multiple processors? Yes, DB2 will do this if configured correctly. It's very useful for large, complicated queries that have multiple subplans. -johnnnnnnnn