Read more

Rails: Postgres Partial Indexing

Henning Koch
January 25, 2021Software engineer at makandra GmbH

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

Illustration UI/UX Design

UI/UX Design by makandra brand

We make sure that your target audience has the best possible experience with your digital product. You get:

  • Design tailored to your audience
  • Proven processes customized to your needs
  • An expert team of experienced designers
Read more Show archive.org snapshot

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.

Posted by Henning Koch to makandra dev (2021-01-25 15:48)