Re: fulltext search

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Sabio - PSQL <slopez_pg(at)ceroriesgo(dot)co(dot)cr>
Cc: PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: fulltext search
Date: 2005-03-17 19:16:14
Message-ID: 0800F431-9719-11D9-B97F-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David B 2005-03-17 20:09:02 Best practice - Vacuum. Replication suggestions and pg vs mysql question
Previous Message Michael Fuhr 2005-03-17 19:13:18 Re: fulltext search