Re: Multi tenancy : schema vs databases - Mailing list pgsql-general

From Vick Khera
Subject Re: Multi tenancy : schema vs databases
Date
Msg-id CALd+dcei0CseoUpX-jZLvCeKnYOiKkXyOG-E-85j_0NF4-1caQ@mail.gmail.com
Whole thread Raw
In response to Re: Multi tenancy : schema vs databases  (John R Pierce <pierce@hogranch.com>)
Responses Re: Multi tenancy : schema vs databases
List pgsql-general
On Fri, Sep 30, 2016 at 5:11 AM, John R Pierce <pierce@hogranch.com> wrote:
> On 9/30/2016 2:06 AM, Rakesh Kumar wrote:
>>
>> We require complete data isolation. Absolutely nothing should be shared
>> between two tenants.
>>
>> WHy would multiple dbs be any worse than multiple schemas in performance?
>
>
> complete?  use 1000s of seperate VM instances, one per tennant.
>

Well, VM's don't always provide 100% isolation, so separate hardware,
with each on its own VLAN seems right to me. And then make sure your
switch doesn't leak across VLANs.

Your requirements need refinement, at the least :)


pgsql-general by date:

Previous
From: Igor Neyman
Date:
Subject: Re: executing os commands from a function
Next
From: Vick Khera
Date:
Subject: Re: Multi tenancy : schema vs databases