Re: tsearch vs. fulltextindex - Mailing list pgsql-general

From Graeme Merrall
Subject Re: tsearch vs. fulltextindex
Date
Msg-id MMEKJDBHGFPPMNBALCOHOENICCAA.GBMerrall@aol.com
Whole thread Raw
In response to tsearch vs. fulltextindex  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] tsearch vs. fulltextindex
Next
From: Patrick Nelson
Date:
Subject: Re: Blob stuff