Biscuit is a specialized PostgreSQL index for fast pattern matching LIKE queries
SMRTR summary
Biscuit is a new PostgreSQL index access method that dramatically speeds up LIKE and ILIKE pattern matching queries by using bitmap position indices. Unlike trigram indexes, it eliminates recheck overhead and delivers exact results with no false positives. The latest update adds memory introspection utilities and performance improvements, making it ideal for wildcard-heavy queries and multi-column searches.
SMRTR provides this summary for quick context. The original article belongs to Lobsters.
Read the original article