Tag: search

All posts with tag "search".

• Pg Trgm Trigram Similarity Vs Ilike Laravel: Postgresql Performance Guide

  16 Mar, 2026

  Standard B-tree indexes cannot optimize partial substring searches (e.g., `WHERE name ILIKE '%john%'`), forcing PostgreSQL to perform a full sequential tab...