Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.
Дата
Msg-id 4AAC2F01.3020803@dunslane.net
обсуждение исходный текст
Ответ на Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

Tom Lane wrote:
> So the question I would ask goes more like "do you really need 32K
> databases in one installation?  Have you considered using schemas
> instead?"  Databases are, by design, pretty heavyweight objects.
>
>             
>   

That's a fair question. OTOH, devising a scheme to get around it would 
not be terribly difficult, would it? I can imagine a scheme where the 
subdir for a database was lo/hi for some division of the database oid. I 
guess it could make matters ugly for pg_migrator, though.

cheers

andrew


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

Предыдущее
От: Mark Mielke
Дата:
Сообщение: Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: [COMMITTERS] Can not create more than 32766 databases in ufs file system.