---
title: "Discussion on \"Multi-Tenant SaaS Architecture on PostgreSQL: Silo, Bridge or Pool?\" | Hashnode"
description: "Discussion on \"Multi-Tenant SaaS Architecture on PostgreSQL: Silo, Bridge or Pool?\". Database per tenant, schema per tenant or shared tables with row-level security? How each model works on PostgreSQL, what it costs and which to choose."
url: "https://hashnode.com/posts/multi-tenant-saas-architecture-on-postgresql-silo-bridge-or-pool/6acab5466fd21317d56b4fc2"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Multi-Tenant SaaS Architecture on PostgreSQL: Silo, Bridge or Pool?](https://znovastudio.hashnode.dev/multi-tenant-saas-architecture-on-postgresql-silo-bridge-or-pool?utm_source=hashnode&utm_medium=feed)

Database per tenant, schema per tenant or shared tables with row-level security? How each model works on PostgreSQL, what it costs and which to choose.

Oct 10 · 7 min read · znovastudio.hashnode.dev  
Read the article

-   [#postgres](https://hashnode.com/tag/postgres)
-   [#saas](https://hashnode.com/tag/saas)
-   [#database](https://hashnode.com/tag/database)
-   [#architecture](https://hashnode.com/tag/architecture)
-   [#multi-tenant](https://hashnode.com/tag/multi-tenant)

## Written by

[Ahsan Nadeem](https://hashnode.com/@ashtech52)

@ashtech52 · Lahore, Pakistan

  
[View profile](https://hashnode.com/@ashtech52)

Full Stack Software Engineer

Full Stack Software Engineer

## Responses 2

Markdown supported · ⌘↵ to post

[Oct 11](https://hashnode.com/posts/multi-tenant-saas-architecture-on-postgresql-silo-bridge-or-pool/6acab5466fd21317d56b4fc2/comment/6acaf445940bea2fb15b9869)

Clear comparison. The point I would underline is that the tenancy model is rarely a pure technical choice. It usually follows from two business questions that are worth answering before any schema work: does any customer contractually need their data isolated, and how bad is it if one large tenant slows everyone else down.

For most early SaaS products we start with the pool model and row level security, because it keeps migrations and operations simple, and we design the tenant key so that moving a single large customer into its own schema or database later is a contained job rather than a rewrite. Writing that escape route into the original scope costs very little and removes a lot of fear when the first enterprise deal asks about isolation.

Did you find the bridge model worth its migration overhead in practice, or mostly a stepping stone?

[Ahsan Nadeem](https://hashnode.com/@ashtech52)

[Oct 12](https://hashnode.com/posts/multi-tenant-saas-architecture-on-postgresql-silo-bridge-or-pool/6acab5466fd21317d56b4fc2/comment/6acaf445940bea2fb15b9869#reply-6acc6cd0a7fb19df57fcafe5)

Thanks, good point on the escape route. We've stayed on pool + RLS ourselves, so no production experience with bridge. Running every migration per schema feels like a cost you only pay if tenants need heavy customisation.
