| 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: | Whole Thread | Raw Message | 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
| 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 |