Re: Very bad FTS performance with the Polish config

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Wojciech Knapik <webmaster(at)wolniartysci(dot)pl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Very bad FTS performance with the Polish config
Date: 2009-11-18 15:52:17
Message-ID: Pine.LNX.4.64.0911181842520.6801@sn.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 18 Nov 2009, Wojciech Knapik wrote:

> Yes, for 4-word texts the results are similar.
> Try that with a longer text and the difference becomes more and more
> significant. For the lorem ipsum text, 'polish' is about 4 times slower, than
> 'english'. For 5 repetitions of the text, it's 6 times, for 10 repetitions -
> 7.5 times...

Again, I see nothing unclear here, since dictionaries (as specified
in configuration) apply to ALL words in document. The more words in
document, the more overhead.

You can pass not all document to ts_headline, but just part, to have
predicted performance. This is useful in any case.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru)
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Boley 2009-11-18 16:43:14 Re: Python 3.1 support
Previous Message Pavel Stehule 2009-11-18 15:38:20 Re: Very bad FTS performance with the Polish config