Postgres Pro
Downloads
Home   >   mailing lists

Re: maximum number of databases and / or schemas in a single database instance - Mailing list pgsql-general

From Ben Chobot
Subject Re: maximum number of databases and / or schemas in a single database instance
Date
Msg-id 66FBA1B2-070F-4B21-ABEC-41101EC8DFB0@silentmedia.com
Whole thread Raw
In response to maximum number of databases and / or schemas in a single database instance  (Menelaos PerdikeasSemantix <mperdikeas.semantix@gmail.com>)
List pgsql-general
Tree view
On Aug 4, 2012, at 12:24 PM, Menelaos PerdikeasSemantix wrote:

The following page:


mentions some limits but not the following:

[1] maximum number of databases per database server instance
[2] maximum number of schemas per database

Is there empirical information on whether both these values can be as high as a few hundreds? (I don't really need any more for my use case)

As a anecdote, we have a postgres cluster running a single db with ~1200 schemas, each schema having ~600 relations. Tab-completion is a little slow, but http://archives.postgresql.org/pgsql-general/2012-03/msg00666.php allowed things to be quite reasonable. 

pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: How to analyze load average ?
Next
From: David Salisbury
Date:
Subject: Re: Hi,Frirends, are there any commands in pgsql/bin/ corresponding "create tablespace"?