Re: Two identical systems, radically different performance - Mailing list pgsql-performance

From Craig James
Subject Re: Two identical systems, radically different performance
Date
Msg-id CAFwQ8rcyCKcoeEn62_QHMRSmJM03ULERtW6_R=3TaO0twOEV9A@mail.gmail.com
Whole thread Raw
In response to Re: Two identical systems, radically different performance  (Craig James <cjames@emolecules.com>)
Responses Re: Two identical systems, radically different performance  (Shaun Thomas <sthomas@optionshouse.com>)
Re: Two identical systems, radically different performance  (David Thomas <david@digitaldogma.org>)
Re: Two identical systems, radically different performance  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Re: Two identical systems, radically different performance  (Ants Aasma <ants@cybertec.at>)
Re: Two identical systems, radically different performance  (Andrea Suisani <sickpig@opinioni.net>)
List pgsql-performance
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> wrote:
One mistake in my descriptions...

On Mon, Oct 8, 2012 at 2:45 PM, Craig James <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

pgsql-performance by date:

Previous
From: Evgeny Shishkin
Date:
Subject: Re: Two identical systems, radically different performance
Next
From: Yeb Havinga
Date:
Subject: Re: Two identical systems, radically different performance