Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TWIbs-0007vy-Vp for pgsql-performance@postgresql.org; Thu, 08 Nov 2012 03:16:53 +0000 Received: from server13-scl.nuevasync.com ([64.13.138.208] helo=mail.nuevasync.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TWIbr-0003PJ-Hl for pgsql-performance@postgresql.org; Thu, 08 Nov 2012 03:16:52 +0000 Received: from [192.168.65.253] (unknown [69.51.127.178]) by mail.nuevasync.com (Postfix) with ESMTP id 7F4BD458006 for ; Wed, 7 Nov 2012 20:16:50 -0700 (MST) Message-ID: <509B241C.1080108@boreham.org> Date: Wed, 07 Nov 2012 20:16:44 -0700 From: David Boreham User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20121026 Thunderbird/16.0.2 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: HT on or off for E5-26xx ? References: <5099D5FA.90802@boreham.org> <5099E094.9010703@catalyst.net.nz> <509A631F.2010507@boreham.org> <509AD0AB.5010109@catalyst.net.nz> In-Reply-To: <509AD0AB.5010109@catalyst.net.nz> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201211/103 X-Sequence-Number: 48469 Well, the results are in and at least in this particular case conventional wisdom is overturned. Not a huge benefit, but throughput is definitely higher with HT enabled and nthreads >> ncores: HT off : bash-4.1$ /usr/pgsql-9.2/bin/pgbench -T 600 -j 48 -c 48 starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 100 query mode: simple number of clients: 48 number of threads: 48 duration: 600 s number of transactions actually processed: 2435711 tps = 4058.667332 (including connections establishing) tps = 4058.796309 (excluding connections establishing) avg-cpu: %user %nice %system %iowait %steal %idle 52.50 0.00 14.79 5.07 0.00 27.64 Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util sda 0.00 5700.30 0.10 13843.50 0.00 74.78 11.06 48.46 3.50 0.05 65.21 HT on: bash-4.1$ /usr/pgsql-9.2/bin/pgbench -T 600 -j 48 -c 48 starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 100 query mode: simple number of clients: 48 number of threads: 48 duration: 600 s number of transactions actually processed: 2832463 tps = 4720.668984 (including connections establishing) tps = 4720.750477 (excluding connections establishing) avg-cpu: %user %nice %system %iowait %steal %idle 40.61 0.00 12.71 3.09 0.00 43.59 Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util sda 0.00 6197.10 14.80 16389.50 0.14 86.53 10.82 54.11 3.30 0.05 82.35 System details: E5-2620 (6 core + HT 15Mb LL) 64G (4 channels with 16G 1333 modules), Intel 710 300G (which is faster than the smaller drives, note), Supermicro X9SRi-F Motherboard. CentOS 6.3 64-bit, PG 9.2.1 from the PGDG RPM repository. pgbench running locally on the server.