Can not create more than 32766 databases in ufs file system. - Mailing list pgsql-committers

From fulan Peng
Subject Can not create more than 32766 databases in ufs file system.
Date
Msg-id bf0f1bc90909121149g37165fa1la11013deb338e69d@mail.gmail.com
Whole thread Raw
Responses Re: Can not create more than 32766 databases in ufs file system.
List 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 by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Improve GRANT reference page's description of object ownership
Next
From: Mark Mielke
Date:
Subject: Re: Can not create more than 32766 databases in ufs file system.