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.