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