Question
Can I "tune" my instance to my needs?
Some of my Postgres needs are different from others. Sometimes I need a Postgres cluster for web application purposes, which means lots of connections each with limited cpu and memory needs. Other times, I may need a Postgres cluster for analytical purposes, which means fewer connections each with greater cpu and memory access.
Typically, when managing this infrastructure on my own, I would modify default values for sharedbuffers, effectivecachesize, maintenanceworkmem, workmem etc. to suit my specific needs. I am wondering if it is possible to manage the configuration in Digital Ocean’s managed Postgres clusters. Thanks!