Re: full text search to_tsquery performance with ispell dictionary

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Stanislav Raskin <raskin(at)livn(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: full text search to_tsquery performance with ispell dictionary
Date: 2011-05-11 15:07:16
Message-ID: BANLkTi=1Fzt_D1Owzh0wycYs_+J6A97n4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2011/5/11 Stanislav Raskin <raskin(at)livn(dot)de>:
> On 11.05.11 16:42, "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> wrote:
>
>
>>I wrote a
>>patch that stores loaded dictionary in shared memory.
>
> Hi Pavel,
>
> very interesting. I will give it a closer look.
>
> What do you think about using ispell to create, store and index tsvectors,
> but at the same time to use the stemmer to create tsqueries? Thus, I hope
> to create a fast user experience while searching, but at the same time
> have more detailed tsvectors and more matches.
>

I know nothing - but there can be risk - two different method can to
returns two different results.

Regards

Pavel

> Regards
>
> --
>
> Stanislav Raskin
>>
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Phoenix Kiula 2011-05-11 15:18:35 Regexp match not working.. (SQL help)
Previous Message tv 2011-05-11 15:04:50 Re: full text search to_tsquery performance with ispell dictionary