#sql-indexing

PostgreSQL Partial Indexes: Index Less, Write Faster

Partial indexes in PostgreSQL let you index only a filtered subset of rows, shrinking storage and write overhead. Learn when they help, how the planner matches predicates, and how to verify usage.