Full text search | Postgres.FM 098 |

[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try TH-cam'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 www.postgresql.org/docs/curre...
* tsearch2 www.postgresql.org/docs/9.6/t...
* Dictionaries www.postgresql.org/docs/curre...
* RUM index github.com/postgrespro/rum
* Okapi BM25 en.wikipedia.org/wiki/Okapi_BM25
* tf-idf en.wikipedia.org/wiki/Tf%E2%8...
* unaccent www.postgresql.org/docs/curre...
* tsvector and tsquery www.postgresql.org/docs/curre...
* GiST indexes www.postgresql.org/docs/curre...
* GIN indexes www.postgresql.org/docs/curre...
* Controlling Text Search (including setweight function) www.postgresql.org/docs/curre...
* pg_trgrm www.postgresql.org/docs/curre...
* btree_gist www.postgresql.org/docs/curre...
* btree_gin www.postgresql.org/docs/curre...
* websearch_to_tsquery www.postgresql.org/docs/curre...
* 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 in the comments, or by tweeting us on @postgresfm / postgresfm , @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai postgres.ai/
- Michael Christofides, founder of pgMustard pgmustard.com/
~~~
This is the video version. Check out postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.