-
PostgreSQL Deep Dive: tsvector, tsquery, and why your full-text search results are ranked wrong
PostgreSQL Deep DivePostgreSQLFull-Text SearchtsvectorGINtsquery -
PostgreSQL Deep dive: GIN indexes — how Generalized Inverted Indexes power full-text search, JSONB, and array queries
PostgreSQL Deep DivePostgreSQLIndexingGINFull-Text SearchJSONBPerformance