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 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? is it dictionary based or stem based? Dictionary based FTS is very slow (first load). Minimally czech FTS is slow. regards Pavel Stehule > > regards, tom lane > > -- > Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
