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