On Tue, Jan 5, 2021 at 10:26 PM Mark Phillips
<mark.phill...@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 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


Reply via email to