>>> 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
