PostgreSQL
Indexing Full Text Search With GIN in PostgreSQL Tables
Index PostgreSQL full text search with GIN: how it works, GIN versus GiST, fastupdate and the pending list, build time, size and when the planner skips it.
7 min read
Topic
Performance
Why the query is slow, and what to change about it. Execution plans, statistics, caching and rewrites, with the numbers to prove it.
Get new articles by email
We send one email when a new article is published. No spam.