Our great sponsors
-
If you are using rails, pghero is a great gem to get better visibility on your Postgres performance
-
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/#/ .
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 and alerts https://awesome-prometheus-alerts.grep.to/rules#postgresql . There are a few Grafana dashboards available for the prometheus exporter, start with those.
-
SonarLint
Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
