pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gavin Flower <GavinFlower@archidevsys.co.nz>
To: Craig James <cjames@emolecules.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Two identical systems, radically different performance
Date: Tue, 09 Oct 2012 12:52:28 +1300
Message-ID: <5073673C.10905@archidevsys.co.nz> (raw)
In-Reply-To: <CAFwQ8rcyCKcoeEn62_QHMRSmJM03ULERtW6_R=3TaO0twOEV9A@mail.gmail.com>
References: <CAFwQ8rcvw4mSoJ9q+ouONCeB9dg1T9gAUV5J27MpVZrehRHayQ@mail.gmail.com>
	<CAFwQ8rfm2AcuoFHDfBLA_hg7ffbsYNsrsaJPDqcOeGqaVW02OQ@mail.gmail.com>
	<CAFwQ8rcyCKcoeEn62_QHMRSmJM03ULERtW6_R=3TaO0twOEV9A@mail.gmail.com>

On 09/10/12 12:40, Craig James wrote:
> Nobody has commented on the hyperthreading question yet ... does it 
> really matter? The old (fast) server has hyperthreading disabled, and 
> the new (slower) server has hyperthreads enabled.
>
> If hyperthreading is definitely NOT an issue, it will save me a trip 
> to the co-lo facility.
>
> Thanks,
> Craig
>
> On Mon, Oct 8, 2012 at 3:29 PM, Craig James <cjames@emolecules.com 
> <mailto:cjames@emolecules.com>> wrote:
>
>     One mistake in my descriptions...
>
>     On Mon, Oct 8, 2012 at 2:45 PM, Craig James <cjames@emolecules.com
>     <mailto:cjames@emolecules.com>> wrote:
>
>         This is driving me crazy.  A new server, virtually identical
>         to an old one, has 50% of the performance with pgbench.  I've
>         checked everything I can think of.
>
>         The setups (call the servers "old" and "new"):
>
>         old: 2 x 4-core Intel Xeon E5620
>         new: 4 x 4-core Intel Xeon E5606
>
>
>     Actually it's not 16 cores.  It's 8 cores, hyperthreaded.
>     Hyperthreading is disabled on the old system.
>
>     Is that enough to make this radical difference?  (The server is at
>     a co-location site, so I have to go down there to boot into the
>     BIOS and disable hyperthreading.)
>
>     Craig
>
>
My latest development box (Intel Latest Core i7 3770K Ivy Bridge Quad 
Core with HT 3.4GHz) has hyperthreading - and it *_does_* make a 
significant difference.

Cheers,
Gavin

view thread (47+ messages)  latest in thread

Message-ID: <5073673C.10905@archidevsys.co.nz>
Permalink:  ../5073673C.10905@archidevsys.co.nz/
Also on:    postgresql.org/message-id/5073673C.10905@archidevsys.co.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: GavinFlower@archidevsys.co.nz, cjames@emolecules.com
  Subject: Re: Two identical systems, radically different performance
  In-Reply-To: <5073673C.10905@archidevsys.co.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