>>> On Wed, Sep 5, 2007 at 5:41 PM, in message <46DF3082.7040301@xxxxxxxxxx>, Thomas Finneid <tfinneid@xxxxxxxxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
