Uploaded March 2026 | Updated September 2026, 1 week ago
Talk by Christophe Pettus
socallinuxexpo.org/scale/23x/presentations/full-text-search-next-generation
PostgreSQL has had integrated full-text search since version 8.3 (and before that using the tsearch2 extension)… that's over 17 years of searching. New technologies have emerged since then to make searching a large corpus of text even more efficient, accurate, and useful.
This talk dives into new extensions and methods of doing full-text search: New algorithms like BM25, new approaches like pgvector, and how to combine them to create hybrid search methods.
Talk by Christophe Pettus
socallinuxexpo.org/scale/23x/presentations/full-text-search-next-generation
PostgreSQL has had integrated full-text search since version 8.3 (and before that using the tsearch2 extension)… that's over 17 years of searching. New technologies have emerged since then to make searching a large corpus of text even more efficient, accurate, and useful.
This talk dives into new extensions and methods of doing full-text search: New algorithms like BM25, new approaches like pgvector, and how to combine them to create hybrid search methods.
