Re: text_position worst case runtime

Tom Lane wrote:
> "Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:
> > Perhaps it would be best to add a seperate set of functions that use
> > boyer-moore, and reference them in appropriate places in the
> > documentation. Unless someone has a better idea on how we can find out
> > what people are actually doing in the field...
>
> You've obviously missed the point of my concern, which is code bloat.
> A parallel set of functions incorporating B-M would make things worse
> not better from that standpoint. (Unless you are proposing that someone
> do it as a separate pgfoundry project; which'd be fine with me. I'm
> just concerned about how much we buy into as core features.)

So why not just replace our code with better algorithms? We could use
Shift-Or or Shift-And which AFAIK are even better than Boyer-Moore.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.