On Thu, May 7, 2020 at 1:05 PM samhitha g <samhithagaruda...@gmail.com>
wrote:

> Our application serves multiple tenants. Each tenant has the schema with a
> few hundreds of tables and few functions.
> We have 2000 clients so we have to create 2000 schemas in a single
> database.
>

That is one option but I wouldn't say you must.  If you cannot get
individual tables to be multi-tenant you are probably better off having one
database per client on a shared cluster - at least given the size of the
schema and number of clients.

David J.

Reply via email to