Jason Yee (Datadog) delivers the talk, "Monitoring PostgreSQL", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

At Datadog we handle trillions of points of data per day from the thousands of customers that rely on us to monitor their applications and infrastructure. In this session, I'll share how we've scaled PostgreSQL to not only handle the deluge of data but how we've made our PostgreSQL systems more resilient.

I'll also discuss which metrics to watch and how troubleshooting based on those metrics will help you solve problems more quickly. In this session, we will look at a framework for your metrics and how to use it to find solutions to the issues that come up.

We will cover the three types of monitoring data: what to collect, what should trigger an alert (avoiding an alert storm and pager fatigue), and how to follow the resources to find the root causes of problems.

This focus of this session is not tool-specific, so attendees will leave with strategies and frameworks they can implement in environments today regardless of the platforms and tools they use.

Related Videos: Percona Live Sessions, PostgreSQL, Monitoring and Operations, MySQL-related Technologies

Introduction to pg_stat_monitor
PostgreSQL High-Performance Tuning and Optimization
Why PostgreSQL Is Becoming A Migration Target For Enterprise
How To Measure Linux Performance Wrong
SQL Row Store vs Data Warehouse: Which Is Right for Your Application? - Robert Hodges - PLO October 2020
Introducing Kunlun Distributed Database Cluster - David Zhao Wei - Percona Live ONLINE 2020
pg_stat_monitor: A cool extension for better monitoring using PMM - Percona Live Online 2020