On Wed, Dec 3, 2008 at 11:05 AM, Josh Harrison <[EMAIL PROTECTED]> wrote: > > > On Wed, Dec 3, 2008 at 11:51 AM, Scott Marlowe <[EMAIL PROTECTED]> > wrote: >> >> On Wed, Dec 3, 2008 at 8:43 AM, Josh Harrison <[EMAIL PROTECTED]> wrote: >> > Hi, >> > >> > 1. Is there a limit on the number of databases that can be in a single >> > postgres cluster? >> >> No. I'm sure there's a practical limit into the thousands where >> things start to get slower. >> >> > 2. Is there any performance impacts associated with having too many >> > databases in a cluster? >> >> Define too many. I've run a couple hundred before without it being a >> problem. >> >> > 3. Is there a good magical number for this limit ? >> >> Only the one that your testing tells you there is. Got a rough guess >> of how many you want to run? How busy they'll be? that kind of >> thing. > > About 10-15 ?
That's hardly any really. At that point it's more about whether or not your server can support all the users / access going on at once. 15 or 1 db in the cluster, if you've got 200 users hitting it hard you'll need a big server. OTOH, 100 dbs in a cluster with a dozen or fewer average users is just fine. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
