Search Postgresql Archives

Re: Limit on number of databases in a Cluster ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Dec 3, 2008 at 8:43 AM, Josh Harrison <joshques@xxxxxxxxx> 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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux