Re: HT on or off for E5-26xx ?

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: HT on or off for E5-26xx ?
Date: 2012-11-07 21:20:43
Message-ID: 509AD0AB.5010109@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rodrigo Rosenfeld Rosas 2012-11-07 21:38:12 Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2
Previous Message Claudio Freire 2012-11-07 21:18:06 Re: How to upgrade from 9.1 to 9.2 with replication?