Re: PGSQL 7.4 -> 8.1 migration & performance problem - Mailing list pgsql-general

From Philippe Lang
Subject Re: PGSQL 7.4 -> 8.1 migration & performance problem
Date
Msg-id 6C0CF58A187DA5479245E0830AF84F421D0D5A@poweredge.attiksystem.ch
Whole thread Raw
In response to PGSQL 7.4 -> 8.1 migration & performance problem  ("Philippe Lang" <philippe.lang@attiksystem.ch>)
List 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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] De la part de Arnaud Lesauvage
Envoyé : mercredi, 31. mai 2006 16:20
À : pgsql-general@postgresql.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


Attachment

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: GPL Licensed Files in 8.1.4
Next
From: "Antonios Katsikadamos"
Date:
Subject: postgres in windows