Re: For full text indexing, which is better, tsearch2 or

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: For full text indexing, which is better, tsearch2 or
Дата
Msg-id 3FC54A82.2040605@familyhealth.com.au
обсуждение исходный текст
Ответ на For full text indexing, which is better, tsearch2 or fulltextindex  (LIANHE SHAO <lshao2@jhmi.edu>)
Ответы Re: For full text indexing, which is better, tsearch2 or
Re: For full text indexing, which is better, tsearch2 or
Список pgsql-performance
> Which one is better (performance/easier to use),
> tsearch2 or fulltextindex?
> there is an example how to use fulltextindex in the
> techdocs, but I checked the contrib/fulltextindex
> package, there is a WARNING that fulltextindex is
> much slower than tsearch2. but tsearch2 seems
> complex to use, and I can not find a good example.
> Which one I should use? Any suggestions?

I believe I wrote that warning :)

Tsearch2 is what you should use.  Yes, it's more complicated but it's
HEAPS faster and seriously powerful.

Just read the README file.

You could also try out the original tsearch (V1), but that will probably
be superceded soon, now that tsearch2 is around.

Chris



В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Followup - expression (functional) index use in joins
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: very large db performance question