Skip site navigation (1) Skip section navigation (2)

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

From: fulan Peng <fulanpeng(at)gmail(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: Can not create more than 32766 databases in ufs file system.
Date: 2009-09-12 18:49:59
Message-ID: bf0f1bc90909121149g37165fa1la11013deb338e69d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
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.

Responses

pgsql-hackers by date

Next:From: Mark MielkeDate: 2009-09-12 19:25:11
Subject: Re: Can not create more than 32766 databases in ufs file system.
Previous:From: Tom LaneDate: 2009-09-12 17:30:59
Subject: Re: plperl returning setof foo[]

pgsql-committers by date

Next:From: Mark MielkeDate: 2009-09-12 19:25:11
Subject: Re: Can not create more than 32766 databases in ufs file system.
Previous:From: Tom LaneDate: 2009-09-12 16:26:06
Subject: pgsql: Improve GRANT reference page's description of object ownership

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group