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 30ED3D1B51B for ; Fri, 10 Oct 2003 17:27:10 +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 63915-03 for ; Fri, 10 Oct 2003 14:26:25 -0300 (ADT) Received: from mta9.adelphia.net (mta9.adelphia.net [68.168.78.199]) by svr1.postgresql.org (Postfix) with ESMTP id BFC14D1B4ED for ; Fri, 10 Oct 2003 14:26:23 -0300 (ADT) Received: from potentialtech.com ([68.68.113.33]) by mta9.adelphia.net (InterMail vM.5.01.06.05 201-253-122-130-105-20030824) with ESMTP id <20031010172626.TJYK4462.mta9.adelphia.net@potentialtech.com>; Fri, 10 Oct 2003 13:26:26 -0400 Message-ID: <3F86EBD0.3050609@potentialtech.com> Date: Fri, 10 Oct 2003 13:26:40 -0400 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20031005 X-Accept-Language: en-us, en MIME-Version: 1.0 To: johnnnnnn Cc: pgsql-performance@postgresql.org Subject: Re: One or more processor ? References: <200310101830.49608.herve@elma.fr> <3F86E15C.1010309@potentialtech.com> <20031010171534.GB7976@performics.com> In-Reply-To: <20031010171534.GB7976@performics.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/350 X-Sequence-Number: 4098 johnnnnnn wrote: > 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. I expected there would be someone who did (although I didn't know for sure). Is DB2 the only one that can do that? -- Bill Moran Potential Technologies http://www.potentialtech.com