Optimizing Postgres Databases

Learn how to optimize your Postgres databases.

Learn how to optimize your Postgres databases using a real world examples of slow queries, bloated tables, and unindexed columns.

By the end of this course, you'll be able to:

  • Understand how to debug Postgres queries and find bottlenecks.
  • Use indexes to speed up Postgres query.
  • Understand the fundamentals of Postgres' internal tooling.

Course Info:

Optimizing Postgres Databases


The average completion time for this course is 10-hours.

This course is free and includes five missions. It is the 2nd course in the Data Engineer path.


Learn to Optimize Postgres Databases

Exploring Postgres Internals

Learn how Postgres stores internal data and how we can access it.

Debugging Postgres Queries

Learn how to debug your Postgres queries using EXPLAIN.

Using an Index

Learn about how Postgres accesses data and how to use indexes to speed this up.

Advanced Indexing

Learn about advanced features of indexes such as multi index, ordered index, and more.

Vacuuming Postgres Databases

Learn about database vacuuming and how it decreases query speed.