Data is critical to any application, and database performance goes hand-in-hand with it. In this course, you'll get to see some ways to maximize database performance with PostgreSQL, covering indexes, best practices, and more.
PostgreSQL is often called the world's most advanced open source database. In this course, PostgreSQL: Index Tuning and Performance Optimization, you will get a look at index tuning and some performance optimization methods. You'll start with an introduction to tuning and optimization in PostgreSQL and how the EXPLAIN keyword works. Next, you'll see how indexes improve performance and move into some advanced concepts for indexes. Then, you'll get to learn about some best practices for populating large databases and be shown some important resources for PostgreSQL. By the end of this course, you'll be better prepared to tackle PostgreSQL databases challenges with performance in mind.
Course Overview Hi everyone. My name is Pinal Dave, Welcome to my course, PostgreSQL: Index Tuning and Performance Optimization. I am a database professional at sqlauthority. com. Data is very important for any application, but Data's performance is even more important. Everybody wants maximum performance for their application. Indexes are considered as a silver bullet for performance. It is true to a certain extent, however, not every index is impactful for queries. There are various logical reasoning are associated with creating an optimal index. Some of the major topics in this course we will cover include understanding query execution plan and its performance, creating optimal indexes for complex queries, and finally, identifying best practices for different workload. By the end of this course, you will know how to create the best index for your query, and what are the best practices you should implement for optimal performance. I hope you will join me on this journey to learn PostgreSQL: Index Tuning and Performance Optimization.