The PRQL: Database Tuning and Optimization with Andy Pavlo and Dana Van Aken of OtterTune

Highlights from this week’s conversation include:

• Origins of OtterTune (4:43)
• The problem of knob tuning (6:25)
• Roles of machine learning (9:32)
• OtterTune’s development and industry recognition (12:03)
• The challenges of database tuning and the role of human expertise (16:15)
• Tuning in production (20:23)
• Observability and Data Collection (23:37)
• Data Security and Privacy (29:59)
• Optimizing on-prem vs. cloud workloads (35:52)
• Performance benchmarks (40:20)
• Future opportunities OtterTune is focusing on (43:55)
• Importance of automated tuning services (50:45)
• Challenges in Benchmarking Real Workloads (58:43)
• The Story Behind the Name OtterTune (1:08:58)
• Balancing Technology and Human Factors (1:13:23)

The Data Stack Show is a weekly podcast powered by RudderStack, the CDP for developers. Each week we’ll talk to data engineers, analysts, and data scientists about their experience around building and maintaining data infrastructure, delivering data and data products, and driving better outcomes across their businesses with data.

RudderStack helps businesses make the most out of their customer data while ensuring data privacy and security. To learn more about RudderStack visit rudderstack.com.