Re: [GENERAL] tsearch2: very slow queries

2005-08-08 Thread Oleg Bartunov
Hi there, tsearch2 is our next problem we plan to attack after we have done with GiST core. Actually, we did some experiments in background and we're sure we could very greatly improve tsearch2 performance and add a lot of nice features. Most probably, we'll call for fund raising for this

[GENERAL] tsearch2: very slow queries

2005-08-07 Thread Marc G. Fournier
'k, I'm obviously doing something wrong, since my experiences with sites like fts.postgresql.org indicate things should be *alot* faster then I'm getting ... I have a *very* simple table: =# \d article_tsearch Table public.article_tsearch Column | Type | Modifiers

Re: [GENERAL] tsearch2: very slow queries

2005-08-07 Thread Joshua D. Drake
Marc G. Fournier wrote: 'k, I'm obviously doing something wrong, since my experiences with sites like fts.postgresql.org indicate things should be *alot* faster then I'm getting ... Well the first thing I would ask is are you running 8.0? My testing shows that Tsearch is pretty abysmal if

Re: [GENERAL] tsearch2: very slow queries

2005-08-07 Thread Marc G. Fournier
On Sun, 7 Aug 2005, Joshua D. Drake wrote: Marc G. Fournier wrote: 'k, I'm obviously doing something wrong, since my experiences with sites like fts.postgresql.org indicate things should be *alot* faster then I'm getting ... Well the first thing I would ask is are you running 8.0? My