Re: Multi tenancy : schema vs databases

On 30/09/2016 18:45, Rakesh Kumar wrote:
>> I've been reading this discussion with great interest, to see what other
>> Postgres experts think. :-)
> I am bit disappointed that most of the replies are questioning why we are
> doing what we are doing. Once again, we (db designers) have no choice
> in that. What I would like to know that which one is better :- multiple db
> vs multiple schema. Read few interesting arguments and noted that
> connection pooling works better with multiple schemas than dbs. Anything else?

Since you missed it, i write it once again :

same organization (e.g. holding) -> schemas
different organizations -> DBs

>
> thanks
>

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt