Re: fulltext search - Mailing list pgsql-admin

From John DeSoi
Subject Re: fulltext search
Date
Msg-id 0800F431-9719-11D9-B97F-000A95B03262@pgedit.com
Whole thread Raw
In response to fulltext search  (Sabio - PSQL <slopez_pg@ceroriesgo.co.cr>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: fulltext search
Next
From: David B
Date:
Subject: Best practice - Vacuum. Replication suggestions and pg vs mysql question