X-Original-To: pgsql-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 025B747592C for ; Thu, 8 May 2003 12:20:25 -0400 (EDT) Received: from varsoon.wireboard.com (www.wireboard.com [216.151.155.101]) by postgresql.org (Postfix) with ESMTP id 69626474E4F for ; Thu, 8 May 2003 12:20:24 -0400 (EDT) Received: from doug by varsoon.wireboard.com with local (Exim 3.35 #1) id 19Do8B-0003b0-00; Thu, 08 May 2003 12:20:27 -0400 To: lista@profit-ti.com.br Cc: pgsql-hackers@postgresql.org Subject: Re: Hyper-Threading References: <3EBA568C.1229.FAB97D5@localhost> From: Doug McNaught Date: 08 May 2003 12:20:27 -0400 In-Reply-To: lista@profit-ti.com.br's message of "Thu, 8 May 2003 13:07:24 -0300" Message-ID: Lines: 21 User-Agent: Gnus/5.0806 (Gnus v5.8.6) Emacs/20.7 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-38.8 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_GNUS_UA autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/197 X-Sequence-Number: 38704 lista@profit-ti.com.br writes: > Hi People! =0F > As a project manager I decided to migrate the full project from Oracle=20 > to PostgreSQL.=0F > =0F > We bought a new Intel box to host the database, it is a dual Xeon 2.2=20 > and I intend to use it with a FreeBSD 4.8 wich support Intel Hyper- > Threading. > =0F > I Woul like to know if the PostgreSQL 7.3.2 will take advantage from=20 > Hyper-Threading? The question is really the same as "will PostgreSQL take advantage of multiple processors?" The answer is that it will not split single queries across multiple virtual or physical processors, but if you have multiple clients connected each client backend (which is an independent process) can be scheduled on any CPU available to it. -Doug