Re: full-text indexing

> Does anyone have any experience using Postgres's full-text indexing in a
> production environment?  We're thinking about using it for a project (the
> other solution is to regexp it with Perl...).  I've set up the stuff
> before for experimentation, but am mainly curious about it's performance
> on a live, fairly heavily trafficked server.

I have one word for you:  CLUSTER.  Without it, index lookups are too
slow.  With it, they are rapid.  I have done some work like this
commerically with Ingres, which has an ISAM type that keeps the matching
rows pretty close on a newly-created ISAM index.  In PostgreSQL, and
regular CLUSTER will keep you good.

If you find it slow, let me know.  I have done some benchmarking with
the author and he found it pretty fast, usually a few seconds.  See the
section in my book on CLUSTER for information on _why_ it helps.

http://www.postgresql.org/docs/awbook.html


--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026