pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bill Moran <wmoran@potentialtech.com>
To: Hervé Piedvache <herve@elma.fr>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: One or more processor ?
Date: Fri, 10 Oct 2003 12:42:04 -0400
Message-ID: <3F86E15C.1010309@potentialtech.com> (raw)
In-Reply-To: <200310101830.49608.herve@elma.fr>
References: <200310101830.49608.herve@elma.fr>

Hervé Piedvache wrote:
> Hi,
> 
> A simple question about PostgreSQL ... I have a Pentium Xeon Quadri processors 
> ...
> If I do a SQL request ... does PostgreSQL use one or more processor ?

PostgreSQL uses one processor per connection.  If you have 4 simultaneous
connections, you'll use all four processors (assuming your operating system
is properly designed/configured).

> And if it use only one ... why ?
> Could you explain me this ;o)

The answer to that is beyond my knowledge, but I have a few guesses:
1) Doing so is more complicated than you think.
2) The code was originally written for uniprocessor machines, and nobody
    has volunteered to update it yet.
3) kernel threading isn't as predictable as some people would like to
    think, thus they developers have avoided using it so far.
4) It simply isn't practical to expect a single query to
    execute on multiple processors simultaneously.

Do you know of any RDBMS that actually will execute a single query on
multiple processors?

-- 
Bill Moran
Potential Technologies
http://www.potentialtech.com




view thread (14+ messages)  latest in thread

Message-ID: <3F86E15C.1010309@potentialtech.com>
Permalink:  ../3F86E15C.1010309@potentialtech.com/
Also on:    postgresql.org/message-id/3F86E15C.1010309@potentialtech.com

 · 

reply

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: wmoran@potentialtech.com, herve@elma.fr
  Subject: Re: One or more processor ?
  In-Reply-To: <3F86E15C.1010309@potentialtech.com>

* 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