From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Kenneth Marshall <ktm(at)rice(dot)edu> |
Cc: | Wojciech Knapik <webmaster(at)wolniartysci(dot)pl>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: FTS performance with the Polish config |
Date: | 2009-11-14 17:07:32 |
Message-ID: | 14829.1258218452@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2009-11-14 17:24:05 | Re: FTS performance with the Polish config |
Previous Message | Kenneth Marshall | 2009-11-14 15:58:02 | Re: FTS performance with the Polish config |