Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V23fS-0004k0-7J for pgsql-admin@arkaria.postgresql.org; Wed, 24 Jul 2013 18:20:06 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1V23fR-0004Gu-LW for pgsql-admin@arkaria.postgresql.org; Wed, 24 Jul 2013 18:20:05 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V23cs-0004Bc-Dj for pgsql-admin@postgresql.org; Wed, 24 Jul 2013 18:17:26 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V23cp-0007tC-Qn for pgsql-admin@postgresql.org; Wed, 24 Jul 2013 18:17:25 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1V23cp-0007ai-1u; Wed, 24 Jul 2013 14:17:23 -0400 Date: Wed, 24 Jul 2013 14:17:23 -0400 From: Bruce Momjian To: Anand Muthukrishnan Cc: "pgsql-admin@postgresql.org" Subject: Re: Postgres schema having > 20,000 schemas Message-ID: <20130724181723.GE31462@momjian.us> References: <20130724142155.GD31462@momjian.us> <158B9BCD-BE51-4AA4-A92C-9E056C2C1177@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <158B9BCD-BE51-4AA4-A92C-9E056C2C1177@gmail.com> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -0.0 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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 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