Simple play icon Course

PostgreSQL: Index Tuning and Performance Optimization

by Pinal Dave

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.

What you'll learn

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.

Table of contents

Course Overview

About the author

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 61 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,700 database tech articles on his blog at

Ready to upskill? Get started