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
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
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?
In response to
pgsql-performance by date
|Next:||From: James Mansion||Date: 2009-01-27 06:37:39|
|Subject: Re: SSD performance|
|Previous:||From: david||Date: 2009-01-27 03:59:44|
|Subject: Re: [PERFORMANCE] Buying hardware|