postgresql - How many schemas can be created in postgres

Question

While implementing solution to a multi tenant using postgres I needed an answer on how much the maximum schemas can reside in one postgres database.

question from:https://stackoverflow.com/questions/14893964/how-many-schemas-can-be-created-in-postgres

Answer 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.