Currently PMM have issues with collecting per-database metrics from PostgreSQL, because it creates 1 connection per DB and keeps connection. We improved behaviour in PMM 2.40.1 and 2.41.0 by providing limit to disable autodiscovery feature, but still need some improvements.
Because of how PostgreSQL implemented each connection to DB starts new process which affects on the performance
How to test
--
How to document
New parameter `--max-connections=10` was added to `pmm-admin` command, which controls how many connection postgres exporter can open.
Currently PMM have issues with collecting per-database metrics from PostgreSQL, because it creates 1 connection per DB and keeps connection. We improved behaviour in PMM 2.40.1 and 2.41.0 by providing limit to disable autodiscovery feature, but still need some improvements.
Because of how PostgreSQL implemented each connection to DB starts new process which affects on the performance