Calculate PostgreSQL configuration

Dec 19, 2021 · 1 min read · Post a comment

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.


  • PostgreSQL


Step 1. Open the PostgreSQL configuration calculator in a web browser:

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.


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.