I prefer to run PostgreSQL The Grumpy Greybeard Way.
Like, on a (virtual) machine.
With a config file.
I'm doing a web app with terabytes of healthcare data with intense computation and geospatial queries with an average 60ms response time including latency.
On a modest vm.
With a config file.