________________________________________ From: Venkata B Nagothi <nag1010@xxxxxxxxx> Sent: Thursday, September 29, 2016 17:25 To: Rakesh Kumar Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Multi tenancy : schema vs databases On Fri, Sep 30, 2016 at 5:18 AM, Rakesh Kumar <rakeshkumar464@xxxxxxxxxxx<mailto:rakeshkumar464@xxxxxxxxxxx>> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
