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