Yes, as stated original author use polish ispell dictionary.
Ispell dictionary is slow to load first time. In real life it should
be no problem.
Oleg
On Sat, 14 Nov 2009, Pavel Stehule wrote:
2009/11/14 Tom Lane <tgl@xxxxxxxxxxxxx>:
> Kenneth Marshall <ktm@xxxxxxxx> 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 configuratio=
n,
>>> 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. =C2=A0So 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. =C2=A0Could we see a
> self-contained test case?
is it dictionary based or stem based?
Dictionary based FTS is very slow (first load). Minimally czech FTS is slow.
regards
Pavel Stehule
>
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0regards, tom lane
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
--=20
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
