2009/11/14 Tom Lane <tgl@sss.pgh.pa.us>:
> Kenneth Marshall <ktm@rice.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>