Re: utilising multi-cpu/core machines?

>>> On Wed, Sep 5, 2007 at  5:41 PM, in message <46DF3082.7040301@ifi.uio.no>,
Thomas Finneid <tfinneid@student.matnat.uio.no> wrote:
> how does pg utilise multi cpus/cores, i.e. does it use more than one
> core? and possibly, how, are there any documentation about this.

For portability reasons PostgreSQL doesn't use threads, per se, but spawns
a new process for each connection, and a few for other purposes.  Each
process may be running on a separate CPU, but a single connection will
only be using one -- directly, anyway.  (The OS may well be using the
other for I/O, etc.)

For documentation, you could start with this:

http://www.postgresql.org/docs/8.2/interactive/app-postgres.html

-Kevin