FTS vs pg_trgm — When to Use Which

PostgreSQL offers two text search mechanisms with very different strengths. Understanding when to use FTS (full text search) versus pg_trgm (trigram similarity) determines whether your search feels intelligent or broken.