Use PostgreSQL's trigram indexes to make WHERE LIKE queries faster

⚡️ Database Tip

Every database performance guide is repeating the false statement stating WHERE LIKE '%search%' queries can't use an index. That is just not true! Most probably your database can't, but PostgreSQL implements trigram indexes which will make this really fast!