Обсуждение: fulltext search

Поиск
Список
Период
Сортировка

fulltext search

От
Sabio - PSQL
Дата:
how to implement a fulltext search on table with a varchar(300) field
and over 6 millions of records?

Re: fulltext search

От
Michael Fuhr
Дата:
On Thu, Mar 17, 2005 at 09:33:44AM -0600, Sabio - PSQL wrote:

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

See contrib/tsearch2.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Re: fulltext search

От
John DeSoi
Дата:
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