Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XKCcD-000135-LS for pgsql-performance@arkaria.postgresql.org; Wed, 20 Aug 2014 20:36:17 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XKCcC-0001DB-Hx for pgsql-performance@arkaria.postgresql.org; Wed, 20 Aug 2014 20:36:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XKCcB-0001D1-Ea for pgsql-performance@postgresql.org; Wed, 20 Aug 2014 20:36:15 +0000 Received: from smtp2.peak6.com ([38.98.137.9]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XKCc5-0004iC-Ly for pgsql-performance@postgresql.org; Wed, 20 Aug 2014 20:36:14 +0000 X-AuditID: 0a02cb20-f798c6d000007a0a-17-53f506b7e346 Received: from sswchi5pcas2.peak6.net (Unknown_Domain [10.100.13.24]) (using TLS with cipher AES128-SHA (128/128 bits)) (Client did not present a certificate) by smtp2.peak6.com (Symantec Messaging Gateway) with SMTP id CB.95.31242.7B605F35; Wed, 20 Aug 2014 15:36:07 -0500 (CDT) Received: from [10.10.161.7] (10.10.161.7) by sswchi5pcas2.peak6.net (10.100.13.25) with Microsoft SMTP Server (TLS) id 14.3.158.1; Wed, 20 Aug 2014 15:36:06 -0500 Message-ID: <53F506B5.1040507@optionshouse.com> Date: Wed, 20 Aug 2014 15:36:05 -0500 From: Shaun Thomas User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.6.0 MIME-Version: 1.0 To: Josh Berkus , CC: Mark Kirkwood , "Graeme B. Bell" Subject: Re: Turn off Hyperthreading! WAS: 60 core performance with 9.3 References: <53ACB190.2030206@catalyst.net.nz> <53ECFD75.3060408@agliodbs.com> <53ED371D.109@catalyst.net.nz> <53F4F36E.6050003@agliodbs.com> In-Reply-To: <53F4F36E.6050003@agliodbs.com> Content-Type: text/plain; charset="UTF-8"; format=flowed content-transfer-encoding: 7bit X-Originating-IP: [10.10.161.7] X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFupkleLIzCtJLcpLzFFi42LhSuGV0N3O9jXY4NFZeYveRyIWH7ZNYreY vXYuu8X1meeYHVg87t9az+xx788ldo8L+6axe/S/rQ5giWpgtEnMy8svSSxJVUhJLU62VfIv KMnMzyv2yC8tTlVwySxOzknMzE0tUlLITLFVMlZSKMhJTE7NTc0rsVVKLChIzUtRsuNSwAA2 QGWZeQqpecn5KZl56bZKnsH+uhYWppa6hkp28cggoZMl4+PuRywFV5krrl9uYmlg/MLUxcjJ ISFgIvHtdwuULSZx4d56ti5GLg4hgblMEj+etLBAOMsZJa7dWswGUsUroC9xfUszUAcHB4uA qsTVTg6QMJuArsSk/hVgJaICYRKP55xjhCgXlDg58wkLiC0i4C5x9sx/NpBWZoFYiblPY0HC wgLBEh3zT0Ct+s4k0X/nBNgcTgEdiduHjrGC2MwCFhKL3xxkh7DlJba/ncMMYgsBnbCieSIb xAPyEttm32aewCg0C8nqWUjaZyFpX8DIvIpRvLgsMTkj06ygOLekwEivIDUx20wvL7VkEyMo vplOK+xg3NxjdYhRgINRiYf3w/YvwUKsiWXFlbmHGCU4mJVEeF1/AYV4UxIrq1KL8uOLSnNS iw8x+gCDZiKzlGhyPjD15JXEGxqbGphamhqampsaGuEQVhLnveB9K1hIIB2YTLJTUwtSi2DG MXFwSjUwbrh973/Sr90TD8cyCIYq1LJafdjH3hKxc4Kc0sO2J7/yGXw5D3Fn+W1N8fZWLSyO CZPjOc97bOeanAi+o9+UhFwjg5Zxnm25/UxEJ1dQ0biQU/Kk3b2HawRKJ62Q/hL/+npe9ZKi gN1xadqR4dlzNnUIG34+MLfiw9Vovm6vBW3zj/45Z/BTiaU4I9FQi7moOBEAR/OmSxwDAAA= X-Pg-Spam-Score: -1.9 (-) 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 08/20/2014 02:13 PM, Josh Berkus wrote: > So we're definitely back to "If you're using PostgreSQL, turn off > Hyperthreading". That's so strange. Back when I did my Nehalem tests, we got a very strong 30%+ increase by enabling HT. We only got a hit when we turned off turbo, or forgot to disable power saving features. -- Shaun Thomas OptionsHouse, LLC | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604 312-676-8870 sthomas@optionshouse.com ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance