Multi tenancy : schema vs databases

From: Rakesh Kumar <rakeshkumar464(at)outlook(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Multi tenancy : schema vs databases
Date: 2016-09-29 19:18:53
Message-ID: DM2PR05MB6221A469193361C5AD3DCC48CCE0@DM2PR05MB622.namprd05.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi

I would like to know which technique is better for supporting multi-tenancy=
applications, going upto hundreds or even thousands of tenants.

1 - One database with difference schemas (one schema per tenant)
or
2 - One database per tenant.

The points to be considered are:

1 - which is more light weight from resources point of view.
2 - which is easier for backup/restore
3 - Which is better from security p.o.v

It is possible that this question has been asked before. Is there a link t=
o earlier posts on the subject.

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Jungwirth 2016-09-29 19:19:13 Re: Time travel?
Previous Message Kevin Grittner 2016-09-29 19:17:13 Re: Time travel?