Re: [GENERAL] Full Text Search combined with Fuzzy

Поиск
Список
Период
Сортировка
От Oleg Bartunov
Тема Re: [GENERAL] Full Text Search combined with Fuzzy
Дата
Msg-id CAF4Au4wtKJyyKsLzP6j=vOTPzL2kuEQTF6KGPecqifogKNN-kQ@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Full Text Search combined with Fuzzy  (Nicolas Paris <niparisco@gmail.com>)
Ответы Re: [GENERAL] Full Text Search combined with Fuzzy
Список pgsql-general


On Sun, Feb 26, 2017 at 3:52 PM, Nicolas Paris <niparisco@gmail.com> wrote:
Hello,

AFAIK there is no built-in way to combine full text search and fuzzy matching
(https://www.postgresql.org/docs/current/static/fuzzystrmatch.html).
By example, phrase searching with tipos in it.

First I don't know if postgresql concurrents (lucene based...) are able
to do so.


Second, is such feature is in the road map ?

Third, I wonder if it is a good idea to use the postgresql synonyms
feature for such prupose.(https://www.postgresql.org/docs/current/static/textsearch-dictionaries.html)
I mean, building up a synonyms dictionnary containing tipos. By eg:

postgres        pgsql
postgresql      pgsql
postgrez        pgsql
postgre         pgsql
gogle           googl
gooogle         googl

There is multiple way to build such dictionary. But my question is about
the implementation of dictionnaries in postgresql: Is postgresql
supposed to take advantage of billion entries dictionaries ?

dictionary is just a program, so it's  up to developer how to write efficient program to deal with billion entries. Specifically to synonym dictionary, it's not intended to work with a lot of entries. btw, have a look on contrib/dict_xsyn dictionary, which is more flexible than synonym.

Thanks by advance for you answers,


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Nikolai Zhubr
Дата:
Сообщение: Re: [GENERAL] Re: Causeless CPU load waves in backend, on windows,9.5.5 (EDB binary).
Следующее
От: Arjen Nienhuis
Дата:
Сообщение: Re: [GENERAL] Foreign key references a unique index instead of aprimary key