Efficient Search in Rails with Postgres

Speed up a search query from seconds to milliseconds and learn about exact matches, similarity matches with trigrams, partial matches with ILIKE, and natural language full-text search.

Ebook Cover Image

In this book you will learn:

  • How to optimize an Exact Match Query
  • Partial / Case Insensitive Matches and using indexes with LIKE and ILIKE
  • Similarity Matches and Optimizing Trigram Search
  • Natural Language Matches with Full Text Search
  • Optimizing Full Text Search

Download this eBook


Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze

Atlassian
DoorDash
Moody's
fuboTv
Salsify
CounterPath
Ipsy