On 3/17/11 9:42 AM, J Sisson wrote:
> On Thu, Mar 17, 2011 at 10:13 AM, Jeff<threshar@torgo.978.org> wrote:
>> hey folks,
>>
>> Running into some odd performance issues between a few of our db boxes.
> We've noticed similar results both in OLTP and data warehousing conditions here.
>
> Opteron machines just seem to lag behind *especially* in data
> warehousing. Smaller
> cache for sorting/etc... is what I'd always chalked it up to, but I'm
> open to other theories
> if they exist.
We had a similar result with a different CPU-intensive open-source package, and discovered that if we compiled it on
theOpteron it ran almost twice as fast as binaries compiled on Intel hardware. We thought we could compile once, run
everywhere,but it's not true. It must have been some specific optimization difference between Intel and AMD that the
gcccompiler knows about. I don't know if that's the case here, but it's a thought.
Craig