{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Full text search","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/81dab17b\"></iframe>","width":"100%","height":180,"duration":3020,"description":"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.\n \nHere are some links to things they mentioned:\nFull Text Search https://www.postgresql.org/docs/current/textsearch.html\ntsearch2 https://www.postgresql.org/docs/9.6/tsearch2.html\nDictionaries https://www.postgresql.org/docs/current/textsearch-dictionaries.html \nRUM index https://github.com/postgrespro/rum \nOkapi BM25 https://en.wikipedia.org/wiki/Okapi_BM25 \ntf–idf https://en.wikipedia.org/wiki/Tf%E2%80%93idf \nunaccent https://www.postgresql.org/docs/current/unaccent.html \ntsvector and tsquery https://www.postgresql.org/docs/current/datatype-textsearch.html \nGiST indexes https://www.postgresql.org/docs/current/gist.html \nGIN indexes https://www.postgresql.org/docs/current/gin.html \nControlling Text Search (including setweight function) https://www.postgresql.org/docs/current/textsearch-controls.html \npg_trgrm https://www.postgresql.org/docs/current/pgtrgm.html \nbtree_gist https://www.postgresql.org/docs/current/btree-gist.html \nbtree_gin https://www.postgresql.org/docs/current/btree-gin.html \nwebsearch_to_tsquery https://www.postgresql.org/docs/current/textsearch-controls.html#TEXTSEARCH-PARSING-QUERIES  \npgvector https://github.com/pgvector/pgvector \nOur previous episode on search https://postgres.fm/episodes/search \n\n~~~\nWhat 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!\n\n~~~\nPostgres FM is brought to you by:\nNikolay Samokhvalov, founder of Postgres.ai\nMichael Christofides, founder of pgMustard\nWith special thanks to:\nJessie Draws for the amazing artwork ","thumbnail_url":"https://img.transistorcdn.com/NFbJlGhGV5mzIU1kM0iZ823A69pjZUNX40LszVO5LKI/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}