I wrote a little post on doing fast text search in postgres: https://austingwalters.com/fast-full-text-search-in-postgresql/ https://austingwalters.com/fast-fu

I wrote a little post on doing fast text search in postgres: https://austingwalters.com/fast-full-text-search-in-postgresql/ https://austingwalters.com/fast-full-text-search-in-postgres... I use it regularly and it may help people. Makes use of triggers and some of the other items mentioned.