Lock Causes Data To Vanish! | Scaling Postgres 406

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 how a lock can cause data to vanish, new Postgres releases, fast replication with peerDB and pg_ash for wait sampling. Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/cours... Timestamps: 00:34 - Row Locks With Joins Can Produce Surprising Results in PostgreSQL 06:00 - PostgreSQL 18.3, 17.9, 16.13, 15.17, and 14.22 Released! 07:02 - pgvector 0.8.2 Released 07:21 - Making large Postgres migrations practical: 1TB in 2 hours with PeerDB 10:24 - pg_ash 12:44 - Postgres JSONB Columns and TOAST: A Performance Guide 15:20 - Semantic Caching in PostgreSQL: A Hands-On Guide to pg_semantic_cache 16:37 - Create your PostgreSQL clusters with the "builtin" C collation! 17:33 - Inside PostgreSQL's 8KB Page 17:50 - Why it's fun to hack on Postgres performance with Tomas Vondra 18:03 - Outro #postgres #postgresql