DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=m4kxP/9i8Qk7TE9p5NKnZgcbovOQ4o/PdW1+nKE9zHMS8H2h447Pus/L6F3Mi+p6NQW2WIitCBKLM8aYqHwcy7ji70c/Sj1Q2GWJq0NUBEYIgcVAQWrTldR/yc80lF16T9BhMJriElquSwFWkJWipA2HdXbfloXbdI9rYWkug4Q=
	;
Message-ID: <20060703170027.37006.qmail@web31809.mail.mud.yahoo.com>
Date: Mon, 3 Jul 2006 10:00:27 -0700 (PDT)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Re: Is postgresql ca do the job for software deployed in ASP ou SaaS
	mode?
To: David Gagnon <dgagnon@siunik.com>, pgsql-performance@postgresql.org
In-Reply-To: <44A9026D.7090903@siunik.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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