| Scott Marlowe 2006-03-23, 1:33 pm |
| On Thu, 2006-03-23 at 00:19, Jojo Paderes wrote:
> I'd like to know if the latest PostgreSQL release can scale up by
> utilizing multiple cpu or dual core cpu to boost up the sql
> executions.
>
> I already do a research on the PostgreSQL mailing archives and only
> found old threads dating back 2000. A lot of things have improved with
> PostgreSQL and hopefully the support for multiple cpu or dual cores is
> already provided.
Can a single query be split up into parts and run on separate processors
at the same time? No.
Can multiple incoming queries be run on different processors for better
performance? Yes.
Has someone been working on the problem of splitting a query into pieces
and running it on multiple CPUs / multiple machines? Yes. Bizgress has
done that.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
|