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
Список
Дерево обсуждения
Can not create more than 32766 databases in ufs file system. fulan Peng <fulanpeng@gmail.com>
Re: Can not create more than 32766 databases in ufs
file system. Mark Mielke <mark@mark.mielke.cc>
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)
Дата:
От: Mark Mielke
Дата: