Index Overhead? | Scaling Postgres 399

To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/399-index-overhead/ In this episode of Scaling Postgres, we discuss the overhead of indexes, a Postgres year in review, an intro to row locking and table renaming issues. Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/ Timestamps: 00:45 - What is index overhead on writes? 03:37 - Postgres year in review 2025 06:15 - Databases in 2025: A Year in Review 07:40 - The State of Postgres MCP Servers in 2025 09:10 - PostgreSQL: An introduction to row locking 10:20 - PostgreSQL Table Rename and Views – An OID Story 12:38 - The hidden cost of invalid indexes in Postgres (yes, even on Supabase/RDS/Neon) 16:04 - Dissecting PostgreSQL Data Corruption 16:47 - Waiting for PostgreSQL 19 – Implement ALTER TABLE … MERGE/SPLIT PARTITIONS … command 17:47 - pg_acm is here! 18:28 - Quick and dirty loading of CSV files 19:01 - Outro #postgres #postgresql