When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
PostgreSQL: Index Tuning and Performance Optimization
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.
This Course Includes
pluralsight
3 (92 reviews )
3 hour 7 minutes 
english
Online - Self Paced
core courses
pluralsight
About PostgreSQL: Index Tuning and Performance Optimization
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.
What You Will Learn?
- Course Overview : 1min.
- PostgreSQL: Introduction : 8mins.
- PostgreSQL: Understanding Significance of EXPLAIN Keyword : 41mins.
- PostgreSQL: Improving Query Performance with Indexes : 45mins.
- PostgreSQL: Index Tuning for Complex Queries : 44mins.
- PostgreSQL: Best Practices to Populate Large Database : 30mins.
- PostgreSQL: Resources and Summary : 16mins.