Re: Limit on number of databases in a Cluster ?

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Josh Harrison" <joshques(at)gmail(dot)com>
Cc: "General postgres mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Limit on number of databases in a Cluster ?
Date: 2008-12-03 16:51:19
Message-ID: dcc563d10812030851r69e381f6n8700386b3bdd83a2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 3, 2008 at 8:43 AM, Josh Harrison <joshques(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2008-12-03 17:00:23 Re: restored over postgres database
Previous Message Scott Marlowe 2008-12-03 16:49:54 Re: restored over postgres database