PostgreSQL DBA's Troubleshooting Toolkit: Unraveling Complex Issues with Expertise.
PostgreSQL DBA's Troubleshooting Toolkit
Presented by:
Lalit Choudhary
from
PurnaBIT
For over 15 years, my career has revolved around a passion for database internals and reliability, with hands-on roles spanning DBA work, QA, and testing. Through my contributions at Percona and with Oracle MySQL, I've been deeply involved in the PostgreSQL and MySQL ecosystems. This journey is driven by a mission to empower the community and help enterprises unlock the full potential of open-source database projects.
Checkout the slides
Objective: From this topic, DBA should know how to approach if they are looking for testing, reproducing issues, Health checks, and monitoring for PostgreSQL.
Talk abstract:
- Introduction: The significance of testing and monitoring tools and why DBA needs them.
- Obstacles: Testing environment Provisioning, Time-consuming, and Monetary cost.
- Solution: Utilizing opensource tools and virtualization options for quick setups and tests: Docker, Lxc, Vagrant, etc.
- The best and fastest way to setup complex PostgreSQL setups like PostgreSQL replication, Patroni Cluster, and Kubernetes Operator environment for PostgreSQL using an opensource tool called Anydbver(Developed and Maintained by Percona engineer) https://github.com/ihanick/anydbver
- Things to monitor for good performance, Current vs. Historical data analysis
- Monitoring Tools: pg_gather(https://github.com/jobinau/pg_gather), PMM [with use cases and examples]
- Date:
- 2024 March 1 - 11:35
- Duration:
- 40 min
- Room:
- Grand Victoria B
- Conference:
- PGConf India, 2024
- Language:
- Track:
- Database Administration
- Difficulty:
- Medium
- PostgreSQL I/O Patterns
- Start Time:
- 2024 March 1 11:35
- Room:
- Robusta + Arabica
- PostgreSQL 16: What's New? A comprehensive overview of the Latest Features
- Start Time:
- 2024 March 1 11:35
- Room:
- Grand Victoria A