From: Richard Broersma Jr <rabroersma@yahoo.com>
To: David Gagnon <dgagnon@siunik.com>
To: pgsql-performance@postgresql.org
Subject: Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode?
Date: Mon, 3 Jul 2006 10:00:27 -0700 (PDT)
Message-ID: <20060703170027.37006.qmail@web31809.mail.mud.yahoo.com> (raw)
In-Reply-To: <44A9026D.7090903@siunik.com>
> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rabroersma@yahoo.com, dgagnon@siunik.com
Subject: Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode?
In-Reply-To: <20060703170027.37006.qmail@web31809.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox