Re: Postgres schema having > 20,000 schemas

On Wed, Jul 24, 2013 at 11:38:05PM +0530, Anand Muthukrishnan wrote:
> We want them all in one Database.
>
> Multi database architecture is giving high amount of overhead during database migrations and database connection
pooling.So we are evaluating single db with multi schema approach.  
>
> Also, is there any hard limit on number of schemas and tables that can be present in one postgres database?

Not really, unless you start getting into the 100M count.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +