CPUG event Nov 6th: Mastering PostgreSQL parameter tuning — A practical approach using AI
The is the sign-up page for the next event of Copenhagen PostgreSQL User Group.

Time: Wednesday November 6th 2024 at 18:00 - 20:00
Place: Business Centre Nord, Lyngbyvej 20, Copenhagen, 2100

18:00: Arrival, introduction.
18:10: DBtune session part 1
19:00: Pizza eating.
19:20: DBtune session part 2

Please try to arrive on time. If you arrive late, send an SMS to Troels Arvin at 51213121 and wait to be picked up at the entrance.

You are encouraged to bring along your laptop, because the second part of Luigi's presentation will work as a hands-on tutorial.

Abstract

This session will introduce you to PostgreSQL parameter tuning fundamentals and includes a hands-on tutorial that explores the practical application of an automated tuning solution. We will explore the intricate world of PostgreSQL parameter tuning, where the database management system is shaped by configurable parameters, like work_mem, which govern its runtime behavior. As databases grow in complexity, so does the challenge of tuning various parameters due to their non-linear relationship. The complexity of these parameters highlight the importance of correct configuration to optimize application performance and cloud resource utilization. We will start with the traditional, meticulous approach of manual tuning, where experts analyze performance metrics such as query response times and resource usage. We will then explore heuristic-based tools, like PGTune, that offer general recommendations. Finally, we will set our sights on the future of auto-tuning with AI. We will showcase how these more sophisticated methods can adapt dynamically to a specific workload and machine resources. During the hands-on tutorial, we will use a synthetic PostgreSQL workload and DBtune, an AI-powered tuning framework, to show how it personalizes configurations to achieve efficient and enhanced performance.

Speaker bio

Luigi Nardi is the founder and CEO of DBtune 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 specializes in Bayesian 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 two decades. Luigi is one of  the top 15 most prolific PostgreSQL conference speakers in v17 timeframe.

Note

Your name, affiliation, and contact information may be part of an event notes document published in the user group's LinkedIn group after the event (unless you tell Troels Arvin that you don't want that).
Sign in to Google to save your progress. Learn more
Name *
Organization
E-mail
 *
Submit
Clear form
Never submit passwords through Google Forms.
This content is neither created nor endorsed by Google. - Terms of Service - Privacy Policy

Does this form look suspicious? Report

Google Forms