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.
While doing this, i observed that the catalog tables pg_attribute, pg_class, pg_depend grow huge in count and size.
Please attach numbers to "huge". We don't know what "huge" means to you.
"2000 * a few hundred" tables is certainly getting to the point where it makes sense to be concerned. But my concern would be more about backup and recovery, version upgrades, pg_dump, etc. not about daily operations.
