PgTune - PostgreSQL performance tuning for a given hardware configuration (online version)

Good afternoon, habrovchane. Today I want to talk about such an interesting thing as PgTune.




')
Back in 2008, Gregory Smith created a good pgtune utility. The main objective of this utility was to help beginners with the initial PostgreSQL setup. The utility is excellent, but it has some minor drawbacks:

• Not updated since 2009 (so the calculations have become a bit irrelevant)
• Need to download or install from packages (no problem, in many Linux distributions it is)

Therefore, I created an online version of PgTune . Main advantages:

• Config calculation updated
• No need to put or swing
• It works in offline mode, and because of this it can be used as a mobile app.

When you first download more you will not need access to the Internet (only for updates) to use the utility. Implemented this using AppCache technology. To put it as an application on your mobile, just go to iOS Safari or Chrome Android and select the menu item “Add to desktop”.

And most importantly - the Open Source utility.

In conclusion, I want to warn you that this utility is not a “silver bullet” in tuning and tuning PostgreSQL. Many settings depend not only on the hardware configuration, but also on the size of the database, the number of clients and the complexity of requests, so that optimally adjusting the database is possible only taking into account all the parameters of the system and the application (for example, consider SSD drives and whether the database fits into memory). But I hope this utility will help start PostgreSQL setup.

Thanks for attention. Use on health.