[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try RU-vid'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:717870...
* Companion databases episode postgres.fm/ep...
* pgvector episode postgres.fm/ep...
* Full Text Search www.postgresql...
* Semantic search en.wikipedia.o...
* Faceted search en.wikipedia.o...
* Faceting large result sets in PostgreSQL www.cybertec-p...
* RUM index github.com/pos...
* Hybrid search (Supabase guide) supabase.com/d...
* Elastic www.elastic.co/
* GiST indexes www.postgresql...
* GIN indexes www.postgresql...
* btree_gist www.postgresql...
* btree_gin www.postgresql...
* pg_trgrm www.postgresql...
* Text Search Types (tsvector and tsquery) www.postgresql...
* Postgres full text search with the “websearch” syntax (blog post by Adam Johnson) adamj.eu/tech/...
* Understanding Postgres GIN Indexes: The Good and the Bad (blog post by Lukas Fittl) pganalyze.com/...
* ParadeDB www.paradedb.com/
* ZomboDB www.zombodb.com/
* Introduction to Information Retrieval (book by Manning, Raghavan, and Schütze) www.amazon.co....
* How to build a search engine with Ruby on Rails (blog post by Justin Searls) blog.testdoubl...
~~~
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.
26 авг 2024