PostgreSQL + Chef – Automatically configure based on server RAM
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: shared_buffers = 25% of maximum memory maintenance_work_mem = 10% of… Read More »