Re: tsearch vs. fulltextindex
| От | Graeme Merrall |
|---|---|
| Тема | Re: tsearch vs. fulltextindex |
| Дата | |
| Msg-id | MMEKJDBHGFPPMNBALCOHOENICCAA.GBMerrall@aol.com обсуждение исходный текст |
| Ответ на | tsearch vs. fulltextindex ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>) |
| Список | pgsql-general |
> I've just done some performance comparisons between contrib/fulltextindex > and contrib/tsearch. Even with every optimisation I can think of for > fulltextindex, tsearch is 300 times faster ;) > > Plus it doesn't require a separate table or complicated queries. > > I think we should strongly encourage people to use tsearch instead of > fulltextindex. I hope to commit some change to fulltextindex in the near > future, so I'll add a note to the readme then. > Ditto. We just replaced Oracle Context Search with tsearch and it's just as good for what we were using it for and nicer to play with. There's no scoring as far as I can see but I can live with that. (and hello fellow aussie) Cheers, Graeme
В списке pgsql-general по дате отправления: