Want to create an interactive transcript for this episode?
Podcast: Software Engineering Daily
Episode: Automatic Database Tuning with Andy Pavlo
Description: The default configuration in most databases is meant for broad compatibility rather than performance. Database tuning is a process in which the configurations of a database are modified to achieve optimal performance. Databases have hundreds of configuration knobs that control various factors, such as the amount of memory to use for caches or how often the data is written to the storage.The problem with these knobs is that
they are not standardized (i.e., two databases may have a different name for the same knob),
 not independent (i.e., changing one knob can impact others),Â
an...