Re: Boyer-More-Horspool searching LIKE queries

SET client_min_messages TO notice; \timing DO $$ DECLARE cnt integer := 0; total integer := 0; BEGIN FOR i IN 1..1 LOOP select count(*) into cnt from pg_class where oid = 2662 and relname like '%cl%'; total := total + cnt; END LOOP; RAIS

Boyer-More-Horspool searching LIKE queries

END $$ ; -- -- -- -- -- -- -- Result Without patch: 257.504ms With patch: 191.638ms Regards, Atsushi Ogawa like_bmh.patch Description: Binary data