I am using postgres and on sensible hardware. I've never setup prometheus or grafana though and I'm unlikely to be able to do so any time soon.