Steve Manes <smanes@magpie.com> writes:
> Questions: is there a hard limit to the number of schemas you could have
> in a database?
No.
> Are there any caveats/pitfalls/pitbulls to having a
> large number of duplicate schemas in a database?
If that also implies a large number of tables, you might start to run
into filesystem-level bottlenecks due to having a large number of files
in the same directory. If you aren't using a filesystem that copes
gracefully with huge directories, you probably want to avoid having more
than a few thousand files per directory. (As of PG 8.0 you can work
around this to some extent by segregating tables into different
tablespaces.)
regards, tom lane
