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:
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.