On Mon, 26 Jan 2009, David Rees wrote:
And yes, the more memory you can squeeze into the machine, the better,
though you'll find that after a certain point, price starts going up
steeply. Of course, if you only have a 15GB database, once you reach
16GB of memory you've pretty much hit the point of diminishing
returns.
actually, you need more memory than that. besides the data itself you
would want memory for several other things, among them:
1. your OS
2. your indexes
3. you per-request memory allocations (for sorting, etc)
this is highly dependant on your workload (type and number of parallel
requests)
4. 'dead' tuples in your table (that will be cleared by a vaccum, but
haven't been yet)
and probably other things as well.
I don't know how large a database will fit in 16G of ram, but I suspect
it's closer to 8G than 15G.
any experts want to throw out a rule-of-thumb here?
David Lang
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
