Re: Multi tenancy : schema vs databases

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Multi tenancy : schema vs databases
Date: 2016-09-30 09:11:32
Message-ID: 67e17198-f4af-aae8-1022-69a04b176d28@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2016-09-30 09:40:24 Re: pg_upgrade from 9.5 to 9.6 fails with "invalid argument"
Previous Message Rakesh Kumar 2016-09-30 09:06:29 Re: Multi tenancy : schema vs databases