You Don’t Always Need Elasticsearch: How PostgreSQL Full-Text Search Works Under the Hood

Why ILIKE %query% doesn’t scale, how PostgreSQL’s tsvector, GIN, and tsquery turn plain text into a real lexical search engine, and when it’s a genuine Elasticsearch alternative.