In the PostgreSQL, we can use Trigram to enhance the use of Full Text Search. The Trigram algorithm divides string like “dog” = “d”,”do”,”dog”,”og”. The Trigram matching comes with pg_trgm extension. We can also apply Trigram operators on Gist and GIN indexes which increase the search speed and enhance the performance. We have already different … Continue reading PostgreSQL: Example of Trigram Index for Full Text Search using pg_trgm Extension