Full text search | Postgres.FM 098 | #PostgreSQL #Postgres podcast

[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!] 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 in the comments, or by tweeting us on @postgresfm https://twitter.com/PostgresFM, @samokhvalov https://twitter.com/samokhvalov and @michristofides https://twitter.com/michristofides ~~~ Postgres FM is brought to you by: - Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/ - Michael Christofides, founder of pgMustard https://pgmustard.com/ ~~~ This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.