Published On Sep 29, 2024
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...
In this episode of Scaling Postgres, we discuss the release of Postgres 17, b-tree performance gains, logical replication enhancements and different levels of performance tuning.
Want to learn more about Postgres performance?
Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/cours...
Timestamps:
00:00 - Intro
00:28 - PostgreSQL 17 Released!
03:43 - Real World Performance Gains With Postgres 17 B-tree Bulk Scans
06:02 - Online Upgrading Logical and Physical Replication Nodes
09:45 - PostgreSQL Performance Tuning: Optimize Your Database Server
11:41 - Planning time
14:19 - Building an image search engine on Postgres
15:50 - Building an AI Image Gallery: Advanced RAG With Pgvector and Claude Sonnet 3.5
16:12 - A few secure, random bytes without `pgcrypto`
17:23 - CNPG Playground: A New Learning Environment for Postgres in Kubernetes
18:06 - Outro
#postgres #postgresql