To get the show notes as well as get notified of new episodes, visit:
www.scalingpostgres.com/episo...
In this episode of Scaling Postgres, we discuss performance improvements for pgvector 0.7.0, a guide to vector embeddings, building a Retrieval Augmented Generation app and only allow logins to replicas.
Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: www.scalingpostgres.com/cours...
Timestamps:
00:00 - Intro
00:11 - The 150X PGVECTORSPEEDUP: A YEAR-IN-REVIEW
06:12 - pgvector 0.7.0 Released!
06:33 - A Beginner's Guide to Vector Embeddings
08:39 - PG Phriday: Papa's got a Brand New RAG
09:52 - Boost Database Security: Restrict Users to Read Replicas
10:39 - Buffers 2 (the sequel)
11:46 - Waiting for Postgres 17: Streaming I/O for sequential scans & ANALYZE
12:40 - When and Why PostgreSQL Indexxes Are Ignored
14:11 - Nightly Postgres Backups vie GitHub Actions
15:15 - Why PostgreSQL Is the Bedrock for the Future of Data
16:03 - Outro
#postgres #postgresql