| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Mielke | 2009-09-12 19:25:11 | Re: Can not create more than 32766 databases in ufs file system. |
| Previous Message | Tom Lane | 2009-09-12 16:26:06 | pgsql: Improve GRANT reference page's description of object ownership |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Mielke | 2009-09-12 19:25:11 | Re: Can not create more than 32766 databases in ufs file system. |
| Previous Message | Tom Lane | 2009-09-12 17:30:59 | Re: plperl returning setof foo[] |