From: David Boreham <david_list@boreham.org>
To: pgsql-performance@postgresql.org
Subject: Re: HT on or off for E5-26xx ?
Date: Fri, 09 Nov 2012 07:34:13 -0700
Message-ID: <509D1465.3050500@boreham.org> (raw)
In-Reply-To: <509BBF47.7090905@boreham.org>
References: <5099D5FA.90802@boreham.org>
<5099E094.9010703@catalyst.net.nz>
<509A631F.2010507@boreham.org>
<509AD0AB.5010109@catalyst.net.nz>
<509B241C.1080108@boreham.org>
<509BBA87.3090400@optionshouse.com>
<509BBF47.7090905@boreham.org>
Here are the SELECT only pgbench test results from my E5-2620 machine,
with HT on and off:
HT off:
bash-4.1$ /usr/pgsql-9.2/bin/pgbench -T 600 -j 48 -c 48 -S
starting vacuum...end.
transaction type: SELECT only
scaling factor: 100
query mode: simple
number of clients: 48
number of threads: 48
duration: 600 s
number of transactions actually processed: 25969680
tps = 43281.392273 (including connections establishing)
tps = 43282.476955 (excluding connections establishing)
All 6 cores saturated:
avg-cpu: %user %nice %system %iowait %steal %idle
81.42 0.00 18.21 0.00 0.00 0.37
HT on:
bash-4.1$ /usr/pgsql-9.2/bin/pgbench -T 600 -j 48 -c 48 -S
starting vacuum...end.
transaction type: SELECT only
scaling factor: 100
query mode: simple
number of clients: 48
number of threads: 48
duration: 600 s
number of transactions actually processed: 29934601
tps = 49888.697225 (including connections establishing)
tps = 49889.570754 (excluding connections establishing)
12% of CPU showing as idle (whether that's true or not I'm not sure):
avg-cpu: %user %nice %system %iowait %steal %idle
71.09 0.00 16.99 0.00 0.00 11.92
So for this particular test HT gives us the equivalent of about one
extra core.
It does not reduce performance, rather increases performance slightly.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: david_list@boreham.org
Subject: Re: HT on or off for E5-26xx ?
In-Reply-To: <509D1465.3050500@boreham.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox