Lépjen offline állapotba az Player FM alkalmazással!
Full text search
Manage episode 420000833 series 3369151
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
119 epizódok
Manage episode 420000833 series 3369151
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
119 epizódok
ทุกตอน
×Üdvözlünk a Player FM-nél!
A Player FM lejátszó az internetet böngészi a kiváló minőségű podcastok után, hogy ön élvezhesse azokat. Ez a legjobb podcast-alkalmazás, Androidon, iPhone-on és a weben is működik. Jelentkezzen be az feliratkozások szinkronizálásához az eszközök között.