Re: indexing words

On Mon, 30 Mar 1998, Bruce Momjian wrote:

With the CLUSTER change, are things faster. Can you give me some times?
Can you supply some source to put into contrib/?

I did some timing after I clustered the data. However, I remember no
spectacular speedups. Maybe I remember wrong. I'll do the timings again
tonight and send them to you. I'd be happy to send sources to be put into
contrib, but I might need some help cleaning it up so ppl can actually
*use* it (an easy build, maybe some script to create the correct
tables/indices for a particular setup etc.)

I also think it would be nice if there was a function that could be
called to build the index *after* the main table is populated. Might be
much faster for large tables (but then again, it might not be).

Give me some time (end of the week?), I'm very busy with graduating right
now :)

Great. Remember, we have an problem with the optimizer and referencing
two tables by different names, so that may be part of the problem with
performance.

At this point, I would be interested in just hearing about single and
two word search times.

The CLUSTER really speeded up things here.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)