Dynamic recommendation system for PostgreSQL database configuration

The main dream of any DataOps / DBA which is working with PostgreSQL database is doing nothing and just monitor main metrics on dashboard. If something wrong with one of metrics need to push a magic button and … everything return to a normal way.

Aleksander decided to make easy life for data-engineer. His solution recommends which PostgreSQL parameters need to be tuned during DB high-loading. From other side, also there is a possibility to provide a control on automatisation level.

Just take a look on comparisons between configurations.

The IT architecture of Alexander’s project looks like below.

Leave a Reply