Re: utilising multi-cpu/core machines?

["Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>]

>>> On Wed, Sep 5, 2007 at  5:41 PM, in message <46DF3082(dot)7040301(at)ifi(dot)uio(dot)no>,
Thomas Finneid <tfinneid(at)student(dot)matnat(dot)uio(dot)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