Lock Causes Data To Vanish! | Scaling Postgres 406

In this episode of Scaling Postgres, we discuss how a lock can cause data to vanish, new Postgres releases, fast replication with peerDB and pg_ash for wait sampling.

Content Discussed

• Row Locks With Joins Can Produce Surprising Results in PostgreSQL
• PostgreSQL 18.3, 17.9, 16.13, 15.17, and 14.22 Released!
• pgvector 0.8.2 Released
• Making large Postgres migrations practical: 1TB in 2 hours with PeerDB
• pg_ash
• Postgres JSONB Columns and TOAST: A Performance Guide
• Semantic Caching in PostgreSQL: A Hands-On Guide to pg_semantic_cache
• Create your PostgreSQL clusters with the "builtin" C collation!
• Inside PostgreSQL's 8KB Page
• Why it's fun to hack on Postgres performance with Tomas Vondra
• The real cost of random I/O
• What Does INSERT 0 1 Actually Tell You?
• February Meetup: slides and recording are available!
• 9 Advanced PostgreSQL Features I Wish I Knew Sooner
• Harnessing Postgres race conditions
• The AI inversion
• A reponsible role for AI in Open Source projects?
• The End of the Monolithic Image: Dynamic Extensions in Kubernetes with PostgreSQL 18
• Per-worker, and global, IO bandwidth in explain plans
• Waiting for PostgreSQL 19 – psql: Add %i prompt escape to indicate hot standby status.
• Waiting for PostgreSQL 19 – Allow log_min_messages to be set per process type
• Monitoring PostgreSQL on Windows with PgHero and Docker
• Building Ask Ellie: A RAG Chatbot Powered by pgEdge
• Upgrading PostgreSQL in place on FreeBSD
• Fixing ORM Slowness by 80% with Strategic PostgreSQL Indexing
• Contributions for week 7, 2026
• The schedule for PGConf.DE 2026 is now live!
• Faster PlanetScale Postgres connections with Cloudflare Hyperdrive
• Vertical Scaling: Buying Time You Can't Afford Vertical Scaling: Buying Time You Can't Afford
• Understanding Postgres Performance Limits for Analytics on Live Data
• Replicate spatial data using AWS DMS and Amazon RDS for PostgreSQL

YouTube Video

Podcast Audio