Postgres 19 Revert Train! | Scaling Postgres 435

In this episode of Scaling Postgres, we discuss possibly twelve different feature reversions in Postgres 19 and why, the impact of one more index, the cost of a single insert and Neki is released.

Content Discussed

• What Is Happening with PostgreSQL 19?
• 19th Nervous Breakdown
• PostgreSQL 19: Sept 08 - Sept 16, 2026
• The unbearable lightness of one more index
• The Real Cost of a Single Insert in Postgres
• pgrust v0.3: the bug-smashing release
• Introducing Neki
• 118 million queries per second on Neki
• The lifecycle of a sharded Postgres query
• hot_standby_feedback
• Tom Lane on the Architectural Decisions That Shaped 30 Years of Postgres
• [YouTube] Celebrating 30 Years of Postgres: A Conversation with Tom Lane
• PG Phriday: The Folder That Ate the Publisher
• Row locks at the page level
• Plan Advice in PostgreSQL 19
• Inspecting a catalog with pg_migrate
• Postgres runs your query fast exactly five times. Then it changes its mind.
• Looking Forward to PG Summit 2026
• Postgres development activity
• PostgreSQL Commitfest Metrics: PGConf.dev 2026 Part One
• Your Agent Can Turn Off Its Own Kill Switch
• Misc Learnings: SBOMs, Provenance and Attestations
• Agents Gone Awry on Postgres SBOMs: Start Over
• Optimising PostgreSQL Aggregates: What Can an Extension Do?
• How to De-Risk a Mission-Critical PostgreSQL Migration
• Contributions for week 36
• Introducing TIN: full-text search for Postgres
• Troubleshooting row lock contention in Amazon Aurora PostgreSQL: Part 1 – Understanding row lock contention in PostgreSQL
• Resolve Amazon Aurora PostgreSQL lock contention with Database Insights: Part 2

YouTube Video

Podcast Audio