Rails: Postgres Partial Indexing

PostgreSQL has partial indexes Show archive.org snapshot . With a partial index you tell Postgres to only index rows matching a given query.

Some uses cases for a partial index:

• You want a uniqueness index, but only under some conditions
• Your table is very large and indexing every row becomes expensive

The linked article Show archive.org snapshot shows how to create a partial index with Rails.