Full-Text Search in PostgreSQL
summary
PostgreSQL's built-in full‑text search is fully featured and can rival specialized search engines in speed and quality. The talk explains how to use PostgreSQL indexes—GIN, GiST, and the newer RUM index—covers their advantages and disadvantages, and shows how to implement document search and features like suggest/autocomplete without duplicating data.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 3:04Full-text search types
- 6:21GIN and GiST indexes
- 8:32Creating and using index
- 11:44Highlighting and ranking results
- 15:34pg_trgm for fuzzy search
- 19:12Searching JSON and arrays
- 20:57Q&A
related talks
53mFull-Text Search in PostgreSQL in Milliseconds
43mFull-Text-Search Explained from A to Z with French Food
59mFull-text search - seek and ye shall find
27mMulti-table Full Text Search with Postgres
26mA pythonic full-text search
28mElasticsearch-Quality Full-Text Search in Postgres via Tantivy
24mSearch From the Ground Up
33mPostgres, the Best Tool You're Already Using