Thread: Machine spec 64-bit/32 GB RAM
Hello,
I am looking at a linux machine for a PG install with 32G of RAM. I have never installed on anyting with more than 2 or 3 Gigs before. In order to access that 32 Gigs do I have to use 64 bit OS and PG? Is there any reason not to use a 64 bit? With a 32-bit version of PG can the 32 G of RAM be used for caching?
Many thanks,
David
I am looking at a linux machine for a PG install with 32G of RAM. I have never installed on anyting with more than 2 or 3 Gigs before. In order to access that 32 Gigs do I have to use 64 bit OS and PG? Is there any reason not to use a 64 bit? With a 32-bit version of PG can the 32 G of RAM be used for caching?
Many thanks,
David
On Fri, 21 Dec 2007, David Cotter wrote: > In order to access that 32 Gigs do I have to use 64 bit OS and PG? Yes. You'll be tormented by various things being limited at 2-4 GB on a 32 bit one. > Is there any reason not to use a 64 bit? The only systems I have running 32 bit are because they rely on some closed-source component where I only have that version available. There are some wrapper libraries available to work around some of these situations. Generally, if you're only dealing with open source software, you should be able to get everything running in 64 bits. > With a 32-bit version of PG can the 32 G of RAM be used > for caching? Yes, but you will have to tune things yourself and ignore a lot of the PG folklore aimed at earlier versions+smaller machines. I've collected some guidelines for your sort of situation at http://www.westnet.com/~gsmith/content/postgresql/ ; the first article there suggests how to get the database server to use all your RAM usefully, while the second points out some potential issues with the fact that by default, your Linux installation may be caching >1GB worth of writes, which can cause some performance issues when you have a checkpoint. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
David Cotter wrote: > Hello, > > I am looking at a linux machine for a PG install with 32G of RAM. I have > never installed on anyting with more than 2 or 3 Gigs before. In order > to access that 32 Gigs do I have to use 64 bit OS and PG? Is there any > reason not to use a 64 bit? With a 32-bit version of PG can the 32 G of > RAM be used for caching? There is zero reason not to run PG on 64bit with that configuration. Sincerely, Joshua D. Drake > > Many thanks, > David