Index Overhead? | Scaling Postgres 399

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.

Content Discussed

• What is index overhead on writes?
• Postgres year in review 2025
• Databases in 2025: A Year in Review
• The State of Postgres MCP Servers in 2025
• PostgreSQL: An introduction to row locking
• PostgreSQL Table Rename and Views – An OID Story
• The hidden cost of invalid indexes in Postgres (yes, even on Supabase/RDS/Neon)
• Dissecting PostgreSQL Data Corruption
• Waiting for PostgreSQL 19 – Implement ALTER TABLE … MERGE/SPLIT PARTITIONS … command
• pg_acm is here!
• Quick and dirty loading of CSV files
• PostgreSQL 18 RETURNING Enhancements: A Game Changer for Modern Applications
• Stabilizing Benchmarks
• Exploration: CNPG Logical Replication in PostgreSQL
• PostgreSQL Scripting Tips
• Chaos testing the CloudNativePG project
• Sticking with Open Source: pgEdge and CloudNativePG
• Inventing A Cost Model for PostgreSQL Local Buffers Flush
• New PostgreSQL Contributors December 2025
• Small improvement for pretty-printing in paste.depesz.com
• PostgreSQL Meetup in Frankfurt December 2025
• PgPedia Week, 2025-12-07
• PgPedia Week, 2025-12-14
• Implement multi-Region endpoint routing for Amazon Aurora DSQL
• Supabase Security Retro: 2025
• Introducing TRAE SOLO integration with Supabase

YouTube Video

Podcast Audio