Postgres Pro
Downloads
Home   >   mailing lists

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  (Rakesh Kumar <rakeshkumar464@outlook.com>)
Re: Multi tenancy : schema vs databases  (Vick Khera <vivek@khera.org>)
List pgsql-general
Tree view 
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"