Database Scalability

Hi All,

We are using Amazon RDS PostgreSQL.
We have some multi-tenant solutions which are separating the tenant data in
Postgresql mainly in the following manner.

1. Using different schemas
2. Using different tables for different tenants.

I was just wondering what would be the best way to scale in case no. of
schemas or no. of tables limit increase and probably cross the limits of
PostgreSQL.

I understand that no. of schemas are unlimited in DB as per

https://www.postgresql.org/message-id/24478.1109618520%40sss.pgh.pa.us

and some limits on tables are mentioned here

https://www.postgresql.org/docs/12/limits.html

In case of table separated tenancy some tables might have more data than
other tables. In the case of the table itself growing in size I can look
for partitioning the data.

In the case of limits being reached in terms of tables and schemas (if any
) I understand that database sharding or horizontal scaling over multiple
database instances could be one solution. It will also help in having
more database connections/resources for an ever increasing number of
tenants . Obviously with the headache of defining a balanced sharding
strategy and maintaining it.

Thanks and Best Regards,

Saurav