News for hackers. Stuff that matters.
Re:Our Multi-Tenancy Journey with Postgres Schemas and Apart... by Todd on Tuesday December 06, 2016 @01:25PM (#13116995)
One advantage of storing multiple schemas in one database is that a connection can be shared (assuming a shared authentication strategy). This is because, as mentioned in the article, the switch to one schema vs. another happens after the connection. This can make it easier to pool connections and to share servers across tenants. A tenant_id approach gives the same benefit without the isolation, but a separate database (even on the same server) doesn't.

Edit: typo

There are no comments on this comment yet.