Become a member
Sign in
Ravi Lakhotia
Ravi Lakhotia

Ravi Lakhotia

11 Following
1 Followers
  • Profile
  • Claps
  • Highlights

Latest

Ravi Lakhotia
Ravi Lakhotia
Jul 15, 2018 · 1 min read

Partial Indexes in Postgres

Partial Index is one of the hidden and not very widely used feature of Postgres. It allows us to index a subset of data. That’s a sweet one line description of what it is. Let’s walk through an example to understand when we should use partial indexes.

3