select * from depesz;

thomas reiss just published his follow up to my post about indexed searches in “like ‘%something’” cases.

i don’t understand french so i can’t tell what exactly he wrote, but i understand c code and graphs

basically - he wrote c function that does reverse() of strings, and benchmarked it against pl/pgsql and pl/perl versions. of course c version is the fastest, but just take a look at how much faster it is. and how simple it is.