Wildspeed for Postgres - a fast wildcard search for LIKE operator

[obartunov]

This is a technical and mostly historical post !

our pg_trgm extension since 9.1 supports index searches for LIKE, ILIKE with comparable performance and much smaller size !

What if you want to search %asd% pattern and do it fast ? Wildspeed extension provides GIN index support for wildcard search for LIKE operator.

Comments

[ext_3724456]

What's the benefit over using trigrams w/ the existing built-in functionality (http://blog.scoutapp.com/articles/2016/07/12/how-to-make-text-searches-in-postgresql-faster-with-trigram-similarity)?

[obartunov]

This post is historical, I copy-pasted it from http://www.sai.msu.su/~megera/wiki/wildspeed to save content. I added link to our pg_trgm extension, which since 9.1 supports LIKE, ILIKE with comparable performance and much smaller size of index. I didn't make any serious benchmarks.

ILIKE support

[ext_3774584]

This is great. Is there a way to support ILIKE as well?

Re: ILIKE support

[obartunov]

Regina,

this post about wildspeed is technical to save content from http://www.sai.msu.su/~megera/wiki/wildspeed

pg_trgm supports LIKE, ILIKE and does it with comparable performance and much smaller index size.