Date: 2016-09-15
Time: 14:00 - 14:50
Room: Dallas 1 & 2
Level: Intermediate
If you are running mission critical application that depends on Postgres database, you understand the need for setting up monitoring Postgres. any kind of disruption and/or performance impact of databases can seriously impact your business. In the market, a plenty of open source and commercial monitoring solutions available so it makes difficult to choose the right solution. Additionally, Postgres provides various object statistics, availability & performance metrics using different system catalog views.
In the talk, we will cover following topics: * What to look for monitoring solutions in general? * Comparison of couple of open source and commercial monitoring solutions * Which metrics to collect and how? * Which metrics to alert on and how to define thresholds? * How to keep up with monitoring changes ? * How to react on alerts at 3AM?