PostgreSQL Partial Indexes 08/12

If you found this video helpful, you could check the full course on Udemy. In this course, you’ll find tips for tuning PostgreSQL 12 like a pro.

Use the link below to get a 60% OFF.

PostgreSQL High-Performance Tuning Guide - Full Course

While we usually create indexes for all records, it's possible to create an index for a subset of records.
An index created on a subset of data will be smaller than one created without a filter. This will result in an improvement in performance when the index has to be scanned.