| From: | Artur Zakirov <a(dot)zakirov(at)postgrespro(dot)ru> |
|---|---|
| To: | Nicolas Paris <niparisco(at)gmail(dot)com> |
| Cc: | Oleg Bartunov <obartunov(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Full Text Search combined with Fuzzy |
| Date: | 2017-03-03 14:03:04 |
| Message-ID: | db50a068-a516-9cc6-cff5-3241296d44ce@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 03.03.2017 16:17, Nicolas Paris wrote:
> Nice ! I do have 9.6 version.
>
> Would this kind of index could handle more than 20M large texts ? The
> recheck condition looks ressource consuming.
You are right. I think pg_trgm will be not good for such large texts,
unfortunately.
>
> The full text index + phrase search + synonym dictionnary is the only
> other alternativ to deal with typo-phrase mining ?
I suppose there are no other options now. Though, prefix search maybe
will help you [1].
>
> Is there any possibility in the future to add typo in the full text
> road-map ?
As far as I know, there is no plans in the near future to add similarity
full text search.
1.
https://www.postgresql.org/docs/current/static/textsearch-dictionaries.html
--
Artur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2017-03-03 14:39:35 | Re: Autoanalyze oddity |
| Previous Message | David Rowley | 2017-03-03 13:32:48 | Re: DISTINCT vs GROUP BY - was Re: is (not) distinct from |