Message-ID: <448E79F4.1060303@superlativ.dk>
Date: Tue, 13 Jun 2006 10:40:20 +0200
From: Nis Jorgensen <nis@superlativ.dk>
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
To: "J. Andrew Rogers" <jrogers@neopolitan.com>
CC: "Pgsql-Performance ((E-mail))" <pgsql-performance@postgresql.org>
Subject: Re: 64-bit vs 32-bit performance ... backwards?
References: <1150151282.14661.42.camel@tigger>
	<54CA6A16-AB42-440D-B5DB-BC43AE283ED8@blighty.com>
	<448E11B1.20309@commandprompt.com>
	<31554317-AD3E-4D08-92DC-7958E46A0D47@neopolitan.com>
In-Reply-To: <31554317-AD3E-4D08-92DC-7958E46A0D47@neopolitan.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

J. Andrew Rogers wrote:

> We have been using PostgreSQL on Opteron servers almost since the
> Opteron was first released, running both 32-bit and 64-bit versions of
> Linux.  Both 32-bit and 64-bit versions have been bulletproof for us,
> with the usual stability I've become accustomed to with both PostgreSQL
> and Linux.  We have been running nothing but 64-bit versions on
> mission-critical systems for the last year with zero problems.
> 
> The short story is that for us 64-bit PostgreSQL on Opterons is
> typically something like 20% faster than 32-bit on the same, and *much*
> faster than P4 Xeon systems they nominally compete with. 

Since you sound like you have done extensive testing:

Do you have any data regarding whether to enable hyperthreading or not?
I realize that this may be highly dependant on the OS, application and
number of CPUs, but I would be interested in hearing your
recommendations (or others').

/Nis