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.

( Read more... )