To get the show notes as well as get notified of new episodes, visit: In this episode of Scaling Postgres, we discuss getting excited about Postgres 18, oauth authentication, reconsidering your interface and a zero downtime upgrade. Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: Timestamps: 00:31 - Get Excited About Postgres 18 03:38 - pgwatch v4-beta is out! 04:09 - Fine Tuning Incremental Backup 05:31 - Preview PostgreSQL 18’s OAuth2 Authentication (1) - Explore How it Works 05:46 - Preview PostgreSQL 18’s OAuth2 Authentication (2) - Building a Custom OAuth2 Validator by Rust 05:58 - Reconsidering the interface 09:05 - Sharding our core Postgres database (without any downtime) 11:47 - Zero downtime Postgres upgrades using logical replication 12:23 - Defense in Depth for MCP Servers 14:20 - PostgreSQL maintenance without superuser 15:38 - How to handle "database is not accepting commands" 16:08 - turbopuffer 17:06 - Outro #postgres #postgresql