Fine-tuning PostgreSQL requires a lot of experience and screw-ups along the way. Luckily, there is a configuration calculator available online made just for DevOps, SysOps and DB admins which could be quite handy.
Prerequisites
- PostgreSQL
Solution
Step 1. Open the PostgreSQL configuration calculator in a web browser: https://pgtune.leopard.in.ua.
Step 2. Enter parameter values based on your DB version, OS type, DB type, data storage and other server specifications. For instance:
Step 3. Click Generate.
Step 4. On the right side of the screen, you’ll get the calculated PostgreSQL settings.
Step 5. From here, you could either overwrite the postgresql.conf settings and restart the PostgreSQL service or use a query-based approach with ALTER SYSTEM SET.
Conclusion
Really awesome and practical tool, plus it might save you a lot of time, headaches and frustrations. Feel free to leave a comment below and if you find this tutorial useful, follow our official channel on Telegram.