0ans180viewsWhy is my SQL query with LIKE '%term%' so slow on a large table, and how do I speed it up?DevelopmentDevelopmentfull-text-searchindexingperformancepostgresqlsqlintermediateasked 12 Jul 2026by Tai