Designing full-text search system with Postgres

In this video, we go over ideas from a blog post from levels.fyi on how they built a search system on top of Postgres. Postgres is one of the most popularly used databases out there and learning how to build full text search with postgres will be very useful.
Contents:
0:00 - 00:35 Intro / Why use postgres?
00:35 - 01:38 Use-case of levels.fyi
01:38 - 02:28 Searching using ILIKE
02:28 - 02:40 Optimizing using Indexing
02:40 - 03:18 Optimizing using Materialized views
03:18 - 04:16 Handling stale data with materialized views
04:16 - 04:49 Problems with ILIKE matching
04:49 - 06:07 to_tsvector in postgres
06:07 - 07:07 to_tsquery in postgres
07:08 - 07:54 to_tsrank in postgres and using it.
07:54 - 09:33 Inverted Indexes
09:33 - 10:15 Trigram Inverted index
10:15 - 11:34 More changes by levels.fyi
11:34 - 11:53 Outro
Full blog link: www.levels.fyi/blog/scalable-...
#systemdesign #postgresql #database

[@abhijitsethi135]

Great Video! Really well put together. Thanks for linking the blog in the desc

[@Sandeep-zd6dq]

Nice video, It’s nice to see that we can built an efficient search engine using our traditional data sources 🙌

[@core_dump]

Postgres is evergreen

[@JenilCalcuttawala]

wow. great content! definitely need more explainer videos from you on those indexes.

[@core_dump]

Thanks! Absolutely will make more content around indexes, it will take some time though, I want to explain more kinds of indexes with some code.

[@premdasv8]

This was really informative, Thanks you.

[@PavanKumar-zk1ob]

This is a great video , thanks for the content

[@adamrizk6735]

Awesome presentation you deserve more followers

[@core_dump]

I appreciate that! Do share the videos!

[@priyanshuindra4648]

Very nice video... Very Informative

[@core_dump]

Thanks a lot

[@thinker21]

great video, thanks!

[@core_dump]

Glad you liked it!

[@lehoangngo8201]

In 2:21, isn't "jp%" is try to match c.name with prefix "jp" ?

[@arogyabichpuria3262]

super good vid :)

[@core_dump]

Glad you enjoyed it

[@shibasispatel6624]

my TIL today. Very interesting video bro.

[@core_dump]

Hope you enjoyed it!

[@user-dc9zo7ek5j]

Interesting, a while ago I have made a boolean search (something and something 2 or other thing) and it was pretty primitive, just a lot of joins and subqueries, but hey, it works... :D

[@core_dump]

If it works, its enough

[@shadowfire779]

u the goat

[@core_dump]

Thanks!

[@Ashish_singh_dev]

Talk is cheap show me the code

[@core_dump]

thought to write up some sample code ... but I was too lazy :(