PostgreSQL: Publishing Power-Up and Performance Gains
A substantial day for PostgreSQL with major improvements to logical replication through the new EXCEPT TABLE functionality in publications, plus a significant performance boost by switching the default TOAST compression from pglz to LZ4. Additional testing improvements and code cleanups round out a productive development cycle.
Duration: PT4M6S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-03-04T11:17:48Z
- Audio duration: PT4M6S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
Hey there, developers! Welcome back to another episode of the PostgreSQL podcast. I'm your host, and wow, do we have some exciting changes to dive into today - March 4th, 2026. Grab your coffee because we're talking about some really impactful improvements that landed in the PostgreSQL codebase.
Let's jump right into the biggest story of the day, and it's all about making logical replication more flexible and powerful. Amit Kapila merged a fantastic feature that extends CREATE PUBLICATION with EXCEPT TABLE syntax. Now, I know that might sound technical, but here's why this is actually a game-changer for…
Picture this scenario: you want to replicate almost all of your tables to a subscriber, but maybe you have some sensitive data tables or temporary tables that you absolutely don't want replicated. Before this change, you'd have to explicitly list every single table you DID want to replicate. Now? You can just say…
What's really elegant about this implementation is how they handled partitioned tables. When you exclude a root table, it automatically excludes all current AND future partitions in that tree. That's the kind of forward-thinking design that saves you from headaches down…
Thi…