Skip to content
PodSubs
ShowsPeopleGuestsJobsNewsEvents
More
BlogPodCred
Menu
ShowsPeopleGuestsJobsNewsEventsBlogPodCredNetworksSign in
Join nowSign in
  • Shows
  • People
  • Jobs
  • News
  • More
    • Guests
    • Events
    • Blog
    • PodCred
    • Networks
    Join nowSign in

DEV

DEV artwork

PostgreSQL Logical Replication: Multi-Region Architecture That Actually Works

Sep 27, 20265 minAudio

Multi-region database architecture is one of the most consequential decisions an engineering team can make - and PostgreSQL logical replication is increasingly the tool teams reach for to get it right. This episode of DEV.co walks through the full picture: how logical replication actually works under the hood, what a sound multi-region topology looks like, and where teams consistently stumble when moving from theory to production. The discussion is grounded in the deep-dive guide on PostgreSQL logical replication for multi-region systems, and goes further by unpacking the practical trade-offs that determine whether your setup holds up at two in the morning. Here's what this episode covers: Logical vs. physical replication: Why logical replication decodes row-level changes from the WAL and ships them as SQL - giving you per-table precision, column filtering, and cross-version flexibility that physical streaming can't offer. Publisher/subscriber topology: How to structure a primary-region publisher with regional subscribers, seed initial data, and keep replication lag small and predictable under real traffic. Lag monitoring done right: Why byte lag and time lag are both required metrics, how a subscriber can appear healthy while quietly accumulating a backlog, and why tuning the WAL sender side is often the more impactful lever - especially for teams running multi-region cloud deployments across intercontinental links. Write ownership and conflict avoidance: Why keeping writes centralized in the primary region is the safest default, when tenant-partitioned multi-region writes make sense, and how to structure foreign keys and sequences before cross-region conflicts become a production problem. Tuning for transoceanic links: The apply batch size sweet spot (around 5,000 rows), conservative connection timeouts, and why chatty application patterns that assume low latency will hurt on long-haul links. Failover and rehearsal: How a practiced subscriber-to-publisher promotion can be a seven-minute operation - versus a four-hour cold recovery - and why a written runbook without drills is only half the preparation. The episode also flags common pitfalls: replicating every table indiscriminately, allowing schema drift across regions, running large table rewrites during peak windows, and forgetting that unlogged tables don't replicate at all. The consistent theme is that multi-region PostgreSQL rewards architecture decisions made before the first subscription is created, not after traffic has already surfaced the gaps. For more from the show, check out the episode C# Source Generators: Writing Less Code by Letting the Compiler Do More. DEV.co RFP.co

Audio and video play straight from the show's own hosting. PodSubs stores and serves no media.

Hosts and Guests

Nobody is credited on this episode yet.

Credit the people on this episode

Be the first to rate this episode

More episodes

All episodes
  1. The U.S. Has More Data Centers Than the Next 14 Countries Combined

    Nov 20, 20265 minAudio

    The global data center map looks lopsided by any measure - but the full picture is more striking than a simple site count suggests. This episode of DEV.co digs into a newly published graphic analysis showing just how...

    Credit the people on this episode

  2. From $30 Million to $5 Billion: The AI App Explosion by the Numbers

    Nov 18, 20265 minAudio

    The generative AI app market has posted one of the most dramatic growth curves in consumer software history - and the numbers behind that curve reveal a story far more nuanced than the headline figure suggests. This...

    Credit the people on this episode

  3. AI Adoption: Why the Numbers Are So Far Apart

    Nov 15, 20265 minAudio

    A single statistic can make AI feel like a done deal - nearly every organization already on board, the window to act almost closed. But a competing figure from the U.S. Census Bureau tells a starkly different story....

    Credit the people on this episode

  4. 83% of Developers Use AI Tools — But Only 6.6% Actually Trust Them

    Nov 13, 20265 minAudio

    Widespread AI adoption among software developers is no longer a trend to watch - it's the current reality. But a sweeping Stack Overflow survey of nearly 31,000 developers reveals a striking contradiction at the heart...

    Credit the people on this episode

  5. Private RAG Over Microsoft 365: Permissions, Delta Queries, and What Actually Ships

    Nov 11, 20265 minAudio

    Enterprise teams keep hitting the same wall when grounding LLMs on SharePoint and OneDrive: a working prototype that fails the moment security asks who actually owns access to the returned content. This episode of...

    Credit the people on this episode