Re: Two identical systems, radically different performance - Mailing list pgsql-performance

From Andrea Suisani
Subject Re: Two identical systems, radically different performance
Date
Msg-id 5076D433.7090605@opinioni.net
Whole thread Raw
In response to Re: Two identical systems, radically different performance  (Craig James <cjames@emolecules.com>)
Responses Re: Two identical systems, radically different performance  (Claudio Freire <klaussfreire@gmail.com>)
List pgsql-performance
On 10/09/2012 01:40 AM, Craig James wrote:
> Nobody has commented on the hyperthreading question yet ... does it really matter? The old (fast) server has
hyperthreadingdisabled, and the new (slower) server has hyperthreads enabled. 
>
> If hyperthreading is definitely NOT an issue, it will save me a trip to the co-lo facility.


sorry to come late to the party, but being in a similar condition
I've googled a bit and I've found a way to disable hyperthreading without
the need to reboot the system and entering the bios:

echo 0 >/sys/devices/system/node/node0/cpuX/online

where X belongs to 1..(#cores * 2) if hyperthreading is enabled
(cpu0 can't be switched off).

didn't try myself on live system, but I definitely will
as soon as I have a new machine to test.

Andrea




pgsql-performance by date:

Previous
From: Franck Routier
Date:
Subject: Re: Drawbacks of create index where is not null ?
Next
From: Claudio Freire
Date:
Subject: Re: Two identical systems, radically different performance