Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TMJWj-00071e-Ur for pgsql-performance@postgresql.org; Thu, 11 Oct 2012 14:14:18 +0000 Received: from host36.ns3.it ([80.79.54.36] helo=mail.opinioni.net) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TMJWi-0001if-Ae for pgsql-performance@postgresql.org; Thu, 11 Oct 2012 14:14:17 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.opinioni.net (Postfix) with ESMTP id 2C5E24D6CB2; Thu, 11 Oct 2012 16:16:29 +0200 (CEST) Received: from mail.opinioni.net ([127.0.0.1]) by localhost (opinioni.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id RwuORVWf2h7d; Thu, 11 Oct 2012 16:16:29 +0200 (CEST) Received: from [192.168.1.50] (78-134-6-72.v4.ngi.it [78.134.6.72]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.opinioni.net (Postfix) with ESMTPS id 3AB574D6C2F; Thu, 11 Oct 2012 16:16:28 +0200 (CEST) Message-ID: <5076D433.7090605@opinioni.net> Date: Thu, 11 Oct 2012 16:14:11 +0200 From: Andrea Suisani User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:15.0) Gecko/20120912 Thunderbird/15.0.1 MIME-Version: 1.0 To: Craig James CC: pgsql-performance@postgresql.org Subject: Re: Two identical systems, radically different performance References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201210/147 X-Sequence-Number: 48106 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 hyperthreading disabled, 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