-
PostgreSQL Deep Dive: tsvector, tsquery, and why your full-text search results are ranked wrong
PostgreSQL Deep DivePostgreSQLFull-Text SearchtsvectorGINtsquery -
PostgreSQL Deep Dive: array types, GIN indexing, and when arrays beat normalized tables
PostgreSQL Deep DivePostgreSQLArraysGINIndexingData Types -
PostgreSQL Deep Dive: JSONB - GIN indexing, containment queries, and the performance traps that look right but run slow
PostgreSQL Deep DivePostgreSQLJSONBGINIndexingPerformance -
PostgreSQL Deep dive: GIN indexes — how Generalized Inverted Indexes power full-text search, JSONB, and array queries
PostgreSQL Deep DivePostgreSQLIndexingGINFull-Text SearchJSONBPerformance