> 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