Full text search

Nikolay and Michael discuss full text search in Postgres — some of the history, some of the features, and whether it now makes sense to try to replace or combine it with semantic search.

Here are some links to things they mentioned:
• Full Text Search postgresql.org/docs/current/textsearch.html
• tsearch2 postgresql.org/docs/9.6/tsearch2.html
• Dictionaries postgresql.org/docs/current/textsearch-diction…
• RUM index github.com/postgrespro/rum
• Okapi BM25 en.wikipedia.org/wiki/Okapi_BM25
• tf–idf en.wikipedia.org/wiki/Tf%E2%80%93idf
• unaccent postgresql.org/docs/current/unaccent.html
• tsvector and tsquery postgresql.org/docs/current/datatype-textsearc…
• GiST indexes postgresql.org/docs/current/gist.html
• GIN indexes postgresql.org/docs/current/gin.html
• Controlling Text Search (including setweight function) postgresql.org/docs/current/textsearch-control…
• pg_trgrm postgresql.org/docs/current/pgtrgm.html
• btree_gist postgresql.org/docs/current/btree-gist.html
• btree_gin postgresql.org/docs/current/btree-gin.html
• websearch_to_tsquery postgresql.org/docs/current/textsearch-control…
• pgvector github.com/pgvector/pgvector
• Our previous episode on search postgres.fm/episodes/search

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is brought to you by:
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)
• Michael Christofides, founder of pgMustard (pgmustard.com)
With special thanks to:
• Jessie Draws (jessiedraws.com) for the amazing artwork