Dear Azure Database for PostgreSQL, can you automate my index? | POSETTE: An Event for Postgres 2025

Video of a conference talk highlighting how Azure Database for PostgreSQL - Flexible Server offers a smart and easy way to tune your Postgres indexes and consequently improve the performance of your workloads and reduce your Azure costs. Join me and learn how this managed database service gives you an assistant that automatically monitors, analyzes, and optimizes your indexes based on your database workload—analyzed holistically rather than each query individually. Nacho Alonso Portillo is a senior cloud-minded principal software engineer at Microsoft and architect with experience designing, building and supporting mission critical environments in large organizations. His experience also includes working as a systems programmer, database administrator, network engineer, data protection specialist and system analyst. ► Video bookmarks: ⏩ 00:00 Introduction - Automatic Index Tuning in Azure Database for PostgreSQL ⏩ 02:25 What is Index Tuning - Process and Benefits Overview ⏩ 04:30 Azure Database for PostgreSQL Context and Features ⏩ 05:27 Key Features of Automatic Index Tuning ⏩ 09:05 DEMO - Configuring Index Tuning via Portal and CLI ⏩ 13:16 Understanding Index Recommendations - Create and Drop Types ⏩ 17:16 Index Tuning Settings ⏩ 19:37 Applying Index Tuning Recommendations using your IDE ⏩ 24:22 Value Proposition of Automatic Index Tuning ⏩ 26:50 Conclusion and Future Roadmap 📕 Everything you need to know about POSETTE: An Event for Postgres 2025 can be found at: https://posetteconf.com ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist 📌 Let’s connect:   POSETTE LinkedIn - https://www.linkedin.com/company/posetteconf/ X – @PosetteConf, https://twitter.com/PosetteConf Mastodon – @posetteconf, https://mastodon.social/@posetteconf Bluesky – @posetteconf.com, https://bsky.app/profile/posetteconf.com Azure Database for Postgres LinkedIn - https://www.linkedin.com/company/azure-database-for-postgresql/ __