How PostgreSQL FTS Works — tsvector, tsquery, and the @@ Operator
PostgreSQL Full Text Search converts documents and queries into lexeme vectors — normalized, stemmed tokens — then checks whether a query vector matches a document vector using the @@ operator.