From: Greg Smith <greg@2ndquadrant.com>
To: Yeb Havinga <yebhavinga@gmail.com>
Cc: Jose Ildefonso Camargo Tolosa <ildefonso.camargo@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Performance on new 64bit server compared to my 32bit desktop
Date: Tue, 31 Aug 2010 11:43:41 -0400
Message-ID: <4C7D232D.6030802@2ndquadrant.com> (raw)
In-Reply-To: <4C7CF886.5040603@gmail.com>
References: <4C6CE64D.6070104@edd.fr>
<4C6D76FE.9010407@2ndquadrant.com>
<E613263E-09D5-4562-BBAF-C72B09883E26@richrelevance.com>
<4C77F4F4.4020900@2ndquadrant.com>
<AANLkTikd3BjGD+ti2RBrYu-2WJ7f-QM3dcJLMtYKOZUu@mail.gmail.com>
<4C7B6498.5040800@gmail.com>
<4C7BCB2E.3090100@2ndquadrant.com>
<4C7CF886.5040603@gmail.com>
Yeb Havinga wrote:
> The rather wierd dip at 5 threads is consistent over multiple tries
I've seen that twice on 4 core systems now. The spot where there's just
one more thread than cores seems to be the worst case for cache
thrashing on a lot of these servers.
How much total RAM is in this server? Are all the slots filled? Just
filling in a spreadsheet I have here with sample configs of various
hardware.
Yeb's results look right to me now. That's what an AMD Phenom II X4 940
@ 3.00GHz should look like. It's a little faster, memory-wise, than my
older Intel Q6600 @ 2.4GHz. So they've finally caught up with that
generation of Intel's stuff. But my current desktop quad-core i860 with
hyperthreading is nearly twice as fast in terms of memory access at
every thread size. That's why I own one of them instead of a Phenom II X4.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
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: greg@2ndquadrant.com, yebhavinga@gmail.com, ildefonso.camargo@gmail.com
Subject: Re: Performance on new 64bit server compared to my 32bit desktop
In-Reply-To: <4C7D232D.6030802@2ndquadrant.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