Re: FTS performance with the Polish config

2009/11/14 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Kenneth Marshall <ktm(at)rice(dot)edu> writes:
>> On Sat, Nov 14, 2009 at 12:25:05PM +0100, Wojciech Knapik wrote:
>>> I just finished implementing a "search engine" for my site and found
>>> ts_headline extremely slow when used with a Polish tsearch configuration,
>>> while fast with English.
>
>> The documentation for ts_headline() states:
>> ts_headline uses the original document, not a tsvector summary, so it
>> can be slow and should be used with care.
>
> That's true but the argument in the docs would apply just as well to
> english or any other config.  So while Wojciech would be well advised
> to try to avoid making a lot of calls to ts_headline, it's still curious
> that it's so much slower in polish than english.  Could we see a
> self-contained test case?

is it dictionary based or stem based?

Dictionary based FTS is very slow (first load). Minimally czech FTS is slow.

regards
Pavel Stehule

>
>                        regards, tom lane
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>