PostgreSQL + Chef – Automatically configure based on server RAM

By | November 15, 2013

I was sick of changing shared_buffers, effective_cache_size, maintenance_work_mem, work_mem, SHMMAX, SHMALL each time we’d spin up a new server. So I decided instead to have chef calculate it for me! It takes the available RAM of the server and then calculates each value based on:

The recipe:

Leave a Reply

Your email address will not be published. Required fields are marked *