Full text search

Postgres FM

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 https://www.postgresql.org/docs/current/textsearch.html
• tsearch2 https://www.postgresql.org/docs/9.6/tsearch2.html
• Dictionaries https://www.postgresql.org/docs/current/textsearch-dictionaries.html
• RUM index https://github.com/postgrespro/rum
• Okapi BM25 https://en.wikipedia.org/wiki/Okapi_BM25
• tf–idf https://en.wikipedia.org/wiki/Tf%E2%80%93idf
• unaccent https://www.postgresql.org/docs/current/unaccent.html
• tsvector and tsquery https://www.postgresql.org/docs/current/datatype-textsearch.html
• GiST indexes https://www.postgresql.org/docs/current/gist.html
• GIN indexes https://www.postgresql.org/docs/current/gin.html
• Controlling Text Search (including setweight function) https://www.postgresql.org/docs/current/textsearch-controls.html
• pg_trgrm https://www.postgresql.org/docs/current/pgtrgm.html
• btree_gist https://www.postgresql.org/docs/current/btree-gist.html
• btree_gin https://www.postgresql.org/docs/current/btree-gin.html
• websearch_to_tsquery https://www.postgresql.org/docs/current/textsearch-controls.html#TEXTSEARCH-PARSING-QUERIES
• pgvector https://github.com/pgvector/pgvector
• Our previous episode on search https://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, or by commenting on our Google doc!

~~~

Postgres FM is brought to you by:

• Nikolay Samokhvalov, founder of Postgres.ai
• Michael Christofides, founder of pgMustard

With special thanks to:

• Jessie Draws for the amazing artwork