On Thursday 21 January 2010 13.01:29 Magnus Hagander wrote:
> > Really? With ONLY 2Gb? Why? What is the performance improvement, with
> > 64Bit all pointers and so on needs more memory so i'm expecting lesser
> > memory for the data.
>
I'm not in any way a performance expert, but IIRC 32 bit Linux has to use
some quirky logic (HIGHMEM) to address more than 2G physical memory, which
might reduce performance somewhat. So 2G is fine, but ...
Aside of memory: if performance is an issue, and assuming your db is bigger
than available memory: have you thought about the physical disk layout?
Having indices on different disks (physical disks matter, here!) from data,
splitting WAL from tablespaces etc. might all be much more important for
your performance than the 32bit vs. 64bit issue.
cheers
-- vbi