Re: Xeon twice the performance of opteron

On 3/17/11 9:42 AM, J Sisson wrote:
> On Thu, Mar 17, 2011 at 10:13 AM, Jeff<threshar(at)torgo(dot)978(dot)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 the Opteron 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 gcc compiler knows about. I don't know if that's the case here, but it's a thought.

Craig