Nikolay Samokhvalov (Nombox) delivers the talk, "Automated DBA", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.
postgres_dba (https://github.com/NikolayS/postgres_dba) - is a brand new open source DBA tool set, which can be used by any application developer to find database issues possible solutions much faster.
In this talk, we'll discuss why is it important to have proper tools to analyze database health, and why DBA's work very often looks like black magic.
Taking PostgreSQL as an example (including its managed cloud versions like Heroku Postgres or AWS RDS Postgres), we'll discuss what should be done to make DBA's tasks of maintaining and optimizing databases more efficient and automated.
We'll cover these topics:
- controlling sizes of tables and indexes;
- controlling bloat level and autovacuum;
- index set optimization;
- major disadvantages of current approaches to group slowest queries;
- using machine learning to find, analyze slowest and optimize slowest queries iteratively.
PostgreSQL High-Performance Tuning and Optimization
Why PostgreSQL Is Becoming A Migration Target For Enterprise
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
PostgreSQL WAL and Commit Synchronization, Optimization Opportunities - Jobin Augustine - PLO October 2020