On Tue, Jan 5, 2021 at 10:26 PM Mark Phillips <mark.phillips@xxxxxxxxxxxx> wrote: > We now wonder if tri-gram alone can achieve a fast full text search result. If so, then we could the tsvector column be dropped? > > 1. Is FTS required for tri-gram to work? > 2. Are these independent of each other? FTS and tri-gram are independent features. You can implement them independently, but it might depend on your use case. > 3. Is tri-gram alone sufficient for a “full text search” feature? It isn't sufficient if you want exact and/or phrase search. -- Artur
