A J <s5aly@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
