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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
