No video :(

Search | Postgres.FM 090 |

Подписаться 4,1 тыс.

50% 1

[ 🇬🇧_🇺🇸 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

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 6

@andherium 4 месяца назад

Would love it if you guys could make a video on schemas and roles

@sanity_equals_nil 4 месяца назад

Would be interesting to listen about how caching is implemented in postgres.

@PostgresTV 4 месяца назад

good topic - included to the list of ideas docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6geQyHOTgdpitKCRvafCNnT-44/edit#

@maudrid 5 месяцев назад

You mentioned some pitfalls with trigram. Do you have links to any media that goes into more detail?

@NikolaySamokhvalov 4 месяца назад

Well, the bottom of the docs for pg_trgm already give an idea that things are not easy and require significant effort. a) too low level (cannot be used, for example, with full text search to have fast correction of typos without creation an additional table and a dance around it); b) under heavy loads, for large volumes, GIN fastupdate, pending lists - this will become harder and harder to tune to avoid performance issues (same thing as for any other GIN indexes in general) So these days, I would now perhaps consider some fast LLM for proper typo corrections.

@PostgresTV 4 месяца назад

also, what the bot says about it: postgres.ai/chats/018e9250-abff-73fd-af40-1b06ad17919d // Nik