Re: FTS performance with the Polish config - Mailing list pgsql-performance

From Tom Lane
Subject Re: FTS performance with the Polish config
Date
Msg-id 14829.1258218452@sss.pgh.pa.us
Whole thread Raw
In response to Re: FTS performance with the Polish config  (Kenneth Marshall <ktm@rice.edu>)
Responses Re: FTS performance with the Polish config  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-performance
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?

            regards, tom lane

pgsql-performance by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: FTS performance with the Polish config
Next
From: Pavel Stehule
Date:
Subject: Re: FTS performance with the Polish config