Presented by:

39b261a59fdf184912bb215c82a95ebe

Luigi Nardi

from DBtune

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 assistant 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.

No video of the event yet, sorry!

Explore the intricate world of PostgreSQL parameter tuning, where the database management system reveals a myriad of configurable parameters shaping its runtime behavior. With the evolution of the system, numerous parameters came to light — Correctly configuring these parameters is pivotal for enhancing application performance and optimizing cloud resources. The complexity of the parameter interaction demands significant effort in tuning.

Delve into the existing approaches, from the manual tuning "dark art" involving meticulous analysis of metrics like query response times and resource utilization, to heuristic-based approaches such as PGTune or PostgreSQL Configurator offering generic solutions. However, a paradigm shift occurs with DBtune, a fully automated parameter tuning service. Tailored to both workload and machine resources, DBtune employs machine learning to customize optimizations based on specific customer needs. It observes performance indicators and trains models for selecting parameters that guarantee improved performance, streamlining and scaling the tuning process across numerous instances. Leveraging DBtune not only enhances database performance but also reduces cloud expenses and environmental impact.

Join this presentation for an in-depth exploration of the significance and business value of database parameter tuning. Survey existing options, including manual tuning and open-source tools, and catch a glimpse of the game-changing autotuning solution that promises a straightforward resolution to this long-standing challenge.

Date:
2024 February 29 - 15:30
Duration:
40 min
Room:
Grand Victoria A
Conference:
PGConf India, 2024
Language:
Track:
Application Developer
Difficulty:
Medium

Happening at the same time:

  1. How to Unleash the Power of PostgreSQL in the Cloud
  2. Start Time:
    2024 February 29 15:30

    Room:
    Grand Victoria B

  3. Using PostgreSQL and PostGIS for climate resilent agriculture
  4. Start Time:
    2024 February 29 15:30

    Room:
    Robusta + Arabica