Azure Saturday Workshop
Hands‑On Tuning for Azure PostgreSQL Flexible Server
Welcome to Azure Skåne – Special Workshop Edition!
Azure Skåne is excited to host a deep‑dive, hands‑on technical session with one of the leading experts in AI‑driven database optimization. This workshop is perfect for developers, data engineers, architects, and anyone working with PostgreSQL on Azure who wants to understand how real performance tuning is done in practice.
This event is part of our ongoing community efforts to bring world‑class expertise to Malmö and create opportunities for learning, collaboration, and practical skill‑building around Microsoft Azure.
Hands‑on tutorial on Azure Database for PostgreSQL Flexible Server parameter tuning
PostgreSQL exposes hundreds of configuration parameters, but only a few dozen truly determine performance and resource efficiency. Tuning them correctly is notoriously difficult due to complex interactions and workload‑specific behavior. Traditional approaches—manual tuning or generic rule‑based tools—often fall short.
In this practical workshop, participants will learn the fundamentals of server parameter tuning and get hands‑on experience using heuristics‑based open‑source tools such as PGtune to achieve meaningful performance improvements. We’ll explore which parameters matter most, how PGtune’s heuristics work, and why they influence performance.
The session concludes with an introduction to DBtune Free Edition, an AI‑powered agentic tuning engine that blends heuristic rules with modern AI and ML techniques to deliver smarter, workload‑aware optimization.
Prerequisites: Bring your own laptop with a command‑line shell (e.g., PowerShell). If you are using a company laptop, please whitelist **app.dbtune.com**.
Speaker:
Dr. Luigi Nardi - is the founder and CEO of DBtune (www.dbtune.com), a leading company driving advancements in AI, database systems, and cloud computing. Previously an associate professor of machine learning at Lund University and a research staff at Stanford University, Luigi's expertise centers around black-box optimization theory and practice. Luigi's journey includes a post-doctoral position at Imperial College London and a role as a software engineer at Murex S.A.S., following his Ph.D. program in applied mathematics at Université Pierre et Marie Curie in Paris in 2011. Luigi published more than 50 research papers and has been a regular speaker at international conferences for almost 2 decades.
Agenda:
10.00 – 10.15 Welcome and introduction
10.15 – 11.00 / 11.15 Pre‑session with Dr. Luigi Nardi Hands‑on introduction to Azure Database for PostgreSQL Flexible Server parameter tuning
11.15 – 12.00 Hands‑on Workshop, Part 1 Guided exercises, parameter exploration, PGtune heuristics
12.00 – 12.45 Lunch and Mingle (45 minutes)
12.45 – 13.45 Hands‑on Workshop, Part 2 Deep‑dive tuning, DBtune Free Edition walkthrough, Q&A
13.45 – 14.00 Closing session Wrap‑up, takeaways, and community announcements
