FTS and tri-grams
От | Mark Phillips |
---|---|
Тема | FTS and tri-grams |
Дата | |
Msg-id | C31F8FA1-C435-4930-AA69-E933FB290E1A@mophilly.com обсуждение исходный текст |
Ответы |
Re: FTS and tri-grams
Re: FTS and tri-grams |
Список | pgsql-general |
Some years ago we implemented FTS. At the time, we also added a column with the tsvector data type. We assumed we neededthat 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
В списке pgsql-general по дате отправления: