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

Multi-Tenant Postgres: Choosing the Right Isolation Model for Your SaaS

Sep 23, 20265 minAudio

Multi-tenant data isolation isn't a detail you can defer - it's a foundational architectural choice that shapes migrations, compliance posture, backup strategy, and blast radius from day one. This episode of DEV.co walks through the three Postgres isolation models available to SaaS teams, drawing on this deep-dive on multi-tenant Postgres isolation for SaaS to help founders and engineers make an informed decision before it becomes an expensive one to reverse. The episode covers all three viable approaches in honest, practical detail - including where each one breaks down at scale: Shared schema (tenant ID column): The most common starting point - lowest per-tenant cost and simplest migrations, but widest blast radius; Postgres row-level security is essential, not optional, to close the data-leak gap. Schema-per-tenant: Meaningfully stronger isolation and trivially simple per-tenant backups or GDPR deletions, but Postgres catalog overhead starts to buckle around 500 tenants, and migrations become a distributed systems problem that requires a purpose-built runner. Database-per-tenant: The compliance answer for regulated industries and enterprise contracts with data-residency requirements - but every database is a separate migration target, backup schedule, and monitoring endpoint, making it operationally costly without a genuine contractual reason. Hybrid routing layer: A pragmatic middle ground that uses shared schema for the long tail of smaller tenants while routing enterprise accounts to dedicated databases - with a tenant directory abstraction that's worth building carefully regardless of which model you start with. Horizontal scaling with Citus: When a single Postgres primary is no longer enough, Citus preserves the standard Postgres interface while distributing data by tenant ID; the Notion architecture - workspace ID as the partition key, 480 logical shards across 32 physical databases - is the canonical reference point. The four-input decision framework: Expected tenant count at 24 months, data sensitivity, whether any single customer will pay for dedicated isolation, and the team's operational maturity to run multiple databases. For more on building thoughtfully with AI-assisted workflows in the same codebase where these decisions live, check out the DEV.co episode Why Vibe Coding Still Requires a Human Element. 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