Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZHTYV-0000zK-BO for pgsql-performance@arkaria.postgresql.org; Tue, 21 Jul 2015 09:09:43 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZHTYU-0002cs-U4 for pgsql-performance@arkaria.postgresql.org; Tue, 21 Jul 2015 09:09:42 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZHTWr-0000Ki-MR for pgsql-performance@postgresql.org; Tue, 21 Jul 2015 09:08:01 +0000 Received: from mail.catalyst.net.nz ([2404:130:0:10::40:0]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1ZHTWi-0003It-GQ for pgsql-performance@postgresql.org; Tue, 21 Jul 2015 09:07:58 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.catalyst.net.nz (Postfix) with ESMTP id 27AA831D87; Tue, 21 Jul 2015 21:07:48 +1200 (NZST) X-Virus-Scanned: Debian amavisd-new at catalyst.net.nz Received: from mail.catalyst.net.nz ([127.0.0.1]) by localhost (bertrand.catalyst.net.nz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id V4vBBZcAe1y1; Tue, 21 Jul 2015 21:07:46 +1200 (NZST) Received: from [192.168.1.64] (125-239-84-197.jetstream.xtra.co.nz [125.239.84.197]) (Authenticated sender: mark.kirkwood) by mail.catalyst.net.nz (Postfix) with ESMTPSA id 96F7F31D5F; Tue, 21 Jul 2015 21:07:46 +1200 (NZST) Message-ID: <55AE0BE2.3040603@catalyst.net.nz> Date: Tue, 21 Jul 2015 21:07:46 +1200 From: Mark Kirkwood User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.7.0 MIME-Version: 1.0 To: David Rowley , Jeison Bedoya Delgado CC: pgsql-performance@postgresql.org Subject: Re: hyperthreadin low performance References: <55ADB586.2010406@audifarma.com.co> In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -5.4 (-----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 21/07/15 20:04, David Rowley wrote: > On 21 July 2015 at 14:59, Jeison Bedoya Delgado > > wrote: > > hi everyone, > > Recently update a database to machine with RHEL7, but i see that the > performance is betther if the hyperthreading tecnology is > deactivated and use only 32 cores. > > is normal that the machine performance is better with 32 cores that > 64 cores?. > > > You might be interested in > http://www.postgresql.org/message-id/53F4F36E.6050003@agliodbs.com > However I do wonder if we have been misinterpreting these tests. We tend to assume the position of "see hyperthreading is bad, switch it off". The linked post under the one above: http://www.postgresql.org/message-id/53ED371D.109@catalyst.net.nz shows that 60 core (no hyperthreading) performance is also pessimal, leading me to conclude that *perhaps* it is simply the number of cores that is the problem - particularly as benchmark results for single socket cpus clearly show hyperthreading helps performance... Regards Mark -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance