Message-Id: <46DFBE70.EE98.0025.0@wicourts.gov>
Date: Thu, 06 Sep 2007 08:46:40 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: <pgsql-performance@postgresql.org>,
	"Thomas Finneid" <tfinneid@student.matnat.uio.no>
Subject: Re: utilising multi-cpu/core machines?
References: <46DF3082.7040301@ifi.uio.no>
In-Reply-To: <46DF3082.7040301@ifi.uio.no>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

>>> On Wed, Sep 5, 2007 at  5:41 PM, in message <46DF3082.7040301@ifi.uio.n=
o>,
Thomas Finneid <tfinneid@student.matnat.uio.no> wrote:=20
> how does pg utilise multi cpus/cores, i.e. does it use more than one=20
> core? and possibly, how, are there any documentation about this.
=20
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.)
=20
For documentation, you could start with this:
=20
http://www.postgresql.org/docs/8.2/interactive/app-postgres.html
=20
-Kevin
=20