| From: | Artur Zakirov <zaartur(at)gmail(dot)com> |
|---|---|
| To: | Mark Phillips <mark(dot)phillips(at)mophilly(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: FTS and tri-grams |
| Date: | 2021-01-06 08:02:16 |
| Message-ID: | CAKNkYnwnNcO3YvVi6puwa-of75o7pz0AAzCBZvq3V3dm_MLtVg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jan 5, 2021 at 10:26 PM Mark Phillips
<mark(dot)phillips(at)mophilly(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2021-01-06 08:43:55 | Re: How to convert escaped text column - force E prefix |
| Previous Message | Durumdara | 2021-01-06 07:55:11 | How to convert escaped text column - force E prefix |