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

From Magnus Hagander
Subject Re: One or more processor ?
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE1E1877@algol.sollentuna.se
Whole thread Raw
In response to One or more processor ?  (Hervé Piedvache <herve@elma.fr>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Andriy Tkachuk
Date:
Subject: Re: One or more processor ?
Next
From: Seum-Lim Gan
Date:
Subject: Performance, vacuum and reclaiming space, fsm