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