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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
