Re: reasonable limit to number of schemas in a database?

Ben <bench(at)silentmedia(dot)com> writes:
> I'm considering re-architecting a database to make use of many, many
> schemas.... over time, it would probably grow to be on the order of 3,000
> or so, with each schema holding ~100 tables. Is that an absurd amount, or
> well within postgres' limits? I haven't been able to find any information
> on what penalties one pays as you increase the schema count.

The number of schemas doesn't scare me so much as the number of tables.
Are you using a filesystem that can cope gracefully with 300K files in
one directory? How many of these tables do you anticipate any one
session touching? (That last translates to catalog cache and lock table
space...)

Generally, when someone proposes a scheme like this, they are thinking
that N identical tables are somehow better than one table with an
additional key column. The latter is usually the better design, unless
you have special requirements you didn't mention.

regards, tom lane