Monitoring PostgreSQL: Navigating the Landscape of Metrics, OS and Hardware Relationships, and Toolsets
Presented by:
Charly Batista
Charly is the PostgreSQL Tech Lead at Percona and is passionate about databases and performance. He has been working with databases and development for over 20 years and has participated in many projects, from the design of a small sensor to count how many times a ball passes through a basketball hoop to complex database proxy applications.
Outside work, he loves sports, as a good Brazilian he practices football (or soccer), volleyball, and surprisingly ping-pong. Charly is also passionate about new cultures, their languages, and traditions, and has lived and/or worked in a few different countries. Today he basically lives between Brazil and China. Not really in between, but stays some time in Brazil and some time in China :D
In the dynamic landscape of PostgreSQL management, robust monitoring is the cornerstone of maintaining a healthy and performant Postgres environment. This talk delves deep into the intricacies of PostgreSQL monitoring, addressing fundamental questions: What are the most crucial aspects to monitor within the database? How do these metrics relate to the underlying operating system? And, in a market flooded with choices, how do commercial tools stack up against their open-source counterparts?
By the end of this talk, attendees will gain a comprehensive understanding of the critical metrics essential for PostgreSQL monitoring, the symbiotic relationship with the operating system, insights on open-source monitoring tools and actionable insights to enhance your monitoring strategy.
- Date:
- 2024 April 18 15:10 PDT
- Duration:
- 50 min
- Room:
- San Pedro
- Conference:
- Postgres Conference 2024
- Language:
- English
- Track:
- Ops
- Difficulty:
- Intermediate