Hello and welcome, today we're learning about performance tuning of our PostgreSQL databases and why it's so important. Whether you're a brand new start up or a large corporation with millions of data entries that are being modified all the time, this information is critical to keeping your systems up and running no matter the circumstances.

So what exactly are we covering? Today, we're going to focus on a quick refresher of PostgreSQL's fundamentals before diving into some basic configuration. As we move along, we will learn how to use benchmarking software to give us a solid metric on how our systems are doing. Next, we will get into some key methods, commands, and other options that we can utilize to drastically improve the performance of our systems. Once we get through with that, we transition to working with VACUUM, AUTOVACUUM, ANALYZE, and EXPLAIN which are methods provided by PostgreSQL's version of the SQL language. We won't just dig into...