On 07/05/20, Avinash Kumar (avinash.vallarapu@xxxxxxxxx) 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. > > > I am working on a similar problem. > 1 database per each client may be a killer when you have a connection > pooler that creates a pool for a unique combination of (user,database). One of our clusters has well over 500 databases fronted by pg_bouncer. We get excellent connection "flattening" using pg_bouncer with per-database connection spikes dealt with through a reserve pool. The nice thing about separate databases is that it is easy to scale horizontally. Rory
