Re: PGSQL 7.4 -> 8.1 migration & performance problem

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: "Arnaud Lesauvage" <thewild(at)free(dot)fr>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: PGSQL 7.4 -> 8.1 migration & performance problem
Date: 2006-06-01 13:32:06
Message-ID: 6C0CF58A187DA5479245E0830AF84F421D0D5A@poweredge.attiksystem.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I made some tests, with and without Hyperthreading: with hyperthreading, on
a dual-processor, top mentions a 25% load, and without, 50%, but computing
time is exactly the same.

Philippe

-----Message d'origine-----
De : pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] De la part de Arnaud Lesauvage
Envoyé : mercredi, 31. mai 2006 16:20
À : pgsql-general(at)postgresql(dot)org
Objet : Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem

Philippe Lang a écrit :
> Hardware is much more powerful: intel server motherboard, dual-xeon
> 3GHz, SCSI disks (raid 1), 4GB RAM.

Do you need the hyperthreading ?
Depending on your case, you might have better results with 2x3GHz thant
4x1.5GHz.

--
Arnaud

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Browse pgsql-general by date

  From Date Subject
Next Message Jimbo1 2006-06-01 13:34:39 Java Triggers
Previous Message Antonios Katsikadamos 2006-06-01 13:28:03 postgres in windows