Re: maximum number of databases and / or schemas in a single database instance

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема Re: maximum number of databases and / or schemas in a single database instance
Дата
Msg-id 66FBA1B2-070F-4B21-ABEC-41101EC8DFB0@silentmedia.com
обсуждение исходный текст
Ответ на maximum number of databases and / or schemas in a single database instance  (Menelaos PerdikeasSemantix <mperdikeas.semantix@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления: