Indexes

When a LIKE '%value%' Slows Everything Down: A Real PostgreSQL Optimization Case

PostgreSQL optimization: LIKE '%value%' causes full scan. Using pg_trgm and GIN index to turn a wildcard search into a fast lookup. Real case.