PostgreSQL: Index Tuning and Performance Optimization
Pluralsight
Course Summary
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.
-
+
Course Description
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 Syllabus
Course Overview- 1m 24s
—Course Overview 1m 24sPostgreSQL: Introduction- 8m 11s
—Introduction 2m 9s
—Prerequisites and Agenda 1m 56s
—Real World Scenario Introduction 1m 2s
—Let's Start 3m 2sPostgreSQL: Understanding Significance of EXPLAIN Keyword- 41m 12sPostgreSQL: Improving Query Performance with Indexes- 45m 0sPostgreSQL: Index Tuning for Complex Queries- 44m 6sPostgreSQL: Best Practices to Populate Large Database- 30m 39sPostgreSQL: Resources and Summary- 16m 24s
