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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html