From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: pgsql-performance@postgresql.org
Subject: Re: 64-bit vs 32-bit performance ... backwards?
Date: Mon, 12 Jun 2006 16:16:35 -0700
User-Agent: KMail/1.8
Cc: Anthony Presley <anthony@resolution.com>
References: <1150151282.14661.42.camel@tigger>
In-Reply-To: <1150151282.14661.42.camel@tigger>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200606121616.36009.josh@agliodbs.com>

Anthony,

> I'm curious if anyone can back this up .... or debunk it.  It's about
> the polar opposite of everything I've heard from every other database
> vendor for the past several years, and would be quite an eye-opener for
> me.

I generally see a 20% "free" gain in performance on 64-bit (Opteron, 
actually).  Possibly EDB is still using ICC to compile, and ICC is bad at 
64-bit?

I have seen some applications which failed to gain any performance from 
64-bit, but have never personally dealt with one which was slower.

-- 
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco