{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Search","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/6fd58f1f\"></iframe>","width":"100%","height":180,"duration":2492,"description":"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.\n \nHere are some links to things they mentioned:\nSimon Riggs https://www.linkedin.com/feed/update/urn:li:activity:7178702287740022784/\nCompanion databases episode https://postgres.fm/episodes/companion-databases\npgvector episode https://postgres.fm/episodes/pgvector\nFull Text Search https://www.postgresql.org/docs/current/textsearch.html\nSemantic search https://en.wikipedia.org/wiki/Semantic_search\nFaceted search https://en.wikipedia.org/wiki/Faceted_search\nFaceting large result sets in PostgreSQL https://www.cybertec-postgresql.com/en/faceting-large-result-sets/\nRUM index https://github.com/postgrespro/rum \nHybrid search (Supabase guide) https://supabase.com/docs/guides/ai/hybrid-search \nElastic https://www.elastic.co/ \nGiST indexes https://www.postgresql.org/docs/current/gist.html \nGIN indexes https://www.postgresql.org/docs/current/gin.html \nbtree_gist https://www.postgresql.org/docs/current/btree-gist.html \nbtree_gin https://www.postgresql.org/docs/current/btree-gin.html \npg_trgrm https://www.postgresql.org/docs/current/pgtrgm.html \nText Search Types (tsvector and tsquery) https://www.postgresql.org/docs/current/datatype-textsearch.html \nPostgres full text search with the “websearch” syntax (blog post by Adam Johnson) https://adamj.eu/tech/2024/01/03/postgresql-full-text-search-websearch/\nUnderstanding Postgres GIN Indexes: The Good and the Bad (blog post by Lukas Fittl) https://pganalyze.com/blog/gin-index \nParadeDB https://www.paradedb.com/ \nZomboDB https://www.zombodb.com/ \nIntroduction to Information Retrieval (book by Manning, Raghavan, and Schütze) https://www.amazon.co.uk/Introduction-Information-Retrieval-Christopher-Manning/dp/0521865719 \nHow to build a search...","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}