| From: | Rakesh Kumar <rakeshkumar464(at)outlook(dot)com> |
|---|---|
| To: | Venkata B Nagothi <nag1010(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Multi tenancy : schema vs databases |
| Date: | 2016-09-30 00:16:03 |
| Message-ID: | DM2PR05MB6228322B1A4220BDF495E0D8CC10@DM2PR05MB622.namprd05.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
________________________________________
From: Venkata B Nagothi <nag1010(at)gmail(dot)com>
Sent: Thursday, September 29, 2016 17:25
To: Rakesh Kumar
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Multi tenancy : schema vs databases
On Fri, Sep 30, 2016 at 5:18 AM, Rakesh Kumar <rakeshkumar464(at)outlook(dot)com<mailto:rakeshkumar464(at)outlook(dot)com>> wrote:
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.
Did you mean one database with-in a postgresql cluster ?
Yes. Say something like this within a PG cluster
db4978
db6234
...
100s of such databases.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2016-09-30 00:16:41 | Re: isnull() function in pgAdmin3 |
| Previous Message | Cachique | 2016-09-29 23:40:51 | Re: Filtering by UUID |