Monitoring Managed Postgres, the OSS Way
Friday, October 24 at 11:25–12:15
Room: Beta
Level: Intermediate
Observing and analyzing PostgreSQL behavior to identify performance bottlenecks is a key feature for a managed Postgres offering. In this talk, we will walk through a simple yet powerful setup to monitor PostgreSQL server performance in a managed cloud offering, based on open-source tools like postgres_exporter, VictoriaMetrics and Grafana. Using this setup, we will explore a methodology to decide which OS and Postgres metrics matter most, along with key signals to use for alerting. Lastly, we will go through some examples on how to investigate performance issues, with a focus on some new areas of adoption like vector storage.
