Re: One or more processor ? - Mailing list pgsql-performance

From Andriy Tkachuk
Subject Re: One or more processor ?
Date
Msg-id 20031013115204.S51447-100000@pool.imt.com.ua
Whole thread Raw
In response to Re: One or more processor ?  (Bill Moran <wmoran@potentialtech.com>)
Responses Re: One or more processor ?
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Andriy Tkachuk
Date:
Subject: Re: IMMUTABLE function's flag do not work: 7.3.4, plpgsql
Next
From: "Magnus Hagander"
Date:
Subject: Re: One or more processor ?