From: Shaun Thomas <sthomas@optionshouse.com>
To: Evgeny Shishkin <itparanoia@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: M. D. <lists@turnkey.bz>
Cc: Craig James <cjames@emolecules.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: hardware advice
Date: Thu, 27 Sep 2012 16:20:33 -0500
Message-ID: <5064C321.5080204@optionshouse.com> (raw)
In-Reply-To: <FEEF9188-78D9-4725-8796-77FAA71AAE3F@gmail.com>
References: <5064A4DC.5090304@turnkey.bz>
<CAFwQ8rf4Cnt9Ksd+3GbkkWtZ3NM+hYukd1gKRLmsihXnKzVteA@mail.gmail.com>
<5064BB1E.4090904@turnkey.bz>
<CAOR=d=02nGu3fMppkVZWeiDYOpWrXi1PT2ZSxx-fZ+Uxp2WuOw@mail.gmail.com>
<5064BEA6.3000506@optionshouse.com>
<FEEF9188-78D9-4725-8796-77FAA71AAE3F@gmail.com>
On 09/27/2012 04:08 PM, Evgeny Shishkin wrote:
> from benchmarking on my r/o in memory database, i can tell that 9.1
> on x5650 is faster than 9.2 on e2440.
How did you run those benchmarks? I find that incredibly hard to
believe. Not only does 9.2 scale *much* better than 9.1, but the E5-2440
is a 15MB cache Sandy Bridge, as opposed to a 12MB cache Nehalem.
Despite the slightly lower clock speed, you should have much better
performance with 9.2 on the 2440.
I know one thing you might want to check is to make sure both servers
have turbo mode enabled, and power savings turned off for all CPUs.
Check the BIOS for the CPU settings, because some motherboards and
vendors have different defaults. I know we got inconsistent and much
worse performance until we made those two changes on our HP systems.
We use pgbench for benchmarking, so there's not anything I can really
send you. :)
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@optionshouse.com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
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: sthomas@optionshouse.com, itparanoia@gmail.com, scott.marlowe@gmail.com, lists@turnkey.bz, cjames@emolecules.com
Subject: Re: hardware advice
In-Reply-To: <5064C321.5080204@optionshouse.com>
* 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