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

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

    image



    Back in 2008, Gregory Smith created a good pgtune utility . The main task of this utility was to help beginners with the initial configuration of PostgreSQL. The utility is excellent, but has some minor disadvantages:

    • Not updated since 2009 (therefore, calculations have become a little outdated)
    • Need to download or install from packages (not a problem, in many Linux distributions it is)


    So I created an online version of PgTune . The main advantages:

    • Updated config count
    • No need to put or download anything
    • It works offline, and because of this it can be used as a mobile app


    At the first boot, you no longer need access to the Internet (only for updates) in order to use the utility. This is also implemented 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”.

    Well and most importantly - the Open Source utility .

    In conclusion, I want to warn that this utility is not a "silver bullet" in the configuration and tuning of 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 the queries, so it is possible to optimally configure the database only taking into account all the parameters of the system and application (for example, consider SSD drives and whether the database fits into memory). But I hope this utility helps you get started setting up PostgreSQL.

    Thanks for attention. Use on health.

    Also popular now: