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
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 |