Re: Limit on number of databases in a Cluster ? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Limit on number of databases in a Cluster ?
Date
Msg-id dcc563d10812030851r69e381f6n8700386b3bdd83a2@mail.gmail.com
Whole thread Raw
In response to Limit on number of databases in a Cluster ?  ("Josh Harrison" <joshques@gmail.com>)
Responses Re: Limit on number of databases in a Cluster ?  ("Josh Harrison" <joshques@gmail.com>)
List pgsql-general
On Wed, Dec 3, 2008 at 8:43 AM, Josh Harrison <joshques@gmail.com> 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.

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: restored over postgres database
Next
From: Bill Moran
Date:
Subject: Re: restored over postgres database