On Tue, Jan 5, 2021 at 10:26 PM Mark Phillips
<mark.phillips@mophilly.com> wrote:
> We now wonder if tri-gram alone can achieve a fast full text search result. If so, then we could the tsvector column
bedropped?
>
> 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