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

Post Content

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:  
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