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.
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
