X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id D85F29DC83D
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 27 Mar 2006 10:25:27 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 69049-10
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 27 Mar 2006 10:25:31 -0400 (AST)
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id 26E879DC800
	for <pgsql-performance@postgresql.org>;
	Mon, 27 Mar 2006 10:25:25 -0400 (AST)
Received: from smtp1.voila.fr (smtp1.voila.fr [193.252.22.174])
	by svr4.postgresql.org (Postfix) with ESMTP id 4F57C5AF197
	for <pgsql-performance@postgresql.org>;
	Mon, 27 Mar 2006 14:25:30 +0000 (GMT)
Received: from me-wanadoo.net (localhost [127.0.0.1])
	by mwinf4009.voila.fr (SMTP Server) with ESMTP id 7F95F6800171
	for <pgsql-performance@postgresql.org>;
	Mon, 27 Mar 2006 16:25:25 +0200 (CEST)
Received: from wwinf4002 (wwinf4002 [172.22.157.29])
	by mwinf4009.voila.fr (SMTP Server) with ESMTP id 73DA0680016B
	for <pgsql-performance@postgresql.org>;
	Mon, 27 Mar 2006 16:25:25 +0200 (CEST)
X-ME-UUID: 20060327142525474.73DA0680016B@mwinf4009.voila.fr
Message-ID: <16175346.1143469525456.JavaMail.www@wwinf4002>
From: luchot <luchot@voila.fr>
Reply-To: luchot@voila.fr
To: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Query parallelism
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_25669_13291368.1143469525454"
X-Originating-IP: [129.185.75.10]
X-Wum-Nature: EMAIL-NATURE
X-WUM-FROM: |~|
X-WUM-TO: |~|
X-WUM-REPLYTO: |~|
Date: Mon, 27 Mar 2006 16:25:25 +0200 (CEST)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.946 required=5 tests=[HTML_10_20=0.945,
	HTML_MESSAGE=0.001]
X-Spam-Score: 0.946
X-Spam-Level: 
X-Archive-Number: 200603/520
X-Sequence-Number: 17957

------=_Part_25669_13291368.1143469525454
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hello everybody ,
I use PostgreSQL 8.1.3 on a bi-processor Xeon and I would know how to do to enable a parallelism for 
the execution of  queries. Indeed , when I analyse the use of the cpus during a query the result is that for 
some minutes a cpu is used while the other not and after it is the contrary. So they are not used at the same 
time and i would know what i have to do in order cpus work together .
Thanks and sorry for my english,
------=_Part_25669_13291368.1143469525454
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<P>Hello everybody ,</P>
<P>I use PostgreSQL 8.1.3 on a bi-processor Xeon and I would know how to do to enable a parallelism for </P>
<P>the execution of&nbsp; queries. Indeed , when I analyse the use of the cpus during a query the result is that for </P>
<P>some minutes a cpu is used while the other not and after it is the contrary. So they are not used at the same </P>
<P>time and i would know what i have to do in order cpus work together .</P>
<P>Thanks and sorry for my english,</P>
<P>&nbsp;</P>
------=_Part_25669_13291368.1143469525454--