> 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.
