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

Поиск
Список
Период
Сортировка
От Chris Angelico
Тема Re: maximum number of databases and / or schemas in a single database instance
Дата
Msg-id CAPTjJmqe=59prp9Ks9r6GXoLmg8PVe7KQTiDjk_PC1WAr7WT-w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: maximum number of databases and / or schemas in a single database instance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Sun, Aug 5, 2012 at 2:05 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Menelaos PerdikeasSemantix <mperdikeas.semantix@gmail.com> writes:
>> The following page:
>> http://www.postgresql.org/about/
>
>> 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)
>
> You can certainly have hundreds of schemas.

What about thousands of schemas? Is there significant cost to schemas
beyond the tables they contain?

Chris Angelico

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: maximum number of databases and / or schemas in a single database instance
Следующее
От: Mike Christensen
Дата:
Сообщение: Is this a Postgres Bug?