Re: FTS performance with the Polish config

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FTS performance with the Polish config
Дата
Msg-id 14829.1258218452@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: FTS performance with the Polish config  (Kenneth Marshall <ktm@rice.edu>)
Ответы Re: FTS performance with the Polish config  (Pavel Stehule <pavel.stehule@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Kenneth Marshall
Дата:
Сообщение: Re: FTS performance with the Polish config
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: FTS performance with the Polish config