X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 02008D1B517 for ; Mon, 13 Oct 2003 18:44:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 00245-06 for ; Mon, 13 Oct 2003 15:44:07 -0300 (ADT) Received: from jamesr.best.vwh.net (jamesr.best.vwh.net [192.220.76.165]) by svr1.postgresql.org (Postfix) with SMTP id 10E70D1B50E for ; Mon, 13 Oct 2003 15:44:08 -0300 (ADT) Received: (qmail 63100 invoked by uid 19621); 13 Oct 2003 18:43:47 -0000 Received: from unknown (HELO ?10.0.0.210?) ([65.87.16.98]) (envelope-sender ) by 192.220.76.165 (qmail-ldap-1.03) with SMTP for ; 13 Oct 2003 18:43:47 -0000 Subject: Re: One or more processor ? From: James Rogers To: pgsql-performance@postgresql.org In-Reply-To: <20031013115204.S51447-100000@pool.imt.com.ua> References: <20031013115204.S51447-100000@pool.imt.com.ua> Content-Type: text/plain Organization: Message-Id: <1066070623.18133.15.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 13 Oct 2003 11:43:43 -0700 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/425 X-Sequence-Number: 4173 On Mon, 2003-10-13 at 01:53, Andriy Tkachuk wrote: > > >>Do you know of any RDBMS that actually will execute a single query > > >>on multiple processors? > > > > Oracle, i think, on partitioned tables. This makes a certain amount of sense. It be much easier to allow this on partitioned tables than in the general case, since partitioned tables look a lot like multiple relations hiding behind a view and one could simply run one thread per partition in parallel without any real fear of contention on the table. This is doubly useful since partitioned tables tend to be huge almost by definition. Offhand, it would seem that this would be a feature largely restricted to threaded database kernels for a couple different pragmatic reasons. Cheers, -James Rogers jamesr@best.com