> Typically I will have 1db per client and around 150 tables per db. So
> since I hope I didn`t work all those year for nothing .. I expect to
> have bunch of clients witch means the same amount of db since I have 1
> db/client.
>
> Can I hope having several hundred of db on 1 db server? Like 250 dbs =
> 250 client = 360 000 tables !!!
> So is there a limit for the number of db in the db server ?(this spec is
> not on the website)
I'll take a stab at this question.
Each table and database are referenced by an OID.
So the sum(tables) + sum(database) << max-size(OID).
In my case max-size of OID (I believe) is 9223372036854775807.
So if you limited yourself to 1% of the OIDs for use as tables and databases then you could
potentially have 92233720368547758 table or database.
Each database create produces a directory with the database OID:
./data/base/10792
./data/base/10793
./data/base/16814
...
...
since the creation of a new db produces a directory, one limitation would come from your
file-systems limitation on the number of sub-directories that are allowed.
Each table with-in the database is assigned an OID and is located inside the DB directory. So if
there is a file-system limitation on the number of files with-in a given directory it would also
be a limit to the number of tables that could be created for each database.
The only other limitation that I am aware of is the storage capacity of you DB server.
If there are additional limitations beyond these I would be interested in knowing about them and
adding them to the http://www.postgresql.org/about/ we be helpful also.
Regards,
Richard Broersma Jr.