Re: One or more processor ?

From: Andriy Tkachuk <ant(at)imt(dot)com(dot)ua>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: johnnnnnn <john(at)phaedrusdeinus(dot)org>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: One or more processor ?
Date: 2003-10-13 08:53:12
Message-ID: 20031013115204.S51447-100000@pool.imt.com.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Magnus Hagander 2003-10-13 09:04:44 Re: One or more processor ?
Previous Message Andriy Tkachuk 2003-10-13 07:32:03 Re: IMMUTABLE function's flag do not work: 7.3.4, plpgsql