I am running PostgreSQL 11 on EC2 instances that can be scaled up and down. Everytime an instance is scaled his memory specs can change. If in my configuration I have for example something like this:
effective_cache_size = 400GB
in case of big instances, if I scale the machine down of course that configuration memory won't work any more blocking the db instance from starting. So a better solution would be something like:
effective_cache_size = 80%
but that won't work. So apart writing lots of different file configurations, is there a way to have a sort of "dynamic" Postgres configuration?