Boosting Azure Database for PostgreSQL Performance with Azure Advisor
summary
Shows how Azure Advisor plus alerts and action groups detects and fixes real PostgreSQL failures on Azure Database for PostgreSQL - Flexible Server: set up an Azure Advisor alert to email when a recommendation fires, then follow the troubleshooting guides to adjust max_wal_size, run pg_terminate_backend() on transactions running >24 hours, or perform vacuum freeze on high‑bloat tables. Triggers include inactive replication slots, checkpoints caused by small max_wal_size, bloat >80%, wraparound nearing 1 billion XIDs, and sustained CPU >90% for 2+ hours.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 1:37Azure Advisor
- 2:28DEMO – Azure Advisor Alerts
- 7:29Azure Advisor Performance Recommendations
- 13:19DEMO – How to find performance recommendations in Azure Advisor
- 16:49More Azure Advisor Performance Recommendations
- 26:12Conclusion
related talks
23mHow we keep Azure Database for PostgreSQL free of bloat to maximize disk space
28mAutotuning PostgreSQL on Azure Flexible Server
26mWhat Enterprises like about Azure Database for PostgreSQL - Flexible Server
50mUnleashing the Power of Azure for PostgreSQL
32mWhat makes Azure Database for PostgreSQL Great for Developers?
56mSeamless Migration to Azure Database for PostgreSQL
24mAll The Postgres Things at Microsoft, POSETTE edition
57mDeveloping powerful and intelligent apps using the Azure managed PostgreSQL service