Re: full text + snowball + ispell?

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

In response to

Browse pgsql-general by date

  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