| From: | Mark Phillips <mark(dot)phillips(at)mophilly(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | FTS and tri-grams |
| Date: | 2021-01-05 21:26:27 |
| Message-ID: | C31F8FA1-C435-4930-AA69-E933FB290E1A@mophilly.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 tsvector column.
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?
3. Is tri-gram alone sufficient for a “full text search” feature?
Any thoughts, experiences or other thoughts greatly appreciated.
- Mark Phillips
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Flatley | 2021-01-05 21:55:00 | RE: Max# of tablespaces |
| Previous Message | Bruce Momjian | 2021-01-05 19:38:13 | Re: Max# of tablespaces |