Especially these days you can SSH to a baremetal server and just tell Claude to set up Postgres. Job done. You don't need autoscaling because you can afford a server that's 5X faster from the start.

You just use docker.

It is like 4 lines of config for Postgres, the only line you need to change is on which path Postgres should store the data.

You also probably want the Postgres storage on a different (set) of disks.

Maybe change the filesystem?