Actually, even Microsoft SQL Server will do this for you (you can even
chose if it shoudl split it up on all processors or a maximum number).
Will do it on any types of queries, as long as they're big enough (you
can tweak the cost limit, but the general idea is only process
CPU-expensive queries that way)
//Magnus
> -----Original Message-----
> From: Andriy Tkachuk [mailto:ant@imt.com.ua]
> Sent: Monday, October 13, 2003 10:53 AM
> To: Bill Moran
> Cc: johnnnnnn; pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] One or more processor ?
>
>
> 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend