Postgres Full Text Search is better than ...
(admcpr.com)I don't really understand the title of this post series, but the content is excellent! It starts out with trying to search a database with a like '%star%'. From there, the author explores adding in PostgreSQL features (complexity) to demonstrate different facets of using PostgreSQL full text search.
https://admcpr.com/postgres-full-text-search-is-better-than-part1/