Azure Saturday - 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.

Please also sign up on FooCafé, this helps plan the logistics regarding food and venue: **TBA**

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

Session: Hands‑on tutorial on Azure Database for PostgreSQL Flexible Server parameter tuning

Description: 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**.

We enforce a Code of Conduct to this event, attending the event implies your consent to uphold this Code of Conduct. Find the Code of conduct here: https://github.com/BMichaelJ/AzureSkane/blob/master/README.md#code-of-conduct

A big welcome!
Azure Skåne
#AzureSkane
#DBTune
#AzurePostgreSQL