Обсуждение: REQUIREMENTS FOR POSTGRESQL DATABASE
Hello,
I just need the information related to the requirements of postgresql database like how much size it occupies on the disk (when it is installed) irrespective of tables size and how much RAM is needed for better performance of the database say, I have 4gb ram will it use all the 4gb ram or 2gb is sufficient in terms of usage and performance issues.
Thank You,
Aravind.
I just need the information related to the requirements of postgresql database like how much size it occupies on the disk (when it is installed) irrespective of tables size and how much RAM is needed for better performance of the database say, I have 4gb ram will it use all the 4gb ram or 2gb is sufficient in terms of usage and performance issues.
Thank You,
Aravind.
In the future could you please refrain from using caps in your subject line. It looks like you are screaming.
thx
aravind chandu wrote: > Hello, > > I just need the information related to the requirements of postgresql > database like how much size it occupies on the disk (when it is > installed) irrespective of tables size and how much RAM is needed for > better performance of the database say, I have 4gb ram will it use > all the 4gb ram or 2gb is sufficient in terms of usage and > performance issues. > > Thank You, Aravind. > My install takes up about 33MB - depending on what options and any add-ons like slony or postgis that you may add can increase that. Your data can use many TB of disk space if you have the data and the space for it. RAM usage will depend on your system - 32 bit versions will max out a little short of 4GB (I think it is about 2.5GB), you will need a 64 bit system and postgresql binaries to use more RAM than that. Whether postgresql can make use of that much RAM will depend on how you configure postgresql, how many concurrent connections will be running and whether your data is large enough to take advantage of it. If you have some estimates on the size of your db (number of tables, columns in each, expected number of rows, concurrent users, types of queries) then you may get some guesses about whether 2 or 4 GB will suit your situation. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz