Re: Six PostgreSQL questions from a pokerplayer

mark@mark.mielke.cc

From: Mark Mielke <mark@mark.mielke.cc>
To: Stephen Frost <sfrost@snowman.net>
Cc: Craig Ringer <craig@postnewspapers.com.au>, Patvs <patvs@chello.nl>, pgsql-performance@postgresql.org
Date: 2009-07-06T19:27:15Z
Lists: pgsql-performance
On 07/06/2009 06:23 AM, Stephen Frost wrote:
> * Craig Ringer (craig@postnewspapers.com.au) wrote:
>    
>> What that does mean, though, is that if you don't have significantly
>> more RAM than a 32-bit machine can address (say, 6 to 8 GB), you should
>> stick with 32-bit binaries.
>>      
>
> I'm not sure this is always true since on the amd64/em64t platforms
> you'll get more registers and whatnot in 64-bit mode which can offset
> the pointer size increases.
>    

Which leads to other things like faster calling conventions...

Even if you only have 4 GB of RAM, the 32-bit kernel needs to fight with 
"low memory" vs "high memory", whereas 64-bit has a clean address space.

All things being equal, I recommend 64-bit.

Cheers,
mark

-- 
Mark Mielke<mark@mielke.cc>