Re: full text indexing

On Wed, 15 Mar 2006, chris smith wrote:

> Hi all,
>
> Just wondering which full text module is better & what the differences
> are between tsearch and fti ?

if you need online indexing and linguistic support (dictionaries, stop
words, ranking) tsearch2 is fine. If your data are static and you need
only strict search, fti could works for you.
We hope to develop inverted index support for tsearch2 this year, though.

>
> The table in question has roughly 80,000 rows.

how many unique words and how long are documents ?

>
> Thanks!
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83