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


--
Kumera - a new Open Source Content Management System
for small to medium web sites written in Perl and using XML
http://www.cyber4.org/kumera/index.html