Re: fulltext search

On Mar 17, 2005, at 10:33 AM, Sabio - PSQL wrote:

> how to implement a fulltext search on table with a varchar(300) field
> and over 6 millions of records?


There is a full text search implementation called tsearch2:

http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

Here is an article to get you started:

http://www.devx.com/opensource/Article/21674


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL