Re: Hyper-Threading

On Thu, 8 May 2003 lista@profit-ti.com.br wrote:

> Hi People! 
> As a project manager I decided to migrate the full project from Oracle 
> to PostgreSQL.
> 
> We bought a new Intel box to host the database, it is a dual Xeon 2.2 
> and I intend to use it with a FreeBSD 4.8  wich support Intel Hyper-
> Threading.
>  
> I Woul like to know if the PostgreSQL 7.3.2 will take advantage from 
> Hyper-Threading?

Postgresql is not a multi-threaded app, so my guess is no, it won't.  but 
if the OS benefits from it then you may see a slight speed increase.

while a neat idea, hyperthreading seems to be promising far more than it 
is delivering.

In testing on Windows XP with SQL server, the performance increase on a 
single CPU machine with hyperthreading enabled was only about 20%.  Of 
course, Microsoft charges you for a whole nother CPU for that 20% 
performance gain. :-)

The box Being dual CPU will make a bigger difference than being 
hyperthreaded.