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. +