PostgreSQL - Indexing

Conan Mercer Applied Scientist

PostgreSQL - Indexing

04 Jun 2021 - Conan Mercer

Motivation

This Jupyter Notebook is the third in my series on PostgreSQL, the previous blog post can be found here. The goal of this post is to become familiar with indexes, with particular focus on execution and planning times of queries. This guide uses a sample database called dvdrental, a common resource used to learn PostgreSQL, it can be downloaded from here.

This Jupyter Notebook also resides on my GitHub - it can be viewed from here

Conclusion

This post introduced indexes in PostgreSQL along with how a table can be partitioned.
In the future I will be writing about joins and how they can help to gather specific information for further analysis.