4 ms·
Queries with %text% syntax do not use indexes by default. You can use trgm module to index this kind of queries. https://www.postgresql.org/docs/9.1/static/pg
by vlplabs 9y ago
Queries with %text% syntax do not use indexes by default.
You can use trgm module to index this kind of queries.
https://www.postgresql.org/docs/9.1/static/pgtrgm.html https://www.postgresql.org/docs/9.1/static/pgtrgm.html
- justinclift 9y agoProb better to point to the current (9.6) version of that doc, rather than the no-longer-supported ancient v9.1 version. There are some differences. :) https://www.postgresql.org/docs/current/static/pgtrgm.html https://www.postgresql.org/docs/current/static/pgtrgm.html