Search Postgresql Archives

Re: 64bits or 32 bits on ESX?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

Attachment: signature.asc
Description: This is a digitally signed message part.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux