Re: Experience with many schemas vs many databases

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: undisclosed user <lovetodrinkpepsi(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Experience with many schemas vs many databases
Date: 2009-11-15 19:25:26
Message-ID: dcc563d10911151125t558f2380m9afff25f9a335cdc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Nov 15, 2009 at 11:54 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
>
> Use schema.  Here's a pro tip: if you have any sql or pl/pgsql
> functions you can use the same function body across all the schema as
> long as you discard the plans when you want to move from schema to
> schema.

I too vote for schemas.

> I'm curious if those suggesting there is a practical upper limit of
> the number of schema postgres can handle have any hard information to
> back that up...

The real limit is performance of certain things over the catalogs, not
the number of schemas, but how many objects are in the db seem to
impact me more, and that's only with slony. Everything else runs fine
with ~40k objects in my db.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-11-15 20:32:39 Re: Experience with many schemas vs many databases
Previous Message undisclosed user 2009-11-15 19:07:06 Re: Experience with many schemas vs many databases