Optimizing Postgres Databases

Learn how to optimize your Postgres databases with our Optimizing Postgres Databases for Data Engineering.

In this course, you’ll explore Postgres Internals to discover how Postgres manages meta information about databases and tables. Along with discovering how Postgres manages its metadata, you’ll also discover what a Postgres is and how to create a description of a database. You’ll also learn how to debug your Postgres queries using the EXPLAIN clause.

You’ll also learn how to measure estimated and actual execution times of your queries and find out which SQL clause is the most computationally expensive to perform and biggest cause for long-running queries.

In addition to learning Postgres’ internal and how to debug Postgres queries, you’ll learn such concepts such as indexing and how indexing can greatly reduce querying speed. You will learn some advanced features of indexes such as multi-index, ordered index, and more.

You’ll also learn what it means to vacuum a Postgres database, how it reduces query speeds and how to vacuum a database, and what ACID means for database transactions and why it’s important for transaction blocks.

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.

Optimizing Postgres Databases Lessons List

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.