#193: As a database administrator, you probably want to spend more time trying to make things better for people using your database instead of always chasing down the latest tuning parameters or queries that are causing problems. There are only 24 hours in a day and you’re not sure if you’ll ever be able to really make things any better with the schema changes and data volume that are constantly being thrown at the database you manage.
In this episode, we talk with Andy Pavlo, CEO at OtterTune, about the knobs that should be turned in Postgres or MySQL before you even start trying to do any index or query tuning.
Andy is an Associate Professor of Databaseology in the Computer Science Department at Carnegie Mellon University. His research interest is in database management systems, specifically main memory systems, self-driving / autonomous architectures, transaction processing systems, and large-scale data analytics. At CMU, he is a member of the Database Group and the Parallel Data Laboratory. He is also the co-founder and CEO of OtterTune.
Viktor Farcic is a member of the Google Developer Experts and Docker Captains groups, and published author.
His big passions are DevOps, Containers, Kubernetes, Microservices, Continuous Integration, Delivery and Deployment (CI/CD) and Test-Driven Development (TDD).
He often speaks at community gatherings and conferences (latest can be found here).
His random thoughts and tutorials can be found in his blog TechnologyConversations.com.
If you like our podcast, please consider rating and reviewing our show! Click here, scroll to the bottom, tap to rate with five stars, and select “Write a Review.” Then be sure to let us know what you liked most about the episode!
Also, if you haven’t done so already, subscribe to the podcast. We're adding a bunch of bonus episodes to the feed and, if you’re not subscribed, there’s a good chance you’ll miss out. Subscribe now!