Re: Maximum # of schemas

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