150 Times Faster pgvector? | Scaling Postgres 314

To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/314-150-times-faster-pgvector/ 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: https://www.scalingpostgres.com/courses/postgresql-performance-starter-kit/ 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