From: | Cédric Villemain <cedric(dot)villemain(at)dalibo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Dominic Bevacqua <dominic(dot)bevacqua(at)bpmlogic(dot)com> |
Subject: | Re: full text + snowball + ispell? |
Date: | 2009-10-12 11:26:27 |
Message-ID: | 200910121326.27615.cedric.villemain@dalibo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Le vendredi 09 octobre 2009 19:31:56, Dominic Bevacqua a écrit :
> Hi
>
> This is probably a naive question, but what would I gain from using
> snowball and ispell dictionaries in tsearch2, as described here:
>
> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intr
> o.html
>
> ?
this description is only relevant for postgresql where tsearch is not in the
core.
Actually, the core already have snowball stemmer.
Anyway, you can rebuild the snowball with some more custom rules if needed, or
.. well many things are possible, but pg 8.3 and 8.4 come with a full
functionnal text search by default.
>
> Presumably there is a performance hit associated with doing this (more
> from ispell I guess), but what would the benefits be?
>
> Hope someone can enlighten me!
>
> Thanks,
>
> Dominic.
>
> Dominic Bevacqua
> Director
> BPM Logic Ltd.
> http://www.bpmlogic.com
>
--
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2009-10-12 11:33:12 | Re: strange plpgsql error |
Previous Message | Vasiliy G Tolstov | 2009-10-12 11:17:42 | auth problem |