2009/11/15 Oleg Bartunov <oleg@xxxxxxxxxx>: > 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. > it is a problem. People who needs fast access uses english without czech. It drop some features, but it is significaly faster. Pavel > 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
