Thread: Resource Requirements
I've got a list of old resource requirements. I want to know how far off they are and if anything crucial is missing. My usual recommendation is "as much as you can afford" so I don't usually deal with real numbers :) RAM: Number of connections * 2MB Disk: Program and Manual 8-15MB Regression Tests 30MB Compiled Source 60-160MB Storage for user data ( as much as you can afford :) Please copy me since I'm not officially on this list. Thanks, Elein ============================================================ elein@varlena.com Varlena, LLC www.varlena.com PostgreSQL Consulting, Support & Training PostgreSQL General Bits http://www.varlena.com/GeneralBits/ ============================================================= I have always depended on the [QA] of strangers.
Elein, > I've got a list of old resource requirements. > I want to know how far off they are and if anything > crucial is missing. My usual recommendation is > "as much as you can afford" so I don't usually deal > with real numbers :) These look very approximate. > RAM: > Number of connections * 2MB That's not a bad recommendation, but not an actual requirement. It really depends on how much sort_mem you need. Could vary from 0.5mb to as much as 256mb per connection, depending on your application. > Disk: > Program and Manual 8-15MB > Regression Tests 30MB > Compiled Source 60-160MB Well, my compiled source takes up 87mb, and the installed PostgreSQL seems to be about 41mb including WAL. Not sure how much the regression tests are. -- --Josh Josh Berkus Aglio Database Solutions San Francisco