New server and want a basic config for a production server? (I'm assuming brand new app here, no prior monitoring and knowledge on what to tune.) Use this to g

New server and want a basic config for a production server? (I'm assuming brand new app here, no prior monitoring and knowledge on what to tune.) Use this to get the values you need https://pgtune.leopard.in.ua/#/ https://pgtune.leopard.in.ua/#/ . This saved me a lot of headaches, and it just gets the server into a good enough state from which you can observe and optimise later. I'd also add in monitoring early, add a Prometheus exporter https://github.com/prometheus-community/postgres_exporter https://github.com/prometheus-community/postgres_exporter and alerts https://awesome-prometheus-alerts.grep.to/rules#postgresql https://awesome-prometheus-alerts.grep.to/rules#postgresql . There are a few Grafana dashboards available for the prometheus exporter, start with those.