How many schemas can be created in postgres
Solution 1:
We tested thousands schemas - with thousands tables without problem. There are a few known issues
- problems with GUI administration - slow start due read a complete object tree on start,
- problems with pg_dump - slow start of backup - needs lot of time for locking objects.
Solution 2:
According to Tom Lane, there are no limits on the maximum number of schemas per database Reference: https://www.postgresql.org/message-id/24478.1109618520%40sss.pgh.pa.us