Preparing For Postgres 18 | Scaling Postgres 384

In this episode of Scaling Postgres, we discuss getting excited about Postgres 18, oauth authentication, reconsidering your interface and a zero downtime upgrade.

Content Discussed

• Get Excited About Postgres 18
• pgwatch v4-beta is out!
• Fine Tuning Incremental Backup
• Preview PostgreSQL 18’s OAuth2 Authentication (1) - Explore How it Works
• Preview PostgreSQL 18’s OAuth2 Authentication (2) - Building a Custom OAuth2 Validator by Rust
• Reconsidering the interface
• Sharding our core Postgres database (without any downtime)
• Zero downtime Postgres upgrades using logical replication
• Defense in Depth for MCP Servers
• PostgreSQL maintenance without superuser
• How to handle "database is not accepting commands"
• turbopuffer
• Hacking Workshop for October 2025
• 2025 PostGIS & GEOS Release
• Easier Postgres fine-tuning with online_advisor
• How to implement the Outbox pattern in Go and Postgres
• Waiting for PostgreSQL 19 – Add date and timestamp variants of random(min, max).
• Oldest recorded transaction
• Making Postgres scale to zero with CNPG
• PostgreSQL CDC to JDBC Sink – minimal event driven architecture
• The Cost of TDE and Checksums in PGEE
• September PUG recording
• Contributions for the week 37
• PgPedia Week, 2025-08-31
• PgPedia Week, 2025-09-07
• Processing large jobs with Edge Functions, Cron, and Queues

YouTube Video

Podcast Audio