> 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
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(at)candle(dot)pha(dot)pa(dot)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)
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 1998-03-31 15:51:34|
|Subject: Re: [HACKERS] StrNCpy|
|Previous:||From: Boersenspielteam||Date: 1998-03-31 12:30:35|
|Subject: Re: [HACKERS] Reminder: Indices are not used|