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
signature.asc
Description: This is a digitally signed message part.
