Full-Text Search
Full-text search finds documents matching natural-language queries by indexing words and their variants, ranking results by relevance rather than exact matching.
Unlike a simple LIKE query, full-text search understands word boundaries, stemming (matching 'run' and 'running'), and relevance ranking. It's how search boxes return useful results quickly over large text columns.
PostgreSQL has built-in full-text search using tsvector and tsquery types and GIN indexes, so you can add search to your data without a separate search service for many workloads.
For very search-heavy products, a dedicated search engine may be warranted, but Postgres full-text search covers a wide range of needs with no extra infrastructure.
Related terms
Full-Text Search in Kolaybase
See it in practice
Kolaybase gives you PostgreSQL, auth, storage, and a REST API in minutes.