Expanded

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.
Course info
Rating
(67)
Level
Intermediate
Updated
Jul 28, 2016
Duration
2h 57m
Table of contents
Course Overview
PostgreSQL: Introduction
PostgreSQL: Understanding Significance of EXPLAIN Keyword
PostgreSQL: Improving Query Performance with Indexes
PostgreSQL: Index Tuning for Complex Queries
PostgreSQL: Best Practices to Populate Large Database
PostgreSQL: Resources and Summary
Description
Course info
Rating
(67)
Level
Intermediate
Updated
Jul 28, 2016
Duration
2h 57m
Your 10-day individual free trial includes:

Expanded library

This course and over 7,000+ additional courses from our full course library.

Hands-on library

Practice and apply knowledge faster in real-world scenarios with projects and interactive courses.
*Available on Premium only
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.

About the author
About the author

Pinal Dave is a Pluralsight Developer Evangelist.

More from the author
SQL Extensibility Features with Snowflake
Intermediate
1h 1m
Oct 4, 2021
Impact with Slowloris
Intermediate
21m
May 20, 2021
More courses by Pinal Dave