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 E8123D1B4FF for ; Mon, 13 Oct 2003 08:54:23 +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 49050-07 for ; Mon, 13 Oct 2003 05:53:36 -0300 (ADT) Received: from pool.imt.com.ua (office.imt.com.ua [212.109.53.33]) by svr1.postgresql.org (Postfix) with ESMTP id 4ABD7D1B4E1 for ; Mon, 13 Oct 2003 05:53:30 -0300 (ADT) Received: from pool.imt.com.ua (localhost [127.0.0.1]) by pool.imt.com.ua (8.12.8p2/8.12.8) with ESMTP id h9D8rM4r052930; Mon, 13 Oct 2003 11:53:22 +0300 (EEST) (envelope-from ant@imt.com.ua) Received: from localhost (ant@localhost) by pool.imt.com.ua (8.12.8p2/8.12.8/Submit) with ESMTP id h9D8rDeG052927; Mon, 13 Oct 2003 11:53:19 +0300 (EEST) (envelope-from ant@imt.com.ua) Date: Mon, 13 Oct 2003 11:53:12 +0300 (EEST) From: Andriy Tkachuk To: Bill Moran Cc: johnnnnnn , Subject: Re: One or more processor ? In-Reply-To: <3F86EBD0.3050609@potentialtech.com> Message-ID: <20031013115204.S51447-100000@pool.imt.com.ua> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/412 X-Sequence-Number: 4160 On Fri, 10 Oct 2003, Bill Moran wrote: > 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? Oracle, i think, on partitioned tables. regards, andriy http://www.imt.com.ua