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: https://www.levels.fyi/blog/scalable-search-with-postgres.html

#systemdesign #postgresql #database