Скачать или смотреть Search | Postgres.FM 090 |

[ 🇬🇧_🇺🇸 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 have a high-level discussion on all things search — touching on full-text search, semantic search, and faceted search. They discuss what comes in Postgres core, what is possible via extensions, and some thoughts on performance vs implementation complexity vs user experience.

Here are some links to things they mentioned:

Simon Riggs   / urn:li:activity:7178702287740022784  
Companion databases episode https://postgres.fm/episodes/companio...
pgvector episode https://postgres.fm/episodes/pgvector
Full Text Search https://www.postgresql.org/docs/curre...
Semantic search https://en.wikipedia.org/wiki/Semanti...
Faceted search https://en.wikipedia.org/wiki/Faceted...
Faceting large result sets in PostgreSQL https://www.cybertec-postgresql.com/e...
RUM index https://github.com/postgrespro/rum
Hybrid search (Supabase guide) https://supabase.com/docs/guides/ai/h...
Elastic https://www.elastic.co/
GiST indexes https://www.postgresql.org/docs/curre...
GIN indexes https://www.postgresql.org/docs/curre...
btree_gist https://www.postgresql.org/docs/curre...
btree_gin https://www.postgresql.org/docs/curre...
pg_trgrm https://www.postgresql.org/docs/curre...
Text Search Types (tsvector and tsquery) https://www.postgresql.org/docs/curre...
Postgres full text search with the “websearch” syntax (blog post by Adam Johnson) https://adamj.eu/tech/2024/01/03/post...
Understanding Postgres GIN Indexes: The Good and the Bad (blog post by Lukas Fittl) https://pganalyze.com/blog/gin-index
ParadeDB https://www.paradedb.com/
ZomboDB https://www.zombodb.com/
Introduction to Information Retrieval (book by Manning, Raghavan, and Schütze) https://www.amazon.co.uk/Introduction...
How to build a search engine with Ruby on Rails (blog post by Justin Searls) https://blog.testdouble.com/posts/202...



~~~


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