How not to miss scalability and performance issues in Postgres databases: automated database health checks
More than 17 years of experience with various DBMSes, more than 13 years with PostgreSQL. M.S., MIPT and ISP RAS, specialty "Database systems".
Founder of Postgres.ai (data-driven Postgres management, artificial DBAs, automation of DBA tasks. We do deep health checks of large DBs during just 4 hours instead of 2 weeks).
Founder of #RuPostgres (PostgreSQL user group for Russian-speaking users, 2nd on Meetup.com, 2000+ members).
Committee Chair of program committees of various conferences: PGIBZ, Highload++, RIT/BackendConf, PgDay.ru.
Russian press contact at PostgreSQL Global Development Group.
No video of the event yet, sorry!
Full-fledged health check of heavily loaded multi-terabyte production database usually takes many days of expert work. With postgres-checkup, it takes just a few hours.
postgres-checkup is a new approach to survive in the era of clouds, microservices, and rapid transformation of DBA profession. Among its key features are:
☞ close-to-zero footprint (risks of the "observer effect" are mitigated);
☞ "zero install": nothing needs to be installed on Postgres servers;
☞ reporting formats are both human- and machine-friendly (JSON, markdown, HTML, PDF).
We will discuss how you can quickly perform health check without deep internals knowledge, diving into the following topics:
☞ autovacuum & bloat;
☞ indexes health;
☞ deep query analysis.
- 2019 June 21 - 11:30
- 50 min
- PostgreSQL Ibiza
- Track 2
- Living in GDPR world
- Start Time:
- 2019 June 21 11:30