Luigi Nardi
Dr. 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 centers around Bayesian methods and 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 is a public speaker and prolific researcher, having co-authored more than 50 peer-reviewed papers at leading venues in machine learning and computer science.
DBtune
Přednáška
PostgreSQL, renowned for its extensibility and robust feature set, offers a wealth of server configuration parameters that can significantly influence its performance. Most PostgreSQL users operate with default parameters, which are often not optimized for commonly used server machine flavors. This talk is a comprehensive benchmark analysis exploring the potential performance benefits achievable through server parameter tuning. We'll examine the impact of various parameter configurations on diverse workloads, ranging from OLTP to OLAP, and provide an analysis that highlights the performance gains and show that these depend on several factors related to the computing environment and workloads. This talk helps database administrators and developers with actionable insights for maximizing PostgreSQL performance through effective server parameter tuning.