From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-performance@postgresql.org
To: Thomas Finneid <tfinneid@student.matnat.uio.no>
Subject: Re: utilising multi-cpu/core machines?
Date: Thu, 06 Sep 2007 08:46:40 -0500
Message-ID: <46DFBE70.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <46DF3082.7040301@ifi.uio.no>
References: <46DF3082.7040301@ifi.uio.no>
>>> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, tfinneid@student.matnat.uio.no
Subject: Re: utilising multi-cpu/core machines?
In-Reply-To: <46DFBE70.EE98.0025.0@wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox