Dear Azure Database for PostgreSQL, can you automate my index?
summary
Azure Database for PostgreSQL Flexible Server claims to auto-tune indexes by scanning Query Store and emitting create index and drop index recommendations hourly by default, with a demo showing portal, CLI (postgres flexible-server index-tuning list-recommendations returns JSON), and Visual Studio Code for applying scripts. The system estimates per-query improvement (configurable minimum ~20%) and max regression (configurable ~10%), reports index size savings, tracks sessions, and requires DB access to retrieve PII query text.
AI-written summary · about
chapters (10)
- 0:00Introduction - Automatic Index Tuning in Azure Database for PostgreSQL
- 2:25What is Index Tuning - Process and Benefits Overview
- 4:30Azure Database for PostgreSQL Context and Features
- 5:27Key Features of Automatic Index Tuning
- 9:05DEMO - Configuring Index Tuning via Portal and CLI
- 13:16Understanding Index Recommendations - Create and Drop Types
- 17:16Index Tuning Settings
- 19:37Applying Index Tuning Recommendations using your IDE
- 24:22Value Proposition of Automatic Index Tuning
- 26:50Conclusion and Future Roadmap
related talks
28mAutotuning PostgreSQL on Azure Flexible Server
23mHow we keep Azure Database for PostgreSQL free of bloat to maximize disk space
34mData modeling for those who want to save time and money!
32mWhat makes Azure Database for PostgreSQL Great for Developers?
50mUnleashing the Power of Azure for PostgreSQL
26mUsing Azure Query Store to Understand PostgreSQL Performance
26mWhat Enterprises like about Azure Database for PostgreSQL - Flexible Server
26mTop 10 reasons to choose Flexible Server for Azure Database for PostgreSQL