5mins of Postgres E6: Optimizing Postgres Text Search with Trigrams and GiST indexes
Today, we're looking at optimizing Postgres text search with trigrams and take a closer look at GiST indexes.
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
📑 What we have discussed in this episode of 5mins of Postgres:
Optimizing Postgres Text Search with Trigrams - by Alex Klibisz: https://alexklibisz.com/2022/02/18/op...
Indexes in PostgreSQL — 5 (GiST): https://postgrespro.com/blog/pgsql/41...
Further helpful material:
Similarity in Postgres and Rails using Trigrams - by Leigh Halliday: https://pganalyze.com/blog/similarity...
Effective Indexing in Postgres - pganalyze eBook: https://pganalyze.com/ebooks/postgres...