All posts
Internet Fundamentals

Multi-Tenancy Basics for B2B SaaS: Pooled vs Siloed, and Making Isolation Real

By

October 26, 2026

6 min read

Every B2B app has to keep one customer's data from another's. Shared tables with a tenant ID are cheapest and the most common; separate databases or accounts per tenant are easier to explain to enterprise buyers. The models, where isolation is actually enforced, noisy neighbours, and when to move a big customer to its own silo.

Multi-tenant
Internet Fundamentals
B2B SaaS
Row-Level Security
Architecture

Pooled (shared tables, tenant ID)

Database or schema per tenant

Account or stack per tenant

Cost per tenant

Lowest

Medium

Highest

Isolation

Logical, enforced by code and database policies

Strong at the data layer

Strongest: separate infrastructure

Operations

One schema to migrate

Migrations across many databases

Fleet management, per-tenant deploys

Enterprise questionnaires

Need careful explanation

Easier

Easiest; supports customer-managed keys and regions

Fits

Most SaaS, especially self-serve

Mid-market with data-sensitive customers

A few large or regulated customers

Want a second opinion on this for your system?

Book a free 30-minute call. You'll leave knowing what we'd do first and roughly what it costs, whether or not you hire us.

Making pooled isolation real

  • A tenant ID column on every tenant-owned table, never optional.

  • Enforcement in the database, not only in queries: Postgres row-level security keyed on a tenant setting for the connection or transaction.

  • Tenant derived from the authenticated session on the server, never from a request parameter the client controls.

  • Unique constraints and indexes that include the tenant ID.

  • Tests that try to read another tenant's data through every API, run in CI.

  • Tenant ID in every log line and trace, so incidents can be scoped.

Noisy neighbours

In a pooled system one large tenant's import or report can slow everyone. Per-tenant rate limits, per-tenant queues or fair scheduling for background work, and query timeouts keep one customer's spike from becoming everyone's outage.

hoolco Monthly Review

Once a month: what changed in tech that month and what it means for you, from cloud and AI to security and the tools you build with. Every item links to its source. No sales pitch, unsubscribe in one click.

As of October 26, 2026. Provided as is, for general information, and accurate to the best of our knowledge on the date shown. Not legal, compliance, tax, financial or other professional advice. Prices, limits and vendor services change; check current vendor documentation before relying on anything here. Terms of use.