From: Christopher Browne <cbbrowne@libertyrms.info>
To: pgsql-performance@postgresql.org
Subject: Re: One or more processor ?
Date: Fri, 10 Oct 2003 14:49:30 -0400
Message-ID: <6065ix3p39.fsf@dev6.int.libertyrms.info> (raw)
References: <200310101830.49608.herve@elma.fr>
herve@elma.fr (=?iso-8859-15?q?Herv=E9=20Piedvache?=) writes:
> 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 ?
Just one processor.
> And if it use only one ... why ?
> Could you explain me this ;o)
... Because partitioning requests across multiple processors is a
hairy and difficult proposition.
Some musing has been done on how threading might be used to split
processing of queries across multiple CPUs, but it represents a pretty
immense task involving substantial effort for design, implementation,
and testing.
It's tough to make this portable across all the system PostgreSQL
supports, too.
So while musing has been done, nobody has seriously tried implementing
it.
--
output = ("cbbrowne" "@" "libertyrms.info")
<http://dev6.int.libertyrms.com/;
Christopher Browne
(416) 646 3304 x124 (land)
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: cbbrowne@libertyrms.info
Subject: Re: One or more processor ?
In-Reply-To: <6065ix3p39.fsf@dev6.int.libertyrms.info>
* 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