On Tue, Jan 5, 2021 at 10:26 PM Mark Phillips
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 in
> On Jan 5, 2021, at 13:26, Mark Phillips wrote:
> 1. Is FTS required for tri-gram to work?
> 2. Are these independent of each other?
> 3. Is tri-gram alone sufficient for a “full text search” feature?
The answers are, kind of in order:
2. Yes.
1. No.
3. It depends on what you mean by "full t
Some years ago we implemented FTS. At the time, we also added a column with the
tsvector data type. We assumed we needed that for FTS to work.
Later, we added tri-gram support. At the time, we assumed tri-gram complimented
FTS.
More recently, we have run into a problem with replicating the tsve
