pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: David Boreham <david_list@boreham.org>
To: pgsql-performance@postgresql.org
Subject: Re: HT on or off for E5-26xx ?
Date: Wed, 07 Nov 2012 20:16:44 -0700
Message-ID: <509B241C.1080108@boreham.org> (raw)
In-Reply-To: <509AD0AB.5010109@catalyst.net.nz>
References: <5099D5FA.90802@boreham.org>
	<5099E094.9010703@catalyst.net.nz>
	<509A631F.2010507@boreham.org>
	<509AD0AB.5010109@catalyst.net.nz>

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.






view thread (10+ messages)  latest in thread

Message-ID: <509B241C.1080108@boreham.org>
Permalink:  ../509B241C.1080108@boreham.org/
Also on:    postgresql.org/message-id/509B241C.1080108@boreham.org

 · 

reply
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: <509B241C.1080108@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