postgresql,

Calculate PostgreSQL configuration

Dec 19, 2021 · 1 min read · Post a comment
Calculate PostgreSQL configuration

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:
postgresql-calculator-config

Step 3. Click Generate.

Step 4. On the right side of the screen, you’ll get the calculated PostgreSQL settings.
postgresql-calculator-result

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.