Re: [PERFORM] FTS performance with the Polish config

2009-11-15 Thread Oleg Bartunov
On Sun, 15 Nov 2009, Pavel Stehule wrote: czech stemmer doesn't exist :( I'd try morfessor http://www.cis.hut.fi/projects/morpho/, which is unsupervised morphological dictionary. I think it'd be not very hard to add morfessor dictionary template to tsearch2, so people could create their ow

Re: [PERFORM] FTS performance with the Polish config

2009-11-15 Thread Pavel Stehule
2009/11/15 Oleg Bartunov : > On Sun, 15 Nov 2009, Pavel Stehule wrote: > >> 2009/11/15 Oleg Bartunov : >>> >>> 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. Peop

Re: [PERFORM] FTS performance with the Polish config

2009-11-15 Thread Oleg Bartunov
On Sun, 15 Nov 2009, Pavel Stehule wrote: 2009/11/15 Oleg Bartunov : 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 d

Re: [PERFORM] FTS performance with the Polish config

2009-11-14 Thread Pavel Stehule
2009/11/15 Oleg Bartunov : > 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

Re: [PERFORM] FTS performance with the Polish config

2009-11-14 Thread Oleg Bartunov
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 : > Kenneth Marshall writes: >> On Sat, Nov 14, 2009 at 12:25:05PM +0100, Wojcie

Re: [PERFORM] FTS performance with the Polish config

2009-11-14 Thread Pavel Stehule
2009/11/14 Tom Lane : > Kenneth Marshall 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. >

Re: [PERFORM] FTS performance with the Polish config

2009-11-14 Thread Tom Lane
Kenneth Marshall 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

Re: [PERFORM] FTS performance with the Polish config

2009-11-14 Thread Kenneth Marshall
On Sat, Nov 14, 2009 at 12:25:05PM +0100, Wojciech Knapik wrote: > > Hello > > 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. All of it boils down to a simple testcase, bu