A J <s5aly@yahoo.com> wrote:
> Cost aside, are there any technical factors to consider before
> increasing RAM (assuming the system can support it) ? Is there a
> sweet spot beyond which more RAM does not help Postgres or
> actually harms ?
I've never heard of putting more RAM in a machine hurting
performance, as long as it's the right type of RAM for that machine.
On the other hand, you can easily configure PostgreSQL to allocate
more RAM for specific purposes than is good.
> If my database is only couple of hundred Gigs, can I not just have
> RAM that big and have read from buffer all the time ?
Sure, as long as you allow enough extra for the OS and all other
processes. If you're looking at hundreds of GB of RAM on a box,
plan on letting the OS use the vast majority of that for caching.
This doesn't obviate the need for a RAID controller with its own BBU
RAM if you want write performance to be good.
-Kevin
