pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: pgsql-performance@postgresql.org
Subject: Re: HT on or off for E5-26xx ?
Date: Thu, 08 Nov 2012 10:20:43 +1300
Message-ID: <509AD0AB.5010109@catalyst.net.nz> (raw)
In-Reply-To: <509A631F.2010507@boreham.org>
References: <5099D5FA.90802@boreham.org>
	<5099E094.9010703@catalyst.net.nz>
	<509A631F.2010507@boreham.org>

On 08/11/12 02:33, David Boreham wrote:
> On 11/6/2012 9:16 PM, Mark Kirkwood wrote:
>>
>>
>> I've been benchmarking a E5-4640 (4 socket) and hyperthreading off 
>> gave much better scaling behaviour in pgbench (gentle rise and 
>> flatten off), whereas with hyperthreading on there was a dramatic 
>> falloff after approx number clients = number of (hyperthreaded) cpus. 
>> The box is intended to be a pure db server, so we are running with 
>> hyperthreading off.
>
> It looks like this syndrome is not observed on my box, likely due to 
> the much lower number of cores system-wide (12).
> I see pgbench tps increase nicely until #threads/clients == #cores, 
> then plateau. I tested up to 96 threads btw.
>
> We're waiting on more memory modules to arrive. I'll post some test 
> results once we have all 4 memory banks populated.
>
>
>
>

Interesting - I was wondering if a single socket board would behave 
differently (immediately after posting of course)...I've got an i3 home 
system that scales nicely even with hyperthreading on (2 cores, 4 
typerthreads).

Cheers

Mark




view thread (10+ messages)  latest in thread

Message-ID: <509AD0AB.5010109@catalyst.net.nz>
Permalink:  ../509AD0AB.5010109@catalyst.net.nz/
Also on:    postgresql.org/message-id/509AD0AB.5010109@catalyst.net.nz

 · 

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: mark.kirkwood@catalyst.net.nz
  Subject: Re: HT on or off for E5-26xx ?
  In-Reply-To: <509AD0AB.5010109@catalyst.net.nz>

* 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