Postgres Professional is a Russian vendor of PostgreSQL DBMS. It was founded in 2015 by leading Russian developers of PostgreSQL. Three of co-founders are PostgreSQL major contributors. More than 90 patches from Postgres Professional employees have been approved for the latest PostgreSQL 10.0 release.
Cases for monitoring & troubleshooting at highload PosgreSQL DB
A database is one of the key components in any information system, requiring the monitoring of multiple metrics. The talk highlights examples and approaches of monitoring and analysis of PostgreSQL performance that allow to minimize the load on the database server from the monitoring and data collection system for the subsequent analysis of problem situations.
- Quantum effects or as an observer affect the observed system
- Features of collecting metrics while monitoring the database with Zabbix
- Data collection for analytics and visualization PostgreSQL queries with rsyslog + kafka + clickhouse + grafana
- Operational Analysis Tools for DB loglile
Program All talks