From: Chris Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: please comment on cpu 32 bit or 64 bit
Date: Sat, 10 Sep 2005 01:21:09 -0400
Message-ID: <608xy5sdkq.fsf@dba2.int.libertyrms.com> (raw)
References: <BAY18-F240F4C982FB31A6BF45898BE980@phx.gbl>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: please comment on cpu 32 bit or 64 bit
In-Reply-To: <608xy5sdkq.fsf@dba2.int.libertyrms.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox