Re: utilising multi-cpu/core machines?

From: "Trevor Talbot" <quension(at)gmail(dot)com>
To: "Thomas Finneid" <tfinneid(at)student(dot)matnat(dot)uio(dot)no>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: utilising multi-cpu/core machines?
Date: 2007-09-06 00:07:57
Message-ID: 90bce5730709051707j30fb4ac9w4c65158f736e22e5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 9/5/07, 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.

PostgreSQL creates a new process to handle each connection to the
database. Multiple sessions can therefore spread across multiple
cores, but a single session will never use more than one.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2007-09-06 00:12:04 Re: Performance on 8CPU's and 32GB of RAM
Previous Message Ansgar -59cobalt- Wiechers 2007-09-05 23:19:21 Re: Performance on 8CPU's and 32GB of RAM