Tom Lane kirjutas K, 05.02.2003 kell 01:35:
> Neil Conway <[EMAIL PROTECTED]> writes:
> > Speaking of which, is there (or should there be) some mechanism for
> > increasing the size of the compiled pattern cache? Perhaps a GUC var?
> I thought about that while I was messing with the code, but I don't
> think there's much point in it, unless someone wants to invest the work
> to make the cache search much smarter (maybe a hash table?). At present
> a larger cache will cost you in extra search time, especially in the
> case where the pattern isn't in the cache.
> I did do the work last night to convert the cache management algorithm
> into a self-organizing list (a la Knuth) rather than a round-robin
> search as it was before. This should reduce the expected number of
> comparisons for cases where the cache is actually accomplishing
> something, but of course it's no help if you have too many patterns
> for the cache.
Perhaps the decision weather to try to use the cache at all could be
done at planning time depending on statistics information ?
Another idea is to make special regex type and store the regexes
pre-parsed (i.e. in some fast-load form) ?
Hannu Krosing <[EMAIL PROTECTED]>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly