From: Chris Browne <cbbrowne@acm.org>
Subject: Re: please comment on cpu 32 bit or 64 bit
Date: Sat, 10 Sep 2005 01:21:09 -0400
Organization: cbbrowne Computing Inc
Lines: 29
Message-ID: <608xy5sdkq.fsf@dba2.int.libertyrms.com>
References: <BAY18-F240F4C982FB31A6BF45898BE980@phx.gbl>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.17 (Jumbo Shrimp, linux)
Cancel-Lock: sha1:53+3N/VtP//qA6YVWql632/B58g=
To: pgsql-performance@postgresql.org

maccran@hotmail.com ("wisan watcharinporn") writes:
> please help me ,
> comment on postgresql (8.x.x) performance on cpu AMD, INTEL
> and why i should use 32 bit or 64 cpu ? (what the performance difference)

Generally speaking, the width of your I/O bus will be more important
to performance than the width of the processor bus.

That is, having more and better disk will have more impact on
performance than getting a better CPU.

That being said, if you plan to have a system with significantly more
than 2GB of memory, there seem to be pretty substantial benefits to
the speed of AMD memory bus access, and that can be quite significant,
given that if you have a lot of memory, and thus are often operating
out of cache, and are slinging around big queries, THAT implies a lot
of shoving data around in memory.  AMD/Opteron has a way faster memory
bus than the Intel/Xeon systems.

But this is only likely to be significant if you're doing processing
intense enough that you commonly have >> 4GB of memory in use.

If not, then you'd better focus on I/O speed, which is typically
pretty independent of the CPU...
-- 
(format nil "~S@~S" "cbbrowne" "ntlug.org")
http://www.ntlug.org/~cbbrowne/rdbms.html
"Anyway I know how to not be bothered by consing on the fly."
-- Dave Moon