Boyer-More-Horspool searching LIKE queries

total := total + cnt; END LOOP; RAISE NOTICE 'TOTAL: %', total; END $$ ; -- -- -- -- -- -- -- Result Without patch: 257.504ms With patch: 191.638ms Regards, Atsushi Ogawa like_bmh.patch Description: Binary data

Re: Boyer-More-Horspool searching LIKE queries

bly OK, the overhead is > probably small, and those cases are probably not performance-critical. > But would be nice to measure that too. I tried to measure the case where LIKE is executed only once and the haystack string are very small. --- SET client_m