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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] tsearch vs. fulltextindex
Следующее
От: Patrick Nelson
Дата:
Сообщение: Re: Blob stuff