Can not create more than 32766 databases in ufs file system.

Поиск
Список
Период
Сортировка
От fulan Peng
Тема Can not create more than 32766 databases in ufs file system.
Дата
Msg-id bf0f1bc90909121149g37165fa1la11013deb338e69d@mail.gmail.com
обсуждение исходный текст
Ответы Re: Can not create more than 32766 databases in ufs file system.
Список pgsql-committers
Hi, pgsql-committers!

I cannot created more than 32766 databases with freeBSD in one setup,
not as the document says, "as many as you like".
I found the problem is that the directory pgsql/data/base cannot hold
more than 32766 subdirectories.
I suggest to make 32766 subdirectories in base directory, say /base/0,
/base/1, .... /base/32765. Then in each subdirectory to put the
database description.
This way, we can have 32766x32766 databases. This is kind of "as many
as you like".
The ZFS system is not a solution for me. It is snail slow.

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

Предыдущее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Improve GRANT reference page's description of object ownership
Следующее
От: Mark Mielke
Дата:
Сообщение: Re: Can not create more than 32766 databases in ufs file system.