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

From John R Pierce
Subject Re: Multi tenancy : schema vs databases
Date
Msg-id 67e17198-f4af-aae8-1022-69a04b176d28@hogranch.com
Whole thread Raw
In response to Re: Multi tenancy : schema vs databases  (Rakesh Kumar <rakeshkumar464@outlook.com>)
Responses Re: Multi tenancy : schema vs databases
Re: Multi tenancy : schema vs databases
List pgsql-general
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.


ok, thats ridiculous, isn't it.   so now its time to find a compromise.



--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: Rakesh Kumar
Date:
Subject: Re: Multi tenancy : schema vs databases
Next
From: Thomas Kellerer
Date:
Subject: Re: pg_upgrade from 9.5 to 9.6 fails with "invalid argument"