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 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 …

databases postgres postgresql sql technology