Re: text_position worst case runtime

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: text_position worst case runtime
Дата
Msg-id 4512.1148077116@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: text_position worst case runtime  (Hannu Krosing <hannu@skype.net>)
Ответы Re: text_position worst case runtime
Re: text_position worst case runtime
Список pgsql-hackers
Hannu Krosing <hannu@skype.net> writes:
> I guess our regex implementation already uses boyer-moore or similar.
> Why not just expose the match position of substring('text' in 'regex')
> using some function, called  match_position(int searched_text, int
> regex, int matchnum) ?

If it did that might be a nice solution, but I'm not sure that it does
use B-M ... I can't find either "Boyer" or "Moore" in its source code.

There's no particular reason to suppose offhand that a regex engine
would be faster than the naive code for fixed patterns.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Compression and on-disk sorting
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Compression and on-disk sorting