Re: full-text indexing

> At 08:40 PM 18/04/00 -0400, Bruce Momjian wrote:
>
> >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.
>
> The only down side of CLUSTER is that you loose your other keys on the
> table, including a primary key, so you loose out on your intregrity checks,
> which you the have to explictily re-apply with CREATE UNQIUE INDEX ...
>

Yes, you basically have to recreate them after CLUSTER.

--
  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