In this blog mini-series, the author explores the full-text search functionality in PostgreSQL and its comparison to Elasticsearch. The author recommends following along with the sample queries using the Wikipedia Movie Plots dataset. The building blocks of PostgreSQL’s full-text search include the tsvector and tsquery data types, the match operator @@, functions to rank each match, and the GIN index type. The author also explains the normalization process and the use of different search configurations. Additionally, the author covers relevancy boosters, typo-tolerance, and faceted search. The GIN index type is explained, which allows for efficient querying of composite values. Finally, the author discusses using ts_rank and ts_rank_cd for sorting search results by relevancy and demonstrates how to apply additional boosting based on other columns.
https://xata.io/blog/postgres-full-text-search-engine