Thread: core 2 duo

This might be old news to a lot of people, but I'm wondering if pg will
automatically use both processors concurrently in a Core 2 Duo system.  I'm
planning to install OpenBSD 4.0 with SMP kernel (bsd.mp) and install pg
using their binary 8.1.5 package.

Frank Bax wrote:
> This might be old news to a lot of people, but I'm wondering if pg
> will automatically use both processors concurrently in a Core 2 Duo
> system.  I'm planning to install OpenBSD 4.0 with SMP kernel (bsd.mp)
> and install pg using their binary 8.1.5 package.
I don't think so.  These SMP machines are simply two processors.  If you
run one query, only one process is used, so only one processor.  If you
have two independent queries (from two different users, for example),
two processes will be used and then the second processor can be utilized.

Sean

At 08:21 AM 12/17/06, Sean Davis wrote:

>Frank Bax wrote:
>>This might be old news to a lot of people, but I'm wondering if pg will
>>automatically use both processors concurrently in a Core 2 Duo
>>system.  I'm planning to install OpenBSD 4.0 with SMP kernel (bsd.mp) and
>>install pg using their binary 8.1.5 package.
>
>
>I don't think so.  These SMP machines are simply two processors.  If you
>run one query, only one process is used, so only one processor.  If you
>have two independent queries (from two different users, for example), two
>processes will be used and then the second processor can be utilized.


I assumed it wouldn't use two processors on one query.  I was wondering if
independent queries would automatically use multiple processors when
available; or if some special action had to be invoked (like compile time
switch or config option) before this behaviour was possible.  Sounds like
we get this behaviour "out of the box".  Great.